Here is the background info: I have 5 sheets in a WB, each containing nearly identical tables. The tables are set up in the classic
manner. The row headers cover 10 columns (StoreName, StoreNum, Add1,StoreMgr, etc.,etc.). The same store may be listed multiple
times but one of the items would be different (Different StoreMgr usually. Sometimes it is address slightly changed, like Street
instead of St. or something like that). The Column Headers, once you get past the stuff just mentioned, are product numbers (i.e.
M6466 or WA5955-2). Each of the 5 sheets will mostly list the same stores in mostly the same order, but each could be a little
different than the others. For instance, they might each have approximately 1025 rows, but no 2 of them having the same number of
rows. Also, 2 sheets could have the same # of rows, but not all the exact same stores. Each sheet will have all different product
#s. They don't load them all into one sheet because of the stupid 256 column limit. The 1st 1 or 2 characters in the prod #
represent the type of product. M = Mens, WA = Womens Accessories, etc. The data in the table will all be integers less than 100.
There are no blanks in the data but there are lots of zeros.

The Task: I create a sheet for each prod type and then list the stores and prod #s for that prod type, and I must make sure that the
same store has the correct integer value for each prod #, matching the original data from the source sheets.

What I've done: I have (via code) inserted new sheets for each prod type; named each sheet, inserted all of the column headers as
appropriate for each sheet.

The problem: I need to load the stores and the data. I don't need code, I can handle that. I'm interested in the best approach for
matching the data with the right store and prod #, keeping in mind that several of the prod #s on each sheet came from a different
source sheet, so I can't load entire rows or entire columns of data at a time because they wouldn't line up correctly all the way
down or all the way across. I'm thinking of making use of the intersection function within a loop or 2.

Any good ideas?
--
RMC,CPA