Trouble linking data from summary sheet to other workbook HELP

**Arnie1967** · 09-24-2013, 01:38 PM

Hi ,I have a simple workbook containing what I think is a summary sheet and three other year sheets
This was created by a colleague but I am struggling to edit it.
The summary sheet is mileage destinations column A being the destination and column B being the destinations mileage so for example. London and 80 miles ,Birmingham 60 miles.
The year sheet contains a cell for every days mileage so I could input the name of the destination into the cell and it would represent the given mileage from the summary sheet and then totalise the full amount at the end of the week but still only showing the destination in the cell not the mileage only showing the full mileage in the totals column.
Now for the problem.
First two years worked fine , but when I created a third yearly worksheet ( copied and pasted and just changed the dates) it threw up errors. Also I added new destinations and mileage to the summary sheet but on inputting them to the new worksheet it gave me no mileage and no totals .
Can anyone tell me how to edit the summary sheet and even what it could be using to link the data?
I'm stuck as I don't know the method used for 1st linking the destination to the mileage and 2nd linking the summary sheet to the other worksheets

All help would be greatly appreciated
Thanks
Arnie

**6StringJazzer** · 09-24-2013, 05:20 PM

Welcome to the Forum!

It sounds like this will be fairly simple to solve but it's not possible to guess at how the file was built and what the data looks like. Can you attach the file?

To post a file:

Underneath and to the right of the text box where you type your reply click the Go Advanced button.
In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
In the pop-up, click Add then Select to select a file from your local drive
Upload it
Click Done to attach it.

It will be displayed underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.