If cell X's content in Sheet A equals to cell Y's content in Sheet B, Then copy some data.

Hi

The way I read this, VLOOKUP should be a viable option.

rylo

It's like look up the description of this data from the database. Sheet A is random few data, and Sheet B is the database which contains all the info.

so have you tried the VLOOKUP function? If so, does it work? If not, then can you attach an example file for review.

rylo

Let me try it. Thanks a lot!

@ sunheroj

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

Thanks! Cutter, I will do that! I just figured out the problem by myself.
BTW, I have a link where have a free online book about Macros:

http://www.doc88.com/p-20924486358.html

But I'm not sure if it is good or not.

And I have one more problem which is.... Is there a way we can copy whole content of Sheet A in an already opened .csv (which contains sheetA) to an empty Sheet B in another already opened .csv (which contains sheetB) by macro?

Thanks a lot!

@ sunheroj

It sounds like the issue you started this thread for has been solved. You should show what the final solution is so that others coming across this thread can benefit from it. After that, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

As for your new question please start a new thread. Thanks

Sorry for the late reply. These are my correct macro. I forgot "s" after cell that made the error.

Please Login or Register  to view this content.