How to link worksheets with specific criterias
 

I would like to know how to link my budget sheet to the individual accounts
worksheets.

Details:
Worksheet 1: "Total Budget" - This is divided by month and grouped by quarter
Worksheet 2: Account # "1111-1111"
Worksheet 3: Acount # "2222-2222"
Worksheet 4: Account # "3333-3333" and so on........

I would like to input the total actual from the accounts and put them in the
correct spot under "Total budget" worksheet, but because it's divided by
month I would like to know if there's a way to put in the formula a "find"
field to search for the month.

Example: In "1111-1111" I have the details broken down by date.......cost so
I would like to be able to put a formula in the "Total budget" worksheet that
will find the month (august) and input the row/column with the cost in it so
it will automatically update each time I input something with the same month.

Please help or e-mail back if you need a better explanation

Thanks in advance!!!!

How to link worksheets with specific criterias
 

Victoria wrote:
I would like to know how to link my budget sheet to the individual
accounts worksheets.

Details:
Worksheet 1: "Total Budget" - This is divided by month and grouped by
quarter Worksheet 2: Account # "1111-1111"
Worksheet 3: Acount # "2222-2222"
Worksheet 4: Account # "3333-3333" and so on........

I would like to input the total actual from the accounts and put them
in the correct spot under "Total budget" worksheet, but because it's
divided by month I would like to know if there's a way to put in the
formula a "find" field to search for the month.

Example: In "1111-1111" I have the details broken down by
date.......cost so I would like to be able to put a formula in the
"Total budget" worksheet that will find the month (august) and input
the row/column with the cost in it so it will automatically update
each time I input something with the same month.

Please help or e-mail back if you need a better explanation

Thanks in advance!!!!

Hi Victoria,

I think you could use a SUMIF or a SUMPRODUCT, depending on if the month is
text or a date formatted to display the month's name...

I think it could be simpler to help you if you could upload an example file
to www.rapidshare.de.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy