How to populate and filter cells based on information from other cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-2420466%22%20slang%3D%22en-US%22%3EHow%20to%20populate%20and%20filter%20cells%20based%20on%20information%20from%20other%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2420466%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%20sorry%20about%20the%20confusing%20title%20.%20I%20have%20attached%20the%20sheet%20i%20am%20working%20on%20as%20a%20picture.%20basically%20I%20have%20a%20list%20of%20my%20bills%2C%20I%20have%20a%20function%20in%20cells%20G2%20-G9%20that%20tells%20if%20the%20bill%20should%20be%20on%20my%20upcoming%20paycheck%20or%20the%20next%20one.%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I%20am%20hoping%20to%20do%20%2C%20is%20use%20the%20information%20in%20cells%20G2%20-%20G9%20to%20populate%20the%20pay%20day%20section%20with%20the%20correct%20information%20for%20which%20bill%20should%20be%20on%20which%20check.%20Ideally%20without%20any%20blank%20areas%20between%20them%20for%20the%20days%20that%20are%20skipped.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bill%20sheet.jpg%22%20style%3D%22width%3A%20894px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286679iBE80046D403FFDCC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Bill%20sheet.jpg%22%20alt%3D%22Bill%20sheet.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3EThis%20is%20being%20made%20on%20Excel%20for%20web...%20so%20there%20may%20be%20limitations.%20any%20help%20would%20be%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2420466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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. 

Bill sheet.jpg
This is being made on Excel for web... so there may be limitations. any help would be appreciated. 

1 Reply
Honestly,,, it's hazy, quite confusing too,,, please edit the post & be specific what you are expecting as Output,,, better share the WB with us & let us examine the data to fix it !!