Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: formula=auto copy from sheet1, A1 only if data in field E1 .
I have a master list with columns a-k each with a unique title, (example:
Resource name, leader name, VP name, SVP name, Region, etc.) I have one sheet for each of the possible regions(NY, Florida, Sydney, UK, etc.) I need to create a formula/code in the cell, or create a macro that will copy row 2 from the master list, if the date in cell E2 is equal to NY and past it in the next available row in the NY sheet. I'm trying to automate the process of sorting all the data on the master list by region and/or copying/pasteing it into the appropriate sheet identified for that region. I could have as many as 2000 rows of data in the master list with 15 possible regions however each row would have only 1 region identified in column E. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula=auto copy from sheet1, A1 only if data in field E1 .
Sounds like you want to filter on region and copy all the records for that
region. Ron de Bruin has such code: http://www.rondebruin.nl/tips.htm go to Copy records with the same value in a column to a new sheet or workbook -- Regards, Tom Ogilvy "pjaMN" wrote in message ... I have a master list with columns a-k each with a unique title, (example: Resource name, leader name, VP name, SVP name, Region, etc.) I have one sheet for each of the possible regions(NY, Florida, Sydney, UK, etc.) I need to create a formula/code in the cell, or create a macro that will copy row 2 from the master list, if the date in cell E2 is equal to NY and past it in the next available row in the NY sheet. I'm trying to automate the process of sorting all the data on the master list by region and/or copying/pasteing it into the appropriate sheet identified for that region. I could have as many as 2000 rows of data in the master list with 15 possible regions however each row would have only 1 region identified in column E. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill certain data from sheet1 to sheet 2 | Excel Worksheet Functions | |||
Macro to Copy data from a list in sheet1 and paste into sheet2 | Excel Discussion (Misc queries) | |||
copy data from sheet1 to sheet but in varying positons | Excel Worksheet Functions | |||
copy data from sheet1 based on criteria in sheet2 to sheet3 | Excel Programming | |||
Copy Data (Sheet2 to Sheet1) Updates Web Query | Excel Programming |