from one sheet to another

[oracle_coorgi]

hi
how can i insert OR update rows from one sheet(A) to another sheet(B and C)
case:
1.sheet one A in column B,C,D,E,F,G,H,I WE HAVE TO INSERT AND update to sheetB and sheet C

Thanxs

[davesexcel]

Here's a code that will work to paste the info from one sheet to the other,
from that code you should be able to figure out how to paste the info into the 3rd sheet

Please Login or Register  to view this content.

[oracle_coorgi]

Please Login or Register  to view this content.

[oracle_coorgi]

hi
one more case
1. if the product is B it should update in sheet 2 column H as car
2. if the product is D it should update in sheet 2 column G as auto
respectively