Trouble with worksheet layout.

N

Nan

I need to track seven categories of expenses for 14 subdivisions, with data
for Budget, Revised Budget, Incurred To Date, Estimate To Complete, Total
Anticipated. Hopefully this can be done all on one worksheet without having
to scroll to infinity and beyond. I know this would be perfect for a pivot
table. I'm struggling with how to layout the data.
A B C D
E F
Budget, Rev Budget, IncrdToDate,
EstToCmplt, Total Anticptd
Subdivision 1
Permits
Blueprints
Legal fees
Consulting Fees
HOA Related
Property taxes
Misc
Subdivision 2
Subdivision 3, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Ranges 2

Top