Results 1 to 5 of 5

'Consolidate' data from multiple worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2005
    Posts
    2

    'Consolidate' data from multiple worksheets

    I've got 8 years of payroll data in one spreadsheet, with 72 worksheets, one for each month, labelled eg, Jan 02. Each worksheet has some totals in the same (relative) cell on each worksheet, ie the worksheets are effectively identical in layout except for the data. Let's say its got a total for Admin Wages and another for Factory Wages.

    I want to collect each months worth of data on one consolidation worksheet. So I want a table that has say 2 columns, one for Admin and one for Factory, and 72 rows representing each month. It's probably a snip but I can't figure out how to do it except by some very tedious cut'n'paste stuff. Thanks!
    Last edited by spliknik; 08-23-2005 at 06:47 AM. Reason: Spelling mistake in title

Thread Information

Users Browsing this Thread

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

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