Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help Needed...copy into new sheet based on account number
I have a weekly report that shows transactions for 7 accounts. I need to
break out the data into separate tabs based on the account number (all of account #1's transactions in a tab, account #2 in a tab, etc). I have written the macro to create the new sheets but I cannot figure out what the VBA would look like for actually selecting the row(s) based on the account number field and pasting it into a new sheet. This is going to be a variable range report (different amount of transactions each week) so I need it to be able to search the data, copy, and paste into the new sheets. Any ideas??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Name based on the account number | Excel Discussion (Misc queries) | |||
Macro to copy and paste to another sheet, based on if-then-else | Excel Programming | |||
VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column | Excel Programming | |||
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 |