Combining Excel files

[Cory Sullivan]

I have all my timesheets in separate files and I would like to extract values from each file to use in analyzing my time spent on projects and time spend doing administrative tasks, etc.

Can someone give me some tips on how to get started (e.g.. how to extract valves from one file to another)

Thanks
Cory

 

[Dave Peterson]

It depends on a lot of stuff. But if your values are always in a nice spot, you
can use a formula (called a link) to retrieve the value.

Open the source workbook and the destination workbook. Go to the cell in the
destination workbook/worksheet and type = (just an equal sign).

Now point at the sending cell in the other workbook. Then hit enter. Excel
will build a formula that tells it where to pick up that value.

If you close the source workbook, look at the formula--it includes the drive and
path to that workbook.

You might be able to do this with all your workbooks.

======
Or maybe it's just a matter of copy from the original and pasting to the
destination.

 

[Cory Sullivan]

Thanks... I believe thats what I am looking for.

It depends on a lot of stuff. But if your values are always in a nice spot, you
can use a formula (called a link) to retrieve the value.

Open the source workbook and the destination workbook. Go to the cell in the
destination workbook/worksheet and type = (just an equal sign).

Now point at the sending cell in the other workbook. Then hit enter. Excel
will build a formula that tells it where to pick up that value.

If you close the source workbook, look at the formula--it includes the drive and
path to that workbook.

You might be able to do this with all your workbooks.

======
Or maybe it's just a matter of copy from the original and pasting to the
destination.