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

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 wrote:
>
> 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
(E-Mail Removed)

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

"Dave Peterson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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 wrote:
>
> 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
(E-Mail Removed)