Hi , sorry about the confusing title . I have attached the sheet i am working on as a picture. basically I have a list of my bills, I have a function in cells G2 -G9 that tells if the bill should be on my upcoming paycheck or the next one.
What I am hoping to do , is use the information in cells G2 - G9 to populate the pay day section with the correct information for which bill should be on which check. Ideally without any blank areas between them for the days that are skipped.
This is being made on Excel for web... so there may be limitations. any help would be appreciated.