Hello,
I am trying to search a specified text in each cells and paste it to my new Excel file.
Please take a look at the zip file. help.xlsx is my raw database and Result tab is what I want to get at the end in Copy Sheets to Result Sheet Master (3).
So far I can make the user select the file wherever it is, take the specified columns that I highlighted in help.xlsx. However, I couldn`t enter search macro code to paste specified values case by case in my template.
Is there any way to do that? I would be really glad if someone help me.
Many thanks in advance,
Heffer
Reply With Quote