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! |
#2
|
|||
|
|||
Is this a repetitive task? If not, you can use Data/AutoFilter, then copy the
displayed rows to the appropriate sheet, then go on to the next name. Or sort by column B and copy a section at a time. On Fri, 4 Mar 2005 18:05:02 -0800, Michael A <Michael wrote: 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! |
Reply |
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) |