I’m new to VB
I have multiple sheets (sheet 1 = Data entry, Sheet 2 = MasterData)
When the user enter data in data entry sheet
If the same data find in MasterData sheet then update.
Master data is arranged in tabular format where as the data entry sheet are in form format.
Required vba code to do this task – while clicking a button
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Uploaded the file
Check it out,
You will have to adjust the code if your actual fields are different from the sample you provided.
Please Login or Register to view this content.
See attached with the code in place.
Thanks indeed - it works fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks