LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combine data from several worksheets into single worksheet Rya05 Excel Discussion (Misc queries) 2 September 6th 08 10:36 PM
Copy Range From Multiple Worksheets to a Single Worksheet Dauntless1 Excel Discussion (Misc queries) 5 August 17th 07 01:59 AM
Link multiple worksheets while extracting data aj9000 Excel Worksheet Functions 0 September 28th 06 11:55 PM
Need to have multiple worksheets use a single worksheet storm5527 Excel Worksheet Functions 1 April 22nd 05 11:25 AM
Extracting data from multiple worksheets into a list mnirula Excel Worksheet Functions 16 February 25th 05 08:52 PM


All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"