| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
looking for a macro
I am looking for a macro that will help me with my problem.... Im 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:P (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 A2:P2 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 Processing Joy 3 x x x access Pro Header row has already been set up on all the sheets row 1.. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Threaded Mode
