Hello
I have spent a great amount of time reading and researching, but finally took the plunge and joined this morning.
The prepaid entry I book every month has a isblank and counta formula that numbers each one of the cells in number order, as long as the value is "not blank". (Formula Example: =IF(ISBLANK(AL13),"",COUNTA(AL$13:AL13))These numbers are tied to a Journal Entry Template that we book every month.
Currently I have to manually update the formula to reflect the next column (next month), for each entry.
Could someone help me come up with a solution so the formula does an hlookup based on the value in our posting date cell (JE!C3), to automatically find the right column?
I have attached a modified example of my spreadsheet.
Thanks for your help!
Rick
Bookmarks