'Maintain cell reference when substituting new sheet

I am performing a portfolio calculation based upon a daily spreadsheet which contains values in the same cell locations.

I would like to be able to substitute daily a new sheet via the copy function, yet maintain the cell reference.

EG, I have a 'control' sheet which references cells D4, E4 and F4 in sheet B. Every day a new Sheet B is published with the relevant values in the same cells. Is there a way I can maintain the references in the Control sheet when inserting this new sheet daily?

excelreferencespreadsheet


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Reading Excel file with Selenium WebDriver C# and web form with values

How to update an existing row or table of an existing xlsx file using pyexcel for python

Equivalent C# Function For Excels Norm.S.Inv Function

I keep assigning a value to my variable but it stays empty

Excel RTD (Real Time Data) client other than Excel?

Create table from data on a worksheet with specific name and add column

Is it possible to use 'Microsoft.ACE.OLEDB.12.0' provider without installation?

Using VBA to query a SQL Server table in Excel

How to stop scroll bar auto jump in vba

If IsEmpty then go to column A but in same row and extract that data

How can I use a for each loop on an array?

VBA - worksheet object is hidden

Outlook 2010 GAL with Excel VBA

how to read a value from Column Name in Excel in Java

Replace cell value with image