Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Specific Data
I have one worksheet named "Data" that is basically a database of information
for up to 20 representatives. Each representative may be named several times throughout the worksheet in column B. I need a macro that will copy any row with Representative #1's name and all the information in that row to a worksheet that has been named for that specific representative, adding each additional row below the first with no blank rows. I need to do the same for Representative #2, and so on. There may or may not be 20 representatives at any given time and so I don't want a specified number of sheets/representatives to be designated. I want to do the same thing copying data that was entered for a certain month (the date field is column A) to a worksheet that has been named Jan08, Feb08, Mar08, etc. Ultimately, I want any data for a specific representative to be copied to a sheet named for that representative and any data entered in a specific month to be copied to a sheet named for that month. I hope that makes sense. Thank you so much in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Specific Data
Hi Chersie,
The first port of call for operations involving filtering or copying data between worksheets should be Ron de Bruin's estimable site: http://www.rondebruin.nl/ More particularly, for your requirement, see Rons code at: Create a new sheet for all Unique values or paste it below the existing data if the sheet exists http://www.rondebruin.nl/copy5.htm#Add --- Regards. Norman "Chersie" wrote in message ... I have one worksheet named "Data" that is basically a database of information for up to 20 representatives. Each representative may be named several times throughout the worksheet in column B. I need a macro that will copy any row with Representative #1's name and all the information in that row to a worksheet that has been named for that specific representative, adding each additional row below the first with no blank rows. I need to do the same for Representative #2, and so on. There may or may not be 20 representatives at any given time and so I don't want a specified number of sheets/representatives to be designated. I want to do the same thing copying data that was entered for a certain month (the date field is column A) to a worksheet that has been named Jan08, Feb08, Mar08, etc. Ultimately, I want any data for a specific representative to be copied to a sheet named for that representative and any data entered in a specific month to be copied to a sheet named for that month. I hope that makes sense. Thank you so much in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Specific Data
Hi Norman,
Thank you for your response. I am working at setting this up and I think it will work just fine for most of my situation. I am not sure however how to get it to work for my months of Jan08, Feb08, etc. The reason being is that column A will have dates such as 1/17/08, etc., and not the worksheet tab name. I need something that will say, if the date in column A is within the month of January, copy that row's data to the worksheet named Jan08, and on and on. I hope this makes sense and you can assist me with this! Thanks again, "Norman Jones" wrote: Hi Chersie, The first port of call for operations involving filtering or copying data between worksheets should be Ron de Bruin's estimable site: http://www.rondebruin.nl/ More particularly, for your requirement, see Rons code at: Create a new sheet for all Unique values or paste it below the existing data if the sheet exists http://www.rondebruin.nl/copy5.htm#Add --- Regards. Norman "Chersie" wrote in message ... I have one worksheet named "Data" that is basically a database of information for up to 20 representatives. Each representative may be named several times throughout the worksheet in column B. I need a macro that will copy any row with Representative #1's name and all the information in that row to a worksheet that has been named for that specific representative, adding each additional row below the first with no blank rows. I need to do the same for Representative #2, and so on. There may or may not be 20 representatives at any given time and so I don't want a specified number of sheets/representatives to be designated. I want to do the same thing copying data that was entered for a certain month (the date field is column A) to a worksheet that has been named Jan08, Feb08, Mar08, etc. Ultimately, I want any data for a specific representative to be copied to a sheet named for that representative and any data entered in a specific month to be copied to a sheet named for that month. I hope that makes sense. Thank you so much in advance! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Specific Data
You can use this add-in to filter on month/year
http://www.rondebruin.nl/easyfilter.htm Or add a helper column in your data =TEXT(MONTH(A1),"mmm")& YEAR(A1) You can filter on that column then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chersie" wrote in message ... Hi Norman, Thank you for your response. I am working at setting this up and I think it will work just fine for most of my situation. I am not sure however how to get it to work for my months of Jan08, Feb08, etc. The reason being is that column A will have dates such as 1/17/08, etc., and not the worksheet tab name. I need something that will say, if the date in column A is within the month of January, copy that row's data to the worksheet named Jan08, and on and on. I hope this makes sense and you can assist me with this! Thanks again, "Norman Jones" wrote: Hi Chersie, The first port of call for operations involving filtering or copying data between worksheets should be Ron de Bruin's estimable site: http://www.rondebruin.nl/ More particularly, for your requirement, see Rons code at: Create a new sheet for all Unique values or paste it below the existing data if the sheet exists http://www.rondebruin.nl/copy5.htm#Add --- Regards. Norman "Chersie" wrote in message ... I have one worksheet named "Data" that is basically a database of information for up to 20 representatives. Each representative may be named several times throughout the worksheet in column B. I need a macro that will copy any row with Representative #1's name and all the information in that row to a worksheet that has been named for that specific representative, adding each additional row below the first with no blank rows. I need to do the same for Representative #2, and so on. There may or may not be 20 representatives at any given time and so I don't want a specified number of sheets/representatives to be designated. I want to do the same thing copying data that was entered for a certain month (the date field is column A) to a worksheet that has been named Jan08, Feb08, Mar08, etc. Ultimately, I want any data for a specific representative to be copied to a sheet named for that representative and any data entered in a specific month to be copied to a sheet named for that month. I hope that makes sense. Thank you so much in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data to a specific row | New Users to Excel | |||
Copy specific data to second worksheet | New Users to Excel | |||
Copy specific data over to other worksheet | Excel Programming | |||
Copy and Paste specific data | Excel Programming | |||
copy/print specific data | Excel Worksheet Functions |