bendad2112
New Member
- Joined
- Nov 5, 2004
- Messages
- 25
Hi,
I have a spreadsheet that I need to sort by several different criteria and then once those criteria are found, cut and paste them to a new spreadsheet and delete the spaces from the original sheet. For example I have the following:
Column 1 "Type"
Column 2 "Transaction"
Column 3 "Activity"
Column 4 "INV"
I need to cut out all type of 2,3,4 several different transactions (219,275,301) and several different INV. I can do them all separately. I do not know how to create a macro to "find" what I need cut.
I have a spreadsheet that I need to sort by several different criteria and then once those criteria are found, cut and paste them to a new spreadsheet and delete the spaces from the original sheet. For example I have the following:
Column 1 "Type"
Column 2 "Transaction"
Column 3 "Activity"
Column 4 "INV"
I need to cut out all type of 2,3,4 several different transactions (219,275,301) and several different INV. I can do them all separately. I do not know how to create a macro to "find" what I need cut.