+ Reply to Thread
Results 1 to 3 of 3

Adding sets of data from different work sheets into a third work sheet.

  1. #1
    Registered User
    Join Date
    11-11-2013
    Location
    United Kingdom
    MS-Off Ver
    2013
    Posts
    14

    Adding sets of data from different work sheets into a third work sheet.

    Okay so I I'm looking for an easy way to add one column of data from 1 work sheet with another column of data in a second work sheet to come together in a third work sheet.
    I'm aware of using ='[Filename1.xlsx]Week 1'!$F$4+'[Filename2.xlsx]Week 1'!$F$4 and changing the 4 to 5, than 6. Then once reached the bottom starting again for the next column. ( changing F to H for example ) This is very tedious and hoping someone can shed some light on how I could do this using autofill.
    If anythings unclear just say so and I'll try clear it up more
    thanks, lee

  2. #2
    Registered User
    Join Date
    11-11-2013
    Location
    United Kingdom
    MS-Off Ver
    2013
    Posts
    14

    Re: Adding sets of data from different work sheets into a third work sheet.

    Okay so I removed the $ from ='[Filename1.xlsx]Week 1'!$F$4+'[Filename2.xlsx]Week 1'!$F$4 and auto fill worked. So thread can be closed

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Adding sets of data from different work sheets into a third work sheet.

    Marking this thread solved for you.

    In future, please select Thread Tools from the menu link above and mark the thread as SOLVED. Thanks.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Total work sheets on a final work sheet
    By Treecko in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-26-2013, 11:19 AM
  2. [SOLVED] Pulling for multipul work sheets into one master work sheet
    By boll55 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2013, 04:32 PM
  3. Macro to collate data from different work books and different work sheets
    By bvdileep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2012, 05:34 AM
  4. Extract data into a master work book by accessing various input work sheets/workbooks
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2011, 05:10 PM
  5. Copy rows from work sheets to combine to one work sheet based on cell value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2008, 05:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1