Can you create a formula to pull from one worksheet to another, both within the same file?
J Jeffrey Jul 1, 2005 #1 Can you create a formula to pull from one worksheet to another, both within the same file?
B Bob Phillips Jul 1, 2005 #2 Yes, a simple example =Sheet2!A1 in other words just preced the cell ref with the sheet name and !. If the sheet has embedded spaces, enclose in single quotes, such as ='This Sheet'!A1
Yes, a simple example =Sheet2!A1 in other words just preced the cell ref with the sheet name and !. If the sheet has embedded spaces, enclose in single quotes, such as ='This Sheet'!A1
C Chip Pearson Jul 1, 2005 #3 Jeffrey, Use a simple formula like the following: ='Sheet2'!A1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Jeffrey, Use a simple formula like the following: ='Sheet2'!A1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
