Hi,
I have two spreadsheets in the same workbook. The first is a master sheet that contains most of the data. The second is a smaller sheet. I need to compare the contents of column "A" of the master sheet with column "A" of the smaller sheet. If a match is found I need to copy the cell contents of "B" and "C" of the Master to the smaller in the respective matching rows. I have written some small macros but I do not know where to start.
Thanks
Try:
Please Login or Register to view this content.
Last edited by Solus Rankin; 07-09-2013 at 02:17 PM. Reason: corrected code
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Thank you, XeRo Solus. That works great!
If you are satisfied with the solution I would really appreciate if you marked the thread as [SOLVED] and clicked the * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks