copy text from cells on one sheet to cells on another sheet

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?

http://imageshack.us/photo/my-images/594/samplespreadsheet.jpg/
samplespreadsheet.jpg
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,224,586
Messages
6,179,719
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top