+ Reply to Thread
Results 1 to 1 of 1

extracting data from multiple worksheets into a "master"

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    Mercer Island
    MS-Off Ver
    2007
    Posts
    1

    extracting data from multiple worksheets into a "master"

    Hello - I'm working on a project where I send out many spreadsheets to various "markets" around our company, they fill out 2 date fields and they send it back. I then will need consolidate that data and enter those values into a master spreadsheet. Currently that involves manually entering this information which is tedious and often full of errors and omissions - requiring sending out a revised version - then rechecking the "new" version to see if all the data therein is sound. It's a hamster wheel. Is there a way to automate this whole process? Here's a snippet of my various worksheets and the master worksheet. THe master is the 1st tab and the rest are smaple of what may be sent to the markets. I need to extract stuff that is entered in columns S and T onto the Master. The master is then turned into a CSV file and uploaded into some database somewhere. Before you suggest that the end user enter data directly into the DB, I've been donw that road; the executives think that this is too cumbersome and want to handle this process using excel. Ugh. I'm not very well versed in coding or anything and would need a simple but do-able solution as quickly as possible. Thank you!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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