gonetopilbara
New Member
- Joined
- Aug 24, 2011
- Messages
- 1
Hi,
I simply wish to copy text from cells in one sheet to another sheet on the same workbook in Excel 2007
Please see the attached image of 2 worksheets. The Original where i enter the data is called Daily and the sheet where I want the exact same data to transfer to automatically is name Summary.
The formula I have used in cells A2 through to A4 on the summary sheet is {=(Daily!A3:A8)}
This copies A3 to A5 from the daily sheet to the summary sheet perfectly
The reason I used the above formula was to ensure that if any rows were added on the daily sheet the formula would expand to include new rows such as A9, A10, etc.
The problem I have as you will see in the attached image is that when I added a new row on the daily sheet between A4 and A5 the summary still only displays the first 3 rows in the formula (A3 to A5)
How can I ensure that no matter how many extra rows I add the summary sheet displays them all (A3 to A10 for example) and not just A3 to A5 from the daily sheet like it is now doing?
Hopefully the image attached will explain the issue I am having?
I simply wish to copy text from cells in one sheet to another sheet on the same workbook in Excel 2007
Please see the attached image of 2 worksheets. The Original where i enter the data is called Daily and the sheet where I want the exact same data to transfer to automatically is name Summary.
The formula I have used in cells A2 through to A4 on the summary sheet is {=(Daily!A3:A8)}
This copies A3 to A5 from the daily sheet to the summary sheet perfectly
The reason I used the above formula was to ensure that if any rows were added on the daily sheet the formula would expand to include new rows such as A9, A10, etc.
The problem I have as you will see in the attached image is that when I added a new row on the daily sheet between A4 and A5 the summary still only displays the first 3 rows in the formula (A3 to A5)
How can I ensure that no matter how many extra rows I add the summary sheet displays them all (A3 to A10 for example) and not just A3 to A5 from the daily sheet like it is now doing?
Hopefully the image attached will explain the issue I am having?