C
Carolina Girl
I’m having problems with asking this question correctly so please bare with
me…. In my workbook I have a worksheet titled “CMG SA Master†and six other
sheets “test1â€,†test2â€,†test3†etc… now on worksheet “CMG SA Master†I
have columns 1 to 300 (this may grow) and rows A (this will not grow).
What I need is a Macro that will look at A2 and if it has an “x†in it past
the information in A22 into worksheet “test1†if not look at B2 if it has
an “x†then do the same on worksheet “test2†if not continue on 4 more time
(C2 – test3, D2 test4 etc…) now it can have an x in A2 and B2 I would need it
to show up on both sheets “test 1 and “Test2â€. Then go down to the next row
and do the same. See example
A B C D E F G H
1
2 x x x Processing Joy
3 x x x accounts
Header row has already been set up on all the sheets row 1. Please help I
was asked to completed this by noon and that did not happen…. Thanks in
advance….
me…. In my workbook I have a worksheet titled “CMG SA Master†and six other
sheets “test1â€,†test2â€,†test3†etc… now on worksheet “CMG SA Master†I
have columns 1 to 300 (this may grow) and rows A (this will not grow).
What I need is a Macro that will look at A2 and if it has an “x†in it past
the information in A22 into worksheet “test1†if not look at B2 if it has
an “x†then do the same on worksheet “test2†if not continue on 4 more time
(C2 – test3, D2 test4 etc…) now it can have an x in A2 and B2 I would need it
to show up on both sheets “test 1 and “Test2â€. Then go down to the next row
and do the same. See example
A B C D E F G H
1
2 x x x Processing Joy
3 x x x accounts
Header row has already been set up on all the sheets row 1. Please help I
was asked to completed this by noon and that did not happen…. Thanks in
advance….