How to view each row as a "record" or 1-screen ??

  • Thread starter Thread starter tmb
  • Start date Start date
T

tmb

We have a spreadsheet with about 26 columns per row.

We want to display each row as a record or "screen"

Is there anyway to do this without becoming a VBA programmer?

Or, is there any sample code we could use as a model and tweak?

thanks for any help.
 
Where on your screen do you want to see the 26 values for each record, ie
what ranges do you want the data in.

You can likely do this quite easily with the OFFSET function and a spinner
from the forms toolbar. No VBA in sight.

Assume you have set up the spinner such that it links to cell A1 (Stick the
spinner over the top and it will look nice and neat). Now assuming you
wanted say B5 on your screenshot to pick up data from Col F on your 'Raw
Data' sheet, in B5 on your screenshot sheet simply use

=OFFSET('Raw Data'!$F$1,$A$1,0)

Repeat for all values but switching the Column reference as necessary. Then
when you hit the spinner and notch A1 up or down the screenshots will all
change accordingly for the next record.
 
If you are perhaps trying to replicate screenshots from another application,
then with various formatting etc this can usually be achieved quite easily.
If you have a picture of the screenshot in mind then I'd be quite happy to
knock up a quick dummy file for you as an example.
 
Ken,

I've found the Forms Tool bar and hovered over each option. But, I don't see
one labeled "Spinner"

Can you give me a little more info on what a "Spinner" is?

thanks
 
When my Forms toolbar is just one level high, it's the 12th one to the right.

It looks like two arrows/triangles butted together. One pointing up and one
pointing down--with their bases joined together.

It looks a lot like the Scrollbar (directly to its left), but with just the
arrows--not the bar itself.

If you look at Tools|Options|General tab, you can see a couple--on in the
"sheets in new workbook" box and one in the "Recently used file list" box.
 
Just email it to me at ken dot wright at ntlworld.com and I'll try knock up
a quick replica. depends very much on what you are trying to create, but
happy to try.
 
Found it.

Thanks

Dave Peterson said:
When my Forms toolbar is just one level high, it's the 12th one to the
right.

It looks like two arrows/triangles butted together. One pointing up and
one
pointing down--with their bases joined together.

It looks a lot like the Scrollbar (directly to its left), but with just
the
arrows--not the bar itself.

If you look at Tools|Options|General tab, you can see a couple--on in the
"sheets in new workbook" box and one in the "Recently used file list" box.
Click to expand...
 
Back
Top