Excel: Relative formula to new sheet?

  • Thread starter Thread starter mmwilcox
  • Start date Start date
M

mmwilcox

Is there any way to copy a formula from one sheet to another and hav
the sheet names in the formula copy as relative not absolute addresses


For instance, say worksheet B cell B2 has the following formula: B!A1
A!A2. If I copy and paste it to worksheet C!C2, it will paste as B!A
+ A!A2 whereas I would like it to paste as C!A1 + B!A2.

Lotus 1-2-3 did this automatically unless the Sheet reference was mad
absolute. Is there any way to do this in Excel?

Thanks! This one has been a thorn in my side for years.

Matt Wilco
 
Unfortunately, Excel does not support relative sheet referencing.
 
You must log in or register to reply here.

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

Code to copy the last row formulas and paste it in the bottom row 3
Delete rows takes forever 4
CONCATENATE code 2
Run two macros for two different sheets 11
Progressive number in different sheets 7
Array VLOOKUP lookup_Value does not increment 3
Paste formula in numerous worksheets 1
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2

Back
Top