extand VBA code advice needed

[raffi123]

hello everyone! first i would like to thank for the ppl who's handing out their opinions and suggestions

an expert provided me with this formula, which is listed under

Please Login or Register  to view this content.

notice the last portion of the code the column B which is included in, receiving, Stock out, Sold Stock, is merged, in other words whatever i type in column B in any one of the sheets, it will automatically be copied to the other remaining 2 sheets.

well i want the very same exact process to take place but with column C


to clarify even more, i may be looking for a formula which may resemble or look similar to this code.

Please Login or Register  to view this content.

but column C in place of B, note i do want column B to remain as it is and be operative while column C excutes the same process of column B

[mrjinx007]

Can you post a sample. That will usually get the help you want.

[raffi123]

the answer i was looking for was provided to me but thank you for ur concern

btw here's the answer just in case

Please Login or Register  to view this content.

it can be edited easily by simply adding columns and adding them as much sheets as u wants by adding sheets