Update sheets from Master

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JR - 16 Dec 2005 17:14 GMT

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

Reply to this Message

Niek Otten - 16 Dec 2005 17:24 GMT

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

Signature

Kind regards,

Niek Otten

> Hello,
> Again, thanks so much for all the help on this newsgroup, much
[quoted text clipped - 7 lines]
>
> Thanks JR

Reply to this Message

JR - 16 Dec 2005 17:28 GMT

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

> You should not need to run a macro to update cells which correspond to a
> part number.
[quoted text clipped - 17 lines]
>>
>> Thanks JR

Reply to this Message