Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy rows to new sheet based on value in column A
I have a sheet which a person will add data to every day. In the left hand column are the account numbers. I need a macro or VBA to copy the rows of each individual account to a tab (worksheet) with that number and there should be no gaps.
I don't want to use autofilter on the original sheet as this reorders the data and confuses the person who does input. Is there any command that goes down one row at a time, copies all rows that match a value in column A then puts them in order on a new sheet? Thanks! Example: Account No. Amount 153 50 167 75 175 43 153 66 Copy all rows with instance of "153" into new spreadsheet that should look like this: Account No. Amount 153 50 153 66 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria | Excel Programming | |||
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) | |||
MACRO - copy rows based on value in column to another sheet | Excel Programming |