We have Three excel files. 1. Master 2. MRP & other update 3.Sent
A sample file attached with this post.
We frequently note the price and size in "MRP & other update"
In both file "Code" no is common
Point1
how can we do that by vba, I mean when we note any mrp or any thing then entire row copy and paste in Master File where the code is same
Point2
and after copy all the row from from "MRP & other update" to "Master File".
In "Sent" file we want copy entire and all the row from "Master" file where we have changed the mrp or anything
We have added new mrp in "MRP & other update", and want to update it as above we have said.
We frequently note the price and size in "MRP & other update"
In both file "Code" no is common
is common to what? i don not see a price in MRP
Point1
how can we do that by vba, I mean when we note any mrp or any thing then entire row copy and paste in Master File where the code is same
does this mean to overwrite any existing information for that code?
Point2
and after copy all the row from from "MRP & other update" to "Master File".
In "Sent" file we want copy entire and all the row from "Master" file where we have changed the mrp or anything
We have added new mrp in "MRP & other update", and want to update it as above we have said.
i am not sure i understand this requirements at all
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
to clarify
so in the sample files you want the 2 rows to overwrite the the lines in master with the matching codes?
and the lines to be added to the sent workbook? or in this case as they are already there nothing to be added? or as the details have been changed, overwrite or add?
this is all pretty easy to do, if i can figure out the desired result
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete