I have 2 sheets.
Sheet 1 = 'My Data'
Sheet 2 = 'ReplaceIt'
Column named 'TOPIC2' is common in both sheets.
I want to look at Sheet 2 , Topic 2 , comeback to Sheet 1 , find the corresponding data from Sheet 2 in Sheet 1 and paste Topic 5 data from Sheet 2 into Sheet 1. Refer attached excel please.
If someone can provide this macro, i will really appreciate it.
Last edited by enggrahul78; 08-04-2019 at 04:02 PM.
How about
Please Login or Register to view this content.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I will take care of this in the future. However for now, solution provided by Fluff13 worked fine for me. Thanks a lot Fluff13 and sorry for the inconvenience FDibbins...Originally Posted by FDibbins
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Hi Fluff13,How aboutPlease Login or Register to view this content.
I am running into an issue. If I run this macro multiple times, it clears the previous values. I modified the code, but not working. My idea was that do not replace the cell if there is some value already populated. But the code giving debug error.......
Please Login or Register to view this content.
Last edited by enggrahul78; 08-04-2019 at 04:03 PM.
I cannot offer any further help, until you have complied with the moderation request in post#3
Also you need to edit post#5 to include code tags around the code.
Hi Fluff13,
I had tried changing the title of the post and also tried changing Post 5 as per your suggestion. Are you OK with it ? If I missed something or done something wrong , please let me know and I will try again............ I am relatively new here and also new to VBA....... I am just trying to learn something new !!!
Regards,
Rahul.
Thanks for making the changes.
TryPlease Login or Register to view this content.
Thanks for the title change
Thanks for your suggestions and solution....
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks