User Form - Displaying Data from Sheets

[Jamie2002]

Probably really easy this one.

I'm working on budgets.....(great).....I would like a User Form that floats above the sheet and displays key data eg Profit - but it is always visible while I'm off on an assumptions sheet making changes. Also it would need to be dynamic and constantly updated.



Thanks

Jamie

 

[SkipVought]

Jamie,

Why not consider using a row or two at the top of your sheet for the summary data and using the Window/Freeze Panes feature.

BTW, when I am doing reports with totals, I almost ALWAYS put totals at the top. The practice of placing totals at the bottom of a multi-page list is a throwback to the days of paper, pencil & adding machine. Why force a user to seek the last page, when Excel can very easily put "the bottom line" right at the top for all to see in an instant!

I even do this with multipage horizontal totals.

Think OUT-OF-THE-BOX! (Unfortunately, you'll find some managers want it the old way, just because it's the way we've always done it. I shows no immagination, creativity or practicality!)



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com