PC Review


Reply
Thread Tools Rate Thread

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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:12 AM.