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:

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
7,149
Office Version
2019
Platform
Windows
Why don't you just over-write the existing TL sheet with new data?
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
7,149
Office Version
2019
Platform
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.
 

Forum statistics

Threads
1,081,832
Messages
5,361,586
Members
400,639
Latest member
fleyd

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top