Data needed from large workbook

[ryjones]

Good day-

I have a workbook setup as follows:

Sheet 1 has 50,000 records with several columns of data related to a specific column - let's call that "codes".

Sheets 2-31 have duplicate entries of some of the records from Sheet 1.

What I would like to do is add a column in Sheet 1 that would tell me which sheets that exact row appears on.

Is this possible?

Any info would be appreciated.

--Ryan

 

[ranman256]

this is more of a database solution, rather than an Excel one.
but in excel , it sounds like long vb code of searching EVERY cell and logging EVERY instance.

 

[ryjones]

Yeah, a DB would be ideal but I only have the resources to go 'old school'. What would a vb code like this look like? Anything to get me started or anything I can supply to help?