Macro to copy record into another sheet

[pdalal]

I have a sheet called SKU Master.

I want that whenever I enter a new record into the SKU master sheet depending on if I choose the factory as NC it should copy that record over into the NC sheet.
I want that whenever I enter a new record into the SKU master sheet depending on if I choose the factory as SC or SCO it should copy that record over into the SC sheet.
Also I want it to verify that the information in SKU master if it is different for other existing record it should update on the appropriate sheet.

So for e.g SKU 345678 length in ft (column G) is 6 if I update that to 9 it should get updated in SC sheet as 9. I want this Data check to happen for all fields in the header.
Ideally I would like to have a Command Button(shaded light blue) called "Update" in Cell A1 and when I click the button I would like the above updates to happen.

Essentially I want to update the data only in one place and then have the other two sheets feed the data from here so that I don't have to enter it again.

Any help is appreciated .
Thanks!

[djdjdj]

Hi,

Try this:

[pdalal]

This works great !! Thank you!
I do have a question though how can I see the code in the sheet?

[djdjdj]

If you hit Alt+F11 it takes you to the VBA viewer

[pdalal]

I just noticed one thing and maybe its a quick change SC and SCO are supposed to be in same sheet.Not separate sheets .

[pdalal]

Do you think you can make that change ? SC and SCO go into the same sheet.

[djdjdj]

Hi,

Sure, that won't be a problem. I'll get back to you tomorrow when I'm at the office if someone else hasn't answered you by then.

[djdjdj]

Hi,

Here's an update

[pdalal]

Thank you!!