Update sheets from Master

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

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

--
Kind regards,

Niek Otten

"JR" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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


"Niek Otten" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> --
> Kind regards,
>
> Niek Otten
>
> "JR" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>