PDA

View Full Version : VBA - Search Loop Help



Heffer Wolfe
11-20-2014, 05:50 PM
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