Excel recognize new TABS as data and input data into the formula.

scjc28

New Member
Joined
May 15, 2010
Messages
3
Greetings, Im doing a project on bond credit rating. Im given a set of industry and my lecturer wants the credit rating of each industry. As a result i would need a workbook that is adaptable to different industry. Thus i could not hotwired most of my spread sheets.

Problems.

Example, Total assets = total liabilities + owner's equity. (TA=TL+OE)

1.TA is in one spreadsheet tab, TL in another one and OE is in another one . And the formula {TA = TL + OE} is in another one,but all are compiled in one EXCEL workbook. Excel recognise all the cells that i hotwired onto the formula.

2.Since I would need to input a new data, I would delete the old TL. And Input a new spreadsheet with the same tab name called TL. So I want excel to recognise that new TAB sheet "tab name: TL" as the new TL to input into the formula {TA = TL + OE}

When i use a different TL spreadsheet and put it in the workbook, with the same TAB name. Excel would not recognize that new TL spreadsheet input.

How do I make Excel recognize the new TL input as TL ,and still work with the TA=TL+OE formula?

1.Is there a formula, or i would need to nest several formulas?
2.Is there a macro to program excel? If theres one could sombody please post it up and explain how it works.

Im using Excel 2007, and all spreadsheets does not have a macros on them.The spreadsheet design for every spreadsheet would be the same,meaning, all column and rows are parallel to each other.

Thank you
 
Last edited:

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,558
Office Version
  1. 365
Platform
  1. Windows
Why don't you just over-write the existing TL sheet with new data?
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,558
Office Version
  1. 365
Platform
  1. Windows
Instead of deleting your TL sheet then creating a new sheet with the same name, just change the data in the current TL sheet, that way formulae in other sheets that reference TL will still be valid.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,661
Messages
5,573,475
Members
412,532
Latest member
crazzyapple
Top