Neatly present data from a multi-record file

Hi Patrick

Considering that 68 people (at least) have read your thread, and not 1 has offered any suggestions, I would recommend that you consider expanding on your description, and consider that perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Without VBA I'd probably do it like this. Can you live by adding Column A to your data base and keep numbering as you go along. The scrolling bar will go only to 100, if you need more than that; right click on the scrolling bar and set the Max value you desire (current is 100). If scroll to a record that does not exist, then each field in the summary page will show you "No Record Found" (you can change that text from each formula), ensure each line in the database has a number and is numbered consecutively.

Now, that I think about it. You didn't need an additional column for numbering the records. You can do that with a Index/Row Match/Col Match. You could have match the row number to the scroll bar linked cell.

If you know how to use the INDEX formula, then you can use that instead of the vlookup and delete column A from the database sheet.

Originally Posted by ron2k_1

Without VBA I'd probably do it like this. Can you live by adding Column A to your data base and keep numbering as you go along. The scrolling bar will go only to 100, if you need more than that; right click on the scrolling bar and set the Max value you desire (current is 100). If scroll to a record that does not exist, then each field in the summary page will show you "No Record Found" (you can change that text from each formula), ensure each line in the database has a number and is numbered consecutively.

This is WONDERFUL Ron! Thanks! I am not sure what you mean by "scrolling bar"? Is it the windows scroll bar? I will need to set the max to about 300.


edit - Which sheet is the scroll bar found and approx. where on the sheet is it located!?


Thanks again!
Pat

I called the bar that you click on to move to the next/previous record on the sheet "Form" (on top row 2 starting at column B:F) a scrolling bar. Although the proper name is a "Spin Button" ActiveX control...

To set the max value (this can be done via macro but I kept your sheet sanitized without any vba) you need to go to Developer tab, click on Design Mode, got to "Form" worksheet, right click on the Spin Button, select Properties, Select Alphabetic tab, look for the Max field and set it to whatever you need.

I've modified the sheet I gave you and deleted column A (which I inserted on my previous submission) on the worksheet DATA. As I said on my previous post, I realized that you don't need it with a different formula and will save you the trouble to number each record consecutively (in ascending/descending order).

No worries; this is what we do on here. I got tons of help from this people and I'm pretty sure they didn't expect anything in return. A simple thanks by way of pressing the little star on the bottom left corner is enough.

If you follow my procedures to get to the Properties window of the spin button you'll notice that there is a field called "Linked Cell". Here is where the bar knows which record it is on, the number ranges between the set Min/Max values (set in Properties). So you can create another field on the Form page (say cell I1); call it (whatever you want) "Record Number", and then change C2 (linked cell in Properties of spin button) to J1. You can then type any number in J1 and form will sear for that record.

I cannot think of any other way that will not require some VBA finessing.