| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
|
Copy data to another wb based on specific criteria
I realized this post should be in the programming questions and I have
created a new entry there. "ksh" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing specific Columns based on Criteria | Excel Discussion (Misc queries) | |||
| Copy Row to worksheet based on criteria | Excel Discussion (Misc queries) | |||
| Copy entire row to another sheet based on a criteria | Excel Discussion (Misc queries) | |||
| searching for specific criteria and then doing an action based on | Excel Discussion (Misc queries) | |||
| I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
Linear Mode
