Hi Everyone,
I have a workbook that has sheets for entire year. Each month has about 50 clients. I have a summary sheet that contains only those clients that owe money. I don't want all of them listed on it.
I don't even have the beginnings of a formula at this point. I could make one up but it would probably be really wrong!
I need a formula that will search a column (in my example column F) and when it finds a number (not zero) it will take the name (column B) and amounts (column D and E) and list them onto the sheet titled Amt Due. After it lists one, then it would of course go to the next row on sheet Amt Due and list the next information that it comes to.
On my example, rows 6 through 14 are how the information would look from sheet Jan.
Any help at all is greatly appreciated!!
Bookmarks