CREATING A FORMULA

[Guest]

I'm hoping I can find someone who can help me create a formula to use in a
spreadsheet.

Let me explain what I am trying to do. I have two workbooks that I intend to
link so the end result in one workbook will appear in columns in the linked
workbook giving me a year end total for our budget.

Currently the workbook I am using is setup like a check register where we
keep track of invoices (Debits and Credits) the results are displayed in
column "H" H5 thru H88.

I need a formula to display the results from column "H" into the linked
spreadsheet so the sum can be deducted or added to the beginning balance so
at the end of the Fiscal Year we will know how much (if any) monies we have
left in our budget.

I hope this makes sense to someone and you can help me figure this out. If
necessary I can email a blank copy of the spreadsheets to indicate what I am
trying to accomplish. Or I can explain it in more detail if necessary.

Any help or advice at all would be greatly appreciated. Thanks.

 

[Pete_UK]

The easiest way to set this up is to have both workbooks open at the
same time - use Window | Arrange | Horizontal, if necessary, to see
both windows. Then in the appropriate cell of the sheet you want to
link to your main workbook, begin typing a formula with =, then click
on the window of the main workbook, select the appropriate sheet,
click on cell H5, then press <Enter>. You should see a formula like
this in your subsidiary workbook:

=[filename.xls]Sheet1!H5

You can then copy this down the column in the subsidiary sheet until
you have accounted for the range H5:H88. If you close the main
workbook you will see the formula will have expanded to include the
full path in front of the filename. Don't forget to save the
subsidiary file. When you subsequently open the file, you will be
asked if you want to update links.

Hope this helps.

Pete

 

[Guest]

Pete,

I hope you do not mind me bothering you. I just wanted to thank you for your
help with my spreadsheet. I am wondering if I can email you a copy of both
spread sheets and have you look at what I want to do so I will have a better
understanding of what can be done.

If its to much trouble, I understand and I do appreciate your help thus far.

The easiest way to set this up is to have both workbooks open at the
same time - use Window | Arrange | Horizontal, if necessary, to see
both windows. Then in the appropriate cell of the sheet you want to
link to your main workbook, begin typing a formula with =, then click
on the window of the main workbook, select the appropriate sheet,
click on cell H5, then press <Enter>. You should see a formula like
this in your subsidiary workbook:

=[filename.xls]Sheet1!H5

You can then copy this down the column in the subsidiary sheet until
you have accounted for the range H5:H88. If you close the main
workbook you will see the formula will have expanded to include the
full path in front of the filename. Don't forget to save the
subsidiary file. When you subsequently open the file, you will be
asked if you want to update links.

Hope this helps.

Pete

I'm hoping I can find someone who can help me create a formula to use in a
spreadsheet.

Let me explain what I am trying to do. I have two workbooks that I intend to
link so the end result in one workbook will appear in columns in the linked
workbook giving me a year end total for our budget.

Currently the workbook I am using is setup like a check register where we
keep track of invoices (Debits and Credits) the results are displayed in
column "H" H5 thru H88.

I need a formula to display the results from column "H" into the linked
spreadsheet so the sum can be deducted or added to the beginning balance so
at the end of the Fiscal Year we will know how much (if any) monies we have
left in our budget.

I hope this makes sense to someone and you can help me figure this out. If
necessary I can email a blank copy of the spreadsheets to indicate what I am
trying to accomplish. Or I can explain it in more detail if necessary.

Any help or advice at all would be greatly appreciated. Thanks.

 

[Pete_UK]

I would prefer you to try to describe things within the newsgroups -
that way there are hundreds of regular contributors who can help you
if I can't.

Did you try what I suggested, and if so what was the result?

One problem in setting links up between files on my PC is I would have
to do so with exactly the same paths and filenames that you use, or
create some temp folder that we can both set up directly within C:
(but you might be on a network), and then you would need instructions
on how to move the files to their permanent locations and still
maintain the links.

I'm still willing to help, but let's do so through this forum.

Pete

Pete,

I hope you do not mind me bothering you. I just wanted to thank you for your
help with my spreadsheet. I am wondering if I can email you a copy of both
spread sheets and have you look at what I want to do so I will have a better
understanding of what can be done.

If its to much trouble, I understand and I do appreciate your help thus far.

The easiest way to set this up is to have both workbooks open at the
same time - use Window | Arrange | Horizontal, if necessary, to see
both windows. Then in the appropriate cell of the sheet you want to
link to your main workbook, begin typing a formula with =, then click
on the window of the main workbook, select the appropriate sheet,
click on cell H5, then press <Enter>. You should see a formula like
this in your subsidiary workbook:

=[filename.xls]Sheet1!H5

You can then copy this down the column in the subsidiary sheet until
you have accounted for the range H5:H88. If you close the main
workbook you will see the formula will have expanded to include the
full path in front of the filename. Don't forget to save the
subsidiary file. When you subsequently open the file, you will be
asked if you want to update links.

Hope this helps.

- Show quoted text -

 

[Guest]

Understood, thanks for the assist. I will be getting back to you shortly with
this.

Stan

I would prefer you to try to describe things within the newsgroups -
that way there are hundreds of regular contributors who can help you
if I can't.

Did you try what I suggested, and if so what was the result?

One problem in setting links up between files on my PC is I would have
to do so with exactly the same paths and filenames that you use, or
create some temp folder that we can both set up directly within C:
(but you might be on a network), and then you would need instructions
on how to move the files to their permanent locations and still
maintain the links.

I'm still willing to help, but let's do so through this forum.

Pete

Pete,

I hope you do not mind me bothering you. I just wanted to thank you for your
help with my spreadsheet. I am wondering if I can email you a copy of both
spread sheets and have you look at what I want to do so I will have a better
understanding of what can be done.

If its to much trouble, I understand and I do appreciate your help thus far.

The easiest way to set this up is to have both workbooks open at the
same time - use Window | Arrange | Horizontal, if necessary, to see
both windows. Then in the appropriate cell of the sheet you want to
link to your main workbook, begin typing a formula with =, then click
on the window of the main workbook, select the appropriate sheet,
click on cell H5, then press <Enter>. You should see a formula like
this in your subsidiary workbook:

=[filename.xls]Sheet1!H5

You can then copy this down the column in the subsidiary sheet until
you have accounted for the range H5:H88. If you close the main
workbook you will see the formula will have expanded to include the
full path in front of the filename. Don't forget to save the
subsidiary file. When you subsequently open the file, you will be
asked if you want to update links.

Hope this helps.

On Oct 15, 9:58 pm, Stan Gilbert
I'm hoping I can find someone who can help me create a formula to use in a
spreadsheet.

Let me explain what I am trying to do. I have two workbooks that I intend to
link so the end result in one workbook will appear in columns in the linked
workbook giving me a year end total for our budget.

Currently the workbook I am using is setup like a check register where we
keep track of invoices (Debits and Credits) the results are displayed in
column "H" H5 thru H88.

I need a formula to display the results from column "H" into the linked
spreadsheet so the sum can be deducted or added to the beginning balance so
at the end of the Fiscal Year we will know how much (if any) monies we have
left in our budget.

I hope this makes sense to someone and you can help me figure this out. If
necessary I can email a blank copy of the spreadsheets to indicate what I am
trying to accomplish. Or I can explain it in more detail if necessary.

Any help or advice at all would be greatly appreciated. Thanks.- Hide quoted text -

- Show quoted text -