I have a workbook that I have sheet1 and sheet2 and sheet3. I am trying to figure out a macro that will search Sheet1 Column A and Sheet2 Column B for matching numbers. If there is a match I would like it to post the contents of these and Sheet1 Column B into Sheet3. I have searched and searched trying to figure out how to do this and have not had any luck. Could somebody help me get started in the right direction. Thanks in advance.
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.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks for the reply I really appreciate your help.
If I need to change something or do anything different let me know I am flexible with the layout as the important thing is the information needed. Thanks again
Perhab untest
Please Login or Register to view this content.
"ThankyouFor Attention * And Your Help!!"
See what this does in terms of execution speed.
Please Login or Register to view this content.
Last edited by bakerman2; 12-08-2018 at 05:36 AM.
Thank you so much. I will try Monday when I get back in the office and see what it does for me. I really appreciate it.
This works perfectly. Thank you so much for all the help.
Glad to help and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks