Autofill macro formulas

=?Utf-8?B?TGVvbmE=?=

Guest

Posts: n/a

6th Jul 2007

I'm trying to macro one spread to another. My dilemma is that the source
document is made up on multiple worksheets. My other spread needs to
reference consecutive worksheets on the source from consecutive rows. Ex:
row B1 = worksheet tab 1 cell C5; row B2 = worksheet tab 2, cell C5. I can't
seem to figure out how to autofill and change the worksheet source reference.
Any ideas?

« 'COUNTIF' and 'AND" | Help avoiding a circular reference »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autofill Formulas	Mike Archer	Microsoft Excel Programming	1	16th Mar 2010 08:52 PM
Autofill column values in formulas	NOV Michael S	Microsoft Excel Misc	4	9th Oct 2009 05:50 PM
AutoFill w/formulas	=?Utf-8?B?SmFtZXNFbHRpbmc=?=	Microsoft Excel Worksheet Functions	1	2nd Sep 2005 05:38 PM
Autofill the formulas and supress the messages	Robert Hargreaves	Microsoft Excel Programming	1	1st Jun 2005 12:12 AM
Autofill formulas b/t various worksheets	lbenson	Microsoft Excel Worksheet Functions	1	17th Sep 2003 11:23 AM