First Post!



So I don't really know how to ask this but I'll just explain the situation and see what you guys think.

At my work we travel with a lot of video equipment and for insurance reasons we make a list of what we have with us at the time. For every trip we take we need to make a different list because we take different equipment every time. The list consists of model #'s and serial #'s with a letter head and some other info. The way we do it now is we have a master list with everything on it and then we copy and paste into a new doc to make the list for that trip. Very time consuming and a pain!

I'm wondering if there is a way to make a document that has everything on it and then we just go through and check everything that we're bringing. Then when we print or something we just say "print checked" or something. We have Word and Excel. I don't even know if this is possible in either of those apps. If there is some other software that someone could suggest that would be great!

Sorry if this is something super easy. I don't know a ton about Word or Excel. Thanks for any help!

Hi
You can do this in Excel with Advanced Filtering.
If you are able to send a post of your document I will see what I can set up for you.
Tony(OTPM)

I have the list in a excel doc already. How can I send that to you? PM me your email?

Hi
Please find a solution attached. I notice that you are using Office for Mac so I am hoping this solution will work as it is based on Office for Windows.
Here's how it works:
1. With your worksheet open double-click in Column C each row you want to include in your printed list. This will put a "Y" in each cell you double-click in.
2. Then enter Ctrl+q. This will filter your list based on your selections and you can print your filtered list.

The code for the double-click is sitting behind the worksheet. To view this code simply right-click on the tab for Sheet 1 and select view source.

Then there is a macro attached to this workbook that does the filtering for you based on your selections. It will run for up to 1000 rows. If you need more rows then just open the macro and change "1000" to a number that suits your requirements.

When you want to do a separate list then simply turn off the filter manually and follow the instructions above.
Good luck.
Tony(OTPM)

Attached Files

Equipment List.xls (46.5 KB, 10 views)

This is great! Thanks for your help. It works perfectly!