How to search data from multiple sheets - if find the data - copy the next column.

tt36181,

Welcome to the Excel Forum.

Are you using a PC or a MAC?


To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

tt36181,

I have a list of SN in a sheet. Would like to search these SN on a books with multiple sheets. If find the data, then copy the next column into SN sheet.

I assumed by your above instructions that all the worksheets were in one workbook.


In the Quick Reply box, just put the word BUMP. Then, click on the Post Quick Reply button, and someone else will assist you.