replacing just the sheet names within formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a multisheet workbook. I need to regularly replace the sheet name
with the formulas. I need to replace December04 with Jan05 etc. Formula -
cell references will change in each cell. Lookup and MTD_Actuals are named
ranges on another sheet w/i book.
=SUMIF('File Name.xls'!Lookup,December04!$A7&$D$5&D$6,'File
Name.xls'!MTD_Actuals)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Vlookup and return sheet name also 2
Using wild card characters in Find & Replace 6
Use a cell's value to set the source file name in link 2
Dynamic sheet reference in Name formula 1
How to get range names to Apply across multiple tabs 1
Update cell value based on name and specific date 1
Indexing Sheets in Referenced Workbook within formula 1

Back
Top