Update sheets from Master

J

JR

Hello,
Again, thanks so much for all the help on this newsgroup, much appreciated.

I have a workbook with a master sheet and several other sheets. I would to
see if there is a macro that will scan the master and update all the other
sheets if they have the corresponding part number. I am using column "A2"
starting the part numbers. Some sheets have the same part numbers listed, so
macro needs to update all sheets even if dupicate part numbers,

Thanks JR
 
N

Niek Otten

You should not need to run a macro to update cells which correspond to a
part number.
All "not-master" sheets should retrieve their information from the master
sheet, using VLOOKUP(), MATCH() or INDEX() functions.
Any change in the master sheet should automatically propagate to all
dependent sheets.
If that is not the case, tell us something more about the structure of your
workbook
 
J

JR

Hello,
Thank you for the response, but I am very new to this. How do you start one
of the functions you listed?

Thanks JR
 

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