Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from Multiple worksheets to a single worksheet
I have a series of worksheets (about 180) that contain a form with vaious
data on the form. Each worksheet has the data in the exact location. I would like to "merge" these records on to one worksheet in table format. The worksheet names are all of the same format "mmddyy 1st" or "mmddyy 2nd" to distiquish between 1st and 2nd shift of each day. I am very new to VBA programming in Excel and need the basics as well. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from Multiple worksheets to a single worksheet
Hi Albie
You can start here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Albie" wrote in message ... I have a series of worksheets (about 180) that contain a form with vaious data on the form. Each worksheet has the data in the exact location. I would like to "merge" these records on to one worksheet in table format. The worksheet names are all of the same format "mmddyy 1st" or "mmddyy 2nd" to distiquish between 1st and 2nd shift of each day. I am very new to VBA programming in Excel and need the basics as well. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from Multiple worksheets to a single worksheet
I forgot one major detail: On the worksheets there might be multiple
entries, that when copied should get some universal entries on the form (date, shift, etc). Not all of the worksheets have the same number of entries... "Albie" wrote: I have a series of worksheets (about 180) that contain a form with vaious data on the form. Each worksheet has the data in the exact location. I would like to "merge" these records on to one worksheet in table format. The worksheet names are all of the same format "mmddyy 1st" or "mmddyy 2nd" to distiquish between 1st and 2nd shift of each day. I am very new to VBA programming in Excel and need the basics as well. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine data from several worksheets into single worksheet | Excel Discussion (Misc queries) | |||
Copy Range From Multiple Worksheets to a Single Worksheet | Excel Discussion (Misc queries) | |||
Link multiple worksheets while extracting data | Excel Worksheet Functions | |||
Need to have multiple worksheets use a single worksheet | Excel Worksheet Functions | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions |