Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data to another wb based on specific criteria.
Each month I receive 6 workbooks of data. Each workbook is based on data
type and has the data listed by country within each workbook. I have to create a workbook for each country which has a spreadsheet within each for the separate data types but only includes that countrys data. Example of 1 workbook CTY PCC NAME CATERGORY LNIA AR 1536 ARGENTINA-MAIN INACTIVE TA B9F9 AR 2180 ARGENTINA-MAIN INACTIVE TA 35A9 AR R150 ARGENTINA-MAIN INACTIVE TA 36A8 BR AC12 BRAZIL-SA3 INACTIVE TA 9RE7 BR B220 BRAZIL-SA3 INACTIVE TA 9RE7 BR 1780 BRAZIL-SA3 INACTIVE TA 9RE7 BR R100 BRAZIL-SA3 INACTIVE TA 9RE7 CL Q150 TURISMO-A INACTIVE TA 1510 CL A200 TURISMO-A INACTIVE TA 1510 CL 2105 TURISMO-A INACTIVE TA 1510 Currently I manually open each workbook put an auto filter on the worksheet, filter by country, and then copy the filtered data into that countrys workbook. I can do this by formula, but it is very cumbersome and creates a huge worksheet once I try to incorporate all countries and data types. Is there a way to do this in VBA. I currently use excel 2003 and have a limited amount of VBA experience. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data to another wb based on specific criteria.
I was able to find what I needed on Ron de Bruin's website.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find and copy rows based on specific criteria? | New Users to Excel | |||
Copy data to another wb based on specific criteria | Excel Discussion (Misc queries) | |||
Macro or formula to copy data based on criteria | Excel Programming | |||
copy data from sheet1 based on criteria in sheet2 to sheet3 | Excel Programming | |||
Cut & Paste Data into different worksheet based on specific criteria | Excel Programming |