Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do I Copy Only Select Data?
I'm looking for a macro that will copy data from a "master" sheet to
individual sheets based on the sheet name. What I have is a master sheet containing 4 columns of data (one of which is a group id) that I manually sort by group and then manually copy that groups information into their own sheet. There are approximately 20 sheets (groups). What I need is a macro that will look at the sheet name (which is the group id) and then go back to the master sheet and pull all the rows of data that match that sheet name. Oh, I do have some sheets in the workbook that would be excluded from this. I know nothing about writing macros so any help will be greatly appreciated! Thanks! Randy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to select and copy rows only containing data | Excel Discussion (Misc queries) | |||
Select a file, copy it and change some data | Excel Programming | |||
Copy and Paste select data to another workbook. | Excel Programming | |||
Select certain data from a Pivot and copy this into Powerpoint | Excel Programming | |||
find specific data in row and select and copy entirerow | Excel Programming |