Worksheet 1, columns A to G contain raw data.
Column A only contains a number 1 to 10 inclusively.
I'd like to create a MACRO button that when pressed will do the following:-
IF A = 1, copy paste that row of data to Sheet1,
IF A = 2, copy paste that row of data to Sheet2
etc to A = 10 ..... sheet10.
As far as macro's go ... I'm guessing that this will be a fairly easy task and I'm interested to see the structure of the VBA coding so that I can use something similar in some other macro's that I need to do.
Thanks in advance.
Column A only contains a number 1 to 10 inclusively.
I'd like to create a MACRO button that when pressed will do the following:-
IF A = 1, copy paste that row of data to Sheet1,
IF A = 2, copy paste that row of data to Sheet2
etc to A = 10 ..... sheet10.
As far as macro's go ... I'm guessing that this will be a fairly easy task and I'm interested to see the structure of the VBA coding so that I can use something similar in some other macro's that I need to do.
Thanks in advance.