Report

[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, D2200 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 D212, 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

 

[Frank Kabel]

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?

 

[Jeff Mackeny]

Frank, can I ermail you the workbook, so you can show me some sort of an
example?

 

[Frank Kabel]

Hi
go ahead, but please include your specification (that is 'wish list')
in your mail

 

[Jeff Mackeny]

Frank, just checkine you got my email?

Hi
go ahead, but please include your specification (that is 'wish list')
in your mail

 

[Frank Kabel]

Hi Jeff
got it, but will take some time

 

[Jeff Mackeny]

Ok thanks, I really really appreciate your help, your the best