Hi,
We have two excel files,
1. Cata
2. Update from Here
We want to copy the following headings values in "Cata" from "Update from here" when we update new data in "Update from here"
New Price Page No. length Width Height Weight
In "Cata" heading "New Price" will be "Book Price"
in both files we have one thing is common - Book Code
in "Cata" we have two sheets and we need to check book code in both sheets
Help pls
Are you saying that each time you make a change in "Update from Here", you want to update the data in both sheets in "Cata" based on the "Book Code"?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
yes Mumps1
Make sure that both workbooks are open. Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for Sheet1 in the "Update from Here" workbook and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a change in any of the cells in D:I and press the RETURN key or the TAB key.
Please Login or Register to view this content.
Thanks Mumps1,
we will check and update you
thanks Mumps1
its working in my case.
You are very welcome.
Please confirm may i need to create new post or add with this post
and that is, can we make summary of changes mail as attachment only rows that have changed,
we are attaching the sheet, in this sheet we have copy only one Row in which book code is 350, because we have changed the price and other things in book code
now we want to mail this sheet, email list in the sheet "Update from Here" or we can create a new sheet if you advices
help pls
Since that is an entirely different request, you should start a new thread.
thanks Mumps1
we will create new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks