| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
MACRO - copy rows based on value in column to another sheet
Any help would be greatlyi appreciated.
I need a macro that copys rows on a spreadsheet to another spreadsheet based on the value thats in the B column. For example, b4 has "RES" as the value, so i want row 4 to go to the first available line on the RES sheet. If it had "BOB" as the value, i would like it to go to the BOB sheet on the first available line. I would like to be able to do this with the entire sheet. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inset rows and copy formatting , excel macro | Excel Discussion (Misc queries) | |||
| Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
| how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| macro - adding rows to a column that is summed | Excel Discussion (Misc queries) | |||
Threaded Mode
