Refer to Sheets in formula VBA
I have a workbook which contains 400 sheets. The sheets are updated every day. On the first sheet there is a "Main" sheet were i'm trying to build a matrix which counts certain things from every sheet. In the martix I want to make a formula which refers to a the corresponding sheet. I have a list of words (the names of the sheets) on the "Main" sheet were I can reference it to. I got it to work with the INDIRECT function, but is was very very slow. Does anyone have a good idea how to make is faster, perhaps without INDIRECT?
Or can this be done in VBA?
Thanks in advance!
PS: I have attached a small printscreen of my problem.
Re: Refer to Sheets in formula VBA
Duplicate thread: http://www.excelforum.com/excel-form...-inderect.html
Please don't post duplicate threads, albeit with different titles. Most people will look at all the sub-forums.
And please don't post pictures ... they're useless.
Trevor Shuttleworth - Excel Aid
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By gerarddevries in forum Excel Formulas & Functions
Last Post: 08-04-2015, 05:41 AM
By mario274 in forum Excel Programming / VBA / Macros
Last Post: 12-03-2012, 12:03 PM
By ZMBER in forum Excel General
Last Post: 05-17-2011, 02:31 PM
By DPGDPG in forum Excel General
Last Post: 11-23-2009, 04:31 AM
By Will C. in forum Excel General
Last Post: 06-02-2006, 03:54 PM
By fern in forum Excel Programming / VBA / Macros
Last Post: 04-03-2005, 01:42 AM
By in forum Excel General
Last Post: 01-06-2005, 01:06 PM
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1