Nov 06 2019 03:19 PM
Hi,
I have a large data set so in order to keep it simple i have seperated some parts of the spreadsheet. I have one spreadsheet which will contain a large number of tabs for each individual product. For example the 3 stocks from Asset cards, into "historical prices" tab, highlighted yellow.
I wish to be able to import the relevant data from the tabs to another spreadsheet, can someone please assist.
As example I have the stocks information in "Asset Cards" spreadsheet. I wish to have this "close" price data linked to the a summary tab in spreadsheet "Scenario Analysis".
Can someone please assist.