I'm a beginner/intermediate user of Excel. I don't know if what I'm trying
to do is even possible.
I have one worksheet that contains marketing expenditures. Each row by
column has the following type of information: Vendor name, amount of invoice,
corresponding company account number.
The other worksheet is our budget. I have one column that is our budget by
company account numbers and the other is actual by company account numbers.
I want to link account numbers with corresponding amount of invoice to the
spreadsheet that contains the actual spent to corresponding account numbers.
I want to do this , if possible, with one link.
Does that make any sense?