jwpioneers
IS-IT--Management
I am looking for some help on how to execute the following process in Excel. We receive in a spreadsheet periodically with maybe 50 worksheets in a workbook. Each individual worksheet, is format with labels that data has to be entered in. The cell ranges are always the same. What I am attempting to do is find out the most feasible way to extract the values from those pre-defined cell ranges, and put them row by row in one worksheet( Each row would represent the data for a given location) that I can then send to our Oracle DBA. The way it is being done now is very tedious, and somewhat redundant. I am trying to find a way to execute this action. Any help is much appreciated.
