Aug 02 2019 05:47 AM
Aug 02 2019 07:08 AM - edited Aug 02 2019 07:12 AM
Hello @MelissaRatcliffe275,
One way to solve this problem is to create a blank worksheet and in cell A1 reference to cell A1 in your original worksheet (i.e. =Sheet1!A1). Then simply copy down this formula to the necessary amount of cells.
Hope this helps!
PReagan
Aug 02 2019 11:34 AM
When structuring your data in Excel it is a good practice to store your data in a table using the Excel Table feature in Excel as demonstrated in the illustration below. Give your table a meaningful name.
Then you can easily reference your table in other sheets by its name. With the latest version of Office 365 you can leverage the power of the new engine and make efficient use of dynamic array function as I demonstrate.
Tell us what are you trying to achieve with the second table and we maybe help you better.
Let us know if that was helpful