I WANT TO BE ABLE TO FIND THE NAME OF SHEETS IN A SPREADSHEET

M

Mr. Job Coster

Hello, I do a lot of data entry in excel and I have a problem. I need to be
able to click on the find icon and be able to type in the name of one of the
sheets that i created in a spreadsheet and have all of those documents
containing that certain sheet automatically populate. This would make my job
a lot easier and I would be more efficient in what I do. If anyone knows of a
way that I can do this please let me know. Like for instance... in my
database i have hundreds of spreadsheet documents that have several sheets in
each one. In the past three months i have went into random documents and
added another sheet for more information to go into that document and i am
constantly needing to review those documents to make changes but like i said
there are probably over a thousand of them. I just want to extract the ones
that I have added this sheet to keep them up to date. Thank you.
 
B

BrianB

Ithink that you may have the wrong setup overall.
Far better to have all data in a single table and use Excel etc. to d
the hard work of analysing/filtering etc. You just need to add fres
data to the bottom
 
Top