Hi,
I have several workbooks that I want to extract the value from cell D1 in each worksheet from and place into a master spreadsheet. The end result is shown on the NOTOK control excel file. The rest of the files of NOTOK represent the data worksheets to be extracted from. Thanks in advance to anyone who can help.
Last edited by kchm_2000; 10-22-2011 at 02:50 AM.
Try this:
Please Login or Register to view this content.
Last edited by JBeaucaire; 10-20-2011 at 12:23 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi,
somehow this code is buggy
Please Login or Register to view this content.
The rest of the code works fine, but i would like to ask how would you adjust the formula such that it avoids running through hidden sheets?
Like so:
Please Login or Register to view this content.
thanks for all your help so far you are really great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks