Link template cell to workbook

[mac2night]

First time user. I got this link from another person trying to help from another site called http://forums.techguy.org/business-a...mula-help.html after about 800 views i got no help, well one person was kind enough to help. He gave me this site to try. Ok lets get to it.

On the invoice sheet you will see a date and some other cells marked in Blue, those are the cells we will be working with. Now I put this invoice sheet in the Gallery's folder for easy access. Also on the Revenue tracking page there is some areas marked in Orange, that is the area i need the info. From their I would like to keep the rest of the Revenue tracking page updated, that's the easy part. On to the hard part.

On the Invoice sheet in cell G9 I need to put the current date. I need the month that is inputted to be linked to the correct month on the Revenue tracking sheet, the part in Orange. Next to the Orange part is Quantity and Total. The info that is inputted on the Invoice sheet marked as Blue for Quantity and Total (C24,F24) needs to be automatically added to the respective cells on the Revenue tracking sheet. Anytime i make a new Invoice sheet the new date (month) needs to automatically be linked to the correct month and new Quantity's and Totals automatically added to keep a running tally.

For those that like to work in formulas I will have a go at explaining that way. If Invoice sheet G9 (month) = the same month in (E35 or E36 or E37 or E38 or E 39 or E40 or E41 or E42 or E43 or E44 or E45 or E46) on the Revenue tracking sheet then put info from cell C24 and F24 from Invoice sheet in cells F35 through F46 and G35 through G46 on Revenue tracking sheet respectively. Also keep a running tally.

[mac2night]

Some kind of help would be greatly appreciated. Pos or neg, just something. Thanks

[Marcol]

In Sheet "Invoice" G9 the date manually entered.
or

Please Login or Register  to view this content.

In Sheet "Monthly Sales" F35

Please Login or Register  to view this content.

In Sheet "Monthly Sales" G35

Please Login or Register  to view this content.

Drag/Fill both Down

But what this achieves, and where you go from there, I don't know.

[mac2night]

WOW. After lord knows how many days I have been trying to figure this out YOU got it.
But just a couple of things i still need to work out. I can see I do not have my workbook laid out right yet.

What I am trying to achieve is to input data on an invoice for a customer (which changes) and have the info put in a workbook for Revenue tracking. And keep up to date and a running tally of all invoices. The info for the Revenue tracking sheet will be divided up Q1-Q4 totals and such. I will also make a workbook for each customer like **** and Jane and Bob and Tom and so forth.

[mac2night]

Can I link cell F35 and G35 from the Monthly sales workbook to a template that I made called Invoice??

[mac2night]

Ok thanks.