search and paste information - multiple pages

J

JO

I need a formula that searches multiple pages within a 2003 Excel workbook,
to pull that cell information and the cells related to it.
Example
Employee ID is S11700, I need to search the workbook for this ID, date and
$ amount. It is possible that this info is located in the workbook several
times. I would need to be able to change the ID # to search for other
employees throughout this workbook. Many thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top