More referencing

S

splat

Hi, similar problem to deadpandad..... WS1 is the master sheet. I
need a formula to find 18 different criteria in WS1colA, if it finds
it, copy only 2 of the columns data (col B and E) to WS2.
If it finds ZA01 in WS1col A, copy to WS2, if it finds ZA02in WS1col
A, copy to WS3 etc.

If I add data to WS1, and the col A has the matching criteria, it will
need to update the corresponding worksheets automatically.
 

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

Similar Threads

Compare two different workbook sheet to show the difference in text 0
need help 1
Linking worksheet and multiple cells 1
formula to add year to date figures 0
excel - outlines 4
Find last cell in a column, Delete its contents and make it active 5
Using cell's contents as an index to a row ...? 3
Using cell's contents as an index to a row ... ? 1

Top