I have a spreadsheet where beginning in B2, I have todays date formula. B3 then has =B2+1 which I copy down. So the cells in column B will change each day.
Then in A2, I reference cell B2 and format it as DD so the cell will show, for example: 05 if cell B2 is April 5, 2014.
I then have another workbook with a budget where:
Column A has the number day of the months of a certain bill.
Column B has the Company name
Column C has the amount due.
I then named this list and used that name in a lookup formula in the cash flow sheet
The goal being to do a VLOOKUP in the cash-flow sheet so that each date will show next to it, the company name, then the amount due by referencing the date number DD.
Hope this all made sense. I used various methods that worked, but was trying to scale down my entrée sheet and use less references and get rid of duplicate date to speed up the opening of the file.
Then in A2, I reference cell B2 and format it as DD so the cell will show, for example: 05 if cell B2 is April 5, 2014.
I then have another workbook with a budget where:
Column A has the number day of the months of a certain bill.
Column B has the Company name
Column C has the amount due.
I then named this list and used that name in a lookup formula in the cash flow sheet
The goal being to do a VLOOKUP in the cash-flow sheet so that each date will show next to it, the company name, then the amount due by referencing the date number DD.
Hope this all made sense. I used various methods that worked, but was trying to scale down my entrée sheet and use less references and get rid of duplicate date to speed up the opening of the file.
