Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to filter, create tab on filter and copy/paste
I'm pretty new to creating macros and don't have a good grasp on it
yet. I am creating a spreadsheet where data will be imported into an "All" worksheet. I then need the macro to filter on the "Product Code" column, create a new worksheet for each new product code (as well as naming the tab the respective PC number), then copying the info from the rows with PC and pasting into the respective worksheet. Any help would be greatly appreciated!! It's expected I do this even though no one else around here has any clue HOW! Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to filter, create tab on filter and copy/paste
See this page on Ron de Bruin's site:
http://www.rondebruin.nl/copy5.htm -- Regards, Tom Ogilvy "Jen" wrote: I'm pretty new to creating macros and don't have a good grasp on it yet. I am creating a spreadsheet where data will be imported into an "All" worksheet. I then need the macro to filter on the "Product Code" column, create a new worksheet for each new product code (as well as naming the tab the respective PC number), then copying the info from the rows with PC and pasting into the respective worksheet. Any help would be greatly appreciated!! It's expected I do this even though no one else around here has any clue HOW! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter, Copy and Paste | Excel Discussion (Misc queries) | |||
Copy Paste in Filter | Setting up and Configuration of Excel | |||
Macro to copy and paste into a custom filter | Excel Discussion (Misc queries) | |||
Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
Macro w/filter, copy, paste,& sort isn't working consistently | Excel Programming |