How do I merge the data from multiple worksheets into a single worksheet?
Posted on 2011-10-27
I have a spreadsheet which contains multiple worksheets, 2 of which contain data of an identical structure. Each of the 2 worksheets contain ZIP CODE, STATE, CITY, and a series of 3 business related indicators (FLAG A, B, and C).
Worksheet A contains static data for the approximate 40,000 zip codes that are outside of our business zone.
Worksheet B contains the same data for the approximate 4,000 zip codes that are within our business zone. The cells for this sheet are dynamically linked to a separate spreadsheet which serves as a sort of central data repository.
I can't store all 44,000 rows in the data repository, as the update of a 1/4 million cells causes the update to fail via resources.
I need to sort and merge the data from worksheets A and B into worksheet C, so that I have a single data source for performing array functions (specifically a VLookup) from a census table, which can contain ZIPs from either of the 2 worksheets.