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!
Bookmarks