multiple page spreadsheet

Hello everyone.
I am quite new to excel and have the following basic question.
I have a five page spreadsheet. Each page has the same layout - several columns of text, two columns of numbers and a final column of times in minutes and seconds. This final column I sum at the bottom to get a final time. I would like to add a sixth page which contains only the time column of each page as a kind of summary page. What I have done is created each separate page and then just cut and special pasted (Value ONLY) the column that I need to the final page making a five column summary page. The question is I would like to find a way of linking the columns in the summary page to the individual pages so that if I change a value in the first set of pages the final page is updated. This I would then like to make into a template so that each week I can produce a new set of data. I cannot seem to get this to work. Is special paste the way to go. Can I link one column to another, or do I have to individually go to each cell and = the information to it. Can anyone steer me in the right direction.

Thanks. Xler.

Welcome to the board
Copy your original range
got to the summary page Paste special - Choose "Paste Link"

HTH

WOW it works.
Thanks a lot Arthurbr.
All the best.

Xler.

Glad to help

Originally Posted by Xler

WOW it works.
Thanks a lot Arthurbr.
All the best.

Xler.

Hello every one this is Julia Benavidez
I am very pleased to to have you a board in this company for the first time
ever I hope that we can be of help to one another.maybe in the future it will all work for the best for the both of us. and for that I give thanks to God up above cause he is the one we owe it to.after all we are nothing with out him.