Hi
On sheet1 I have a table.
Column a will be: Income, outgoings, savings, investments, pots
Column b will be any description
Column c - n will be months of the the year
The data is then completed for when bills and money comes in to form a budget
On Sheet2 cell c2 contains the month
I want a new table
Column b to show all incomes
Column c to look up b in bring in values
Only if month matches that where data was entered on sheet 1
i.e In sheet 1 I could put an outgoing cost of £50 for valentines and enter that only for feb
sheet 2 would only bring in that cost if we changed the month to feb
I don't want to use a pivot table or filters.
Thanks in advance
On sheet1 I have a table.
Column a will be: Income, outgoings, savings, investments, pots
Column b will be any description
Column c - n will be months of the the year
The data is then completed for when bills and money comes in to form a budget
On Sheet2 cell c2 contains the month
I want a new table
Column b to show all incomes
Column c to look up b in bring in values
Only if month matches that where data was entered on sheet 1
i.e In sheet 1 I could put an outgoing cost of £50 for valentines and enter that only for feb
sheet 2 would only bring in that cost if we changed the month to feb
I don't want to use a pivot table or filters.
Thanks in advance