Hello experts,
Im new to macros.
Heres the question concerning the following tables:

How do I tell excel to copy calculator!B4:B7, look at calcultator!b1 to find the value "2014-1", match it with masterdata!A2, and "special paste, transpose" the values to cell c2?

Here's my dilemma. Im creating a document to calculate my family budget. I have a "masterdata" sheet and a "calculator" sheet.

The masterdata sheet contains rows for month and columns for my income, expenses and savings. The expenses category contains 4 subcategories: Food, Utilities, Gasoline and Dining out. Looks something like this:

TABLE "MASTERDATA"
A B C D E F G
1 Month income food util. gas Dining savings
2 2014-1 $1000 200 100 50 75 500
3 2014-2 $1300 250 100 150 200 300


The calculator sheet grabs my income depending on the month selected and allows me to juggle the numbers and see how much do I have available. So, for instance, if I select 2014-1 , the "$$ available" cell fills with $1000.
Then, I can input my expenses to try and stretch the money. The calculator looks like this:

TABLE "CALCULATOR"

A B
1 Select month: 2014-1
2 $$Available: $1000
3 $$Remaining ($available minus expenses)
4 food 200
5 util 200
6 gas 200
7 dining 200
So in this case, the cell b3 ($$remaining) would calculate a remaining $200.

Here comes the question. I want to create a macro that grabs the values from the calculator and pastes them to the masterdata sheet, at the row for 2014-1 (or any other month selected in the calculator) and the column where the expenses are stored.

Is this possible?

How do I tell excel to copy calculator!B4:B7, look at calcultator!b1 to find the value "2014-1", match it with masterdata!A2, and "special paste, transpose" the values to cell c2?