Donate SIGN UP

How do i only print rows that I have ticked in a check box?

Avatar Image
pmh0183 | 22:35 Thu 06th Mar 2008 | Technology
4 Answers
I work in a transport rental company and need to design a list of parts that go with certain vehicles. However, some of the same parts are used with some vehicles but not others so i need a long list which i can pick from.

Therefore, in either MS Excel or Word, I want to design a list (table) of all the parts (along with photos) with check boxes at the side and then I can tick the check boxes of which parts i need for that particular vehicle. However, I only want these parts to be printed.

So basically I want a long list but for it only to print the few rows that I need at that partciular time. I understand how to add check boxes but not how to only print the ones which i have 'checked'.

Can someone please, please help?

Thanks in advance
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by pmh0183. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Little out of my depth but as you don't have any answers yet I'll chip in with my offering. I would create a macro for this as I don't think you would be able to expect the printer to decide which has ticks and which don't. I have done similar sorts of things by recording a macro and then running it. You can include the "print" instruction in the macro and a button on your toolbar or in the sheet to run it. Whatever you decide to do though, at some point you're going to need an instruction that detects ticks in boxes but I've got no idea about, sorry. Best of luck. There's a guy in Newcastle Australia somewhere on AnswerBank and he'd sort it I'm sure if you could get hold of him but unfortunately I've forgotten his name. Great with Excel though!
You could sort the data in Excel by the checkbox and only print the pages with check boxes or paste these rows to another table. You would have a check box column for each model.

However you would be better off doing the task in a database. It introduces a much better way to select the records automatically by simply asking for the data related to a particular model.

In a database you have multiple tables. For example your "Parts" table might have columns for the part number, description, cost, selling price, supplier etc. It would also have a PartUnique column that is the index key of the part. You can change anything in the record except the index.

Another "Vehicle" table might have one column for the part and columns for each model. Each record would show the type of part and the index key from the parts table under the column for the particular model. A "Substitute parts" table could be used and a query could select the best price, availabilty or whatever.

Queries are designed to list all the records from the parts table for the index key numbers under the model you are working on. You could also make a query that lists all parts from a particular supplier for a particular model.

Microsoft Access is not so hard to use as it first appears and it offers so much more power to manipulate and link data. Access is part of Office Professional.

It is well worth learning databases. However you can start out with the spreadsheet and import it to Access later.
the option you need is "filter"

(I'd make a copy to play with to start ....)
create a list with headings (larger font ... in bold) for each column

Make fure you select the top entry (a1?)
go to data | filter | autofilter
and that's it

to undo - go to data | filter | autofilter

easy - at least for starters ... of course you can get much more by using the advanced options (do that tomorrow!!!!!)
Forgot to actually say (it's probably obvious though)
make column 1 the "tickbox",

enter a single character as the tick (x?)
and then sort on that

1 to 4 of 4rss feed

Do you know the answer?

How do i only print rows that I have ticked in a check box?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.