Report

  • Thread starter Thread starter Jeff Mackeny
  • Start date Start date
J

Jeff Mackeny

oops forgot to include my second question.

I have 12 sheets Jan, Feb, Mar....with a list of 200 people on a list
B2:B200, then C2:C200 is 'Base Rent, D2:D200 is 'Section 8', E2:E200 is
'Tenant Portion', F2:F200 is payment, and so on, I want to create soft of
like an Overview or report sheet off all these numbers for each month, so I
was thinking (if at all possible) to create a drop down list on the report
sheet from the list of people say in B1 or drop down list from the list of
Apt in A1. C2:C12 will list all months then D2:D12, E2:E12, F2:F12.... will
have a formula to check the person in B1 and sum all date from all sheets.

I truly hope this is possible, if not does anyone have any other idea

Thanks
 
Hi Jeff
though this is possible (but will require complicated formulas) have
you considered combining your data on ONE single sheet, adding a column
for the month / date and then using a pivot table on this data (or
other formulas like SUMIF, COUNTIF) on this consolidated table?
 
Frank, can I ermail you the workbook, so you can show me some sort of an
example?
 
Hi
go ahead, but please include your specification (that is 'wish list')
in your mail
 
Back
Top