|Since we don't know the exact layout of your spreadsheet, the best we can offer is a concept. With more details, we can be more specific.|
Let's say Sheet1 has a Monthly dropdown in A2, a Category dropdown in B2 and you are entering your values in C2:
A B C
1 Month Category Value
2 Feb Supplies 250
Let's say Sheet2 looks something like this:
A B C D
1 Month Food Supplies Taxes
3 Feb 250
This Worksheet_Change macro will monitor Sheet1 for any change in C2. When it sees a change in Sheet1!C2 it will "find" the intersection on Sheet2 of the Month and Category shown in the Sheet1 drop downs and copy the value from Sheet1!C2 to that cell.
Let us know if we are on the right track.
Private Sub Worksheet_Change(ByVal Target As Range)
'Determine if change was made to Sheet1!C2
If Target.Address = "$C$2" Then
'Find Month and Category on Sheet2
Set myRow = .Find(Sheets(1).Range("A2"))
Set myCol = .Find(Sheets(1).Range("B2"))
'Use Row and Column values to Copy Sheet1!C2 to the
'intersection of Month and category
Sheets(2).Cells(myRow.Row, myCol.Column) = Sheets(1).Range("C2")
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.