Show cells on other sheet

Hi everyone,

I have built an excel so that one sheet records data (input) and another sheet show the results.

Sheet1: show range 'Sheet2'!A2:D21
Sheet2: Every day, new data is recorded in a new columnD (the new columnD is created by right-clicking on columnD and then InsertColumn. This way yesterday's ColumnD becomes today's ColumnE)

The problem is:
After I add the new daily data, Sheet1 will show me 'Sheet2'!A2:C21+'Sheet2'!E2:E21. Is there a way to show range 'Sheet2'!A2:D21 without being affected by adding a new column?

The other option would be adding the new data on the empty columns to the right, but I still wouldn't know how to make it show the last full column before the empty ones.

Thanks in advance

Try INDIRECT function like this:

Formula:

Please Login or Register  to view this content.

Hi Estevaoba,

Thank you for your suggestion.
This is what I have been looking for. However, if I apply your suggestion (writing =INDIRECT("Sheet2!A2:D21") in formula bar) it will give me a #REF error.
In order to fix it I created Sheet3 and wrote in cell A1 "='Sheet2'!A2:D21".
Then, going back to sheet1 I wrote =INDIRECT('Sheet3!'A1), which in turn showed me 'Sheet2'!A2:D21