Macro to append string of cells into specific row and colum??

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?

Hi Mumps1,

Thank you for taking the time to provide a solution. Just a quick question. In this line:

LastRow = Sheets("MASTERDATA").Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

what does the asterisk mean ??

Im going to try and use this formula with the real tables and see how it works. Thanks a bunch!