Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut rows from one sheet into multiple sheets based on a criteria in first column
I am trying to cut or copy rows from one sheet into certain sheets
based on what is in the first cell in the row. ex A B C 1 D d 1 d d 5 d d 5 d d For all rows that have a 1 in column a I want to copy or cut the row and paste it into a sheet called Reg 1. Then for all rows that a 5 in column a I want to copy or cut the row and paste it to a sheet called Reg 5. so on and so on. thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut rows from one sheet into multiple sheets based on a criteria in first column
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count rows based on multiple criteria | Excel Worksheet Functions | |||
Using VBA select sll sheets based on Criteria on each sheet. | Excel Discussion (Misc queries) | |||
Seperate data from one sheet to multiple sheets based on a column | Excel Discussion (Misc queries) | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |