Unobtrusive Place To Put Report TItle and a List?

[(PeteCresswell)]

I just wrote some code to convert render an MS Access report into a
Excel 2010 spreadsheet.

Right now, the first row of the sheet is the report's title and, over to
the right of the "real" data, is a list of funds covered by the report.

Seems to me like life would be easier for users if that title weren't
trashing up the first row - so there would just be column headers and
data like everybody's used to working with - and they could see the fund
list easily (now, because of the number of columns, it's off-screen for
most monitors).

But the title and the fund list have to go somewhere.

Only thing I can think of is one or two large yellow "Comments" box(es)
linked to one of the top cells.

Is there another alternative (besides laying in a bitmap)?

 

[Michael Bednarek]

I just wrote some code to convert render an MS Access report into a
Excel 2010 spreadsheet.

Right now, the first row of the sheet is the report's title and, over to
the right of the "real" data, is a list of funds covered by the report.

Seems to me like life would be easier for users if that title weren't
trashing up the first row - so there would just be column headers and
data like everybody's used to working with - and they could see the fund
list easily (now, because of the number of columns, it's off-screen for
most monitors).

But the title and the fund list have to go somewhere.

Only thing I can think of is one or two large yellow "Comments" box(es)
linked to one of the top cells.

Is there another alternative (besides laying in a bitmap)?

You can store values in a "Name". That would work well for the title,
but a list can only be entered as a string of delimited items.

 

[John Jones]

On Sat, 28 Jun 2014 16:55:13 +1000, "Michael Bednarek"

You can store values in a "Name". That would work well for the title,
but a list can only be entered as a string of delimited items.

You could use a text box for the title and start the spreadsheet data a
few rows below row 1 to give it space.
HTH
JJ

 

[(PeteCresswell)]

Per John Jones:

You could use a text box for the title and start the spreadsheet data a
few rows below row 1 to give it space.

That's what I'm doing now - and throwing in a Freeze Panes to keep the
col headers visible.

But users are used to clicking entire columns to do things like Cut,
Copy, Paste, Format Cells, and Sort.

 

[GS]

<FWIW>
I'm liking the idea of the data on one sheet with headings (ergo
fieldnames) and so I'd probably put the other report detail on a
separate sheet OR in a modeless userform.

 

[GS]

You can store values in a "Name". That would work well for the title,
but a list can only be entered as a string of delimited items.

<FWIW>
You can store a delimited string in a 'Name', just its length will be
limited to the max characters allowed!