I have “MASTER” datasheet with Item_Code , Description and Unit. When I type Item_Code in “EST” sheet, the corresponding Description and Unit against the code in “MASTER” should appear in EST sheet. The formatting as in MASTER sheet should be preserved in EST sheet also. I used the code but to no avail. Kindly guide
Please Login or Register to view this content.
Copy and paste this macro into the worksheet code module. Do the following: right click the ESP tab name and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter an Item Code in column C and press the RETURN key.
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks