To add code, go to tab at botttom of worksheet (normally sheet1) and right
click. Then choose view code. Paste code below in window.
worksheet_change functoin only works on one worksheet (the sheet where the
code was placed). code below when data is entered in column 5 ("E") will
copy the entire row of data to sheet2.
Sub worksheet_change(ByVal Target As Range)
For Each cell In Target
If Target.Column = 5 Then
Target.EntireRow.Copy Destination:= _
Sheets("Sheet2").Rows(Target.Row)
End If
Next cell
End Sub
"Chris Rees" wrote:
> Do you know where I could find an example of a worksheet_change macro?
>
> "Joel" wrote:
>
> > I think a worksheet_change macro will work. You can have the macro
> > automatically copy the data entered in one column to another sheet as well as
> > copying data in other columns. You can have a choice of copying the data or
> > linking the data between the worksheets by having the macro write a formula
> > instead of the data.
> >
> > "Chris Rees" wrote:
> >
> > > I am creating a spreadsheet for other people to use in which they fill in an
> > > overview page which then feeds into 5 other sheets.
> > >
> > > Which sheet the data feeds into is specified by a single column but all the
> > > data around 60 columns needs to also be copied across to the the other
> > > sheets. I would prefer not to do lots of if statements as this would slow
> > > down the speed of the computer the users will be working on.
> > >
> > > Finally if this is possible and requires a macro I would like it to run
> > > automatically and not involve the user clicking on a button or equivalent.
> > >
> > > Is any of this possible, a huge thank you to anyone who can help.
|
Similar Threads
