Hi Everyone,
I've encountered a bit of a problem and would love some help with some coding & VBA .
I have a personal finance budget and I usually go through different months (cell F2 in overview sheet which I have since defined & named as "Period" ) to check things. This is a drop-down list. But I could be in Dec of last year and would like to easily go to the current month.
I need a VBA code that allows me to search through the pay periods (in relation to today's date) in first picture and insert that into the bit in blue (cell F2 or period in overview) .
I would normally use an excel function as per below but would rather have a macro that can input the relevant pay date into the cell E2 in Sheet "Overview".
I would normally use something like this in excel but not sure when it comes to vba.
" =INDEX(Table10[Period Date],MATCH(TODAY(),Table10[After Date],1)) "
any help would be greatly appreciated,
I've encountered a bit of a problem and would love some help with some coding & VBA .
I have a personal finance budget and I usually go through different months (cell F2 in overview sheet which I have since defined & named as "Period" ) to check things. This is a drop-down list. But I could be in Dec of last year and would like to easily go to the current month.
I need a VBA code that allows me to search through the pay periods (in relation to today's date) in first picture and insert that into the bit in blue (cell F2 or period in overview) .
I would normally use an excel function as per below but would rather have a macro that can input the relevant pay date into the cell E2 in Sheet "Overview".
I would normally use something like this in excel but not sure when it comes to vba.
" =INDEX(Table10[Period Date],MATCH(TODAY(),Table10[After Date],1)) "
any help would be greatly appreciated,
