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.

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.

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.

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.