MACRO to search file for weekly reporting

Hi all,

I would really appreciate some help with developing, what I believe should be, a relatively simple solution:

Currently, I'm exporting data from my company dashboard for around 50 projects. The data for each project is populated in individual sheets. What I would like to do is have a macro that searches through the first sheet, records the value of X at Y, and then moves onto the second sheet, records the value of X at Y, and so on.

I am definitely not a programmer, but I do recognize the power of programming. Thus, I am an enthusiastic novice eager to learn - any tips greatly appreciated. I have a Macro that populates a list of worksheet names:

Please Login or Register  to view this content.

I was then going to VLOOKUP whatever values I needed, from the relevant sheet. However, I don't want to type the sheet name in 50 times! I want some autonomy.

Thanks in advance for the tips.

can you upload sample file with 2 to 3 sheets in it..

Cheers!!

you can use this thread 2 get what you want:

http://www.excelforum.com/excel-prog...ther-file.html

you can use this thread 2 get what you want:

http://www.excelforum.com/excel-prog...ther-file.html

Try this..

Cheers!!