Compile a list from 1 worksheet and copy or populate a new worksheet within the workbook

[cblgod1]

I am attaching the file in its current state........ All of the info needed is on the comments page or 2 page in the workbook.
Any help will be greatly appreciated.

The request, for others that may search for the same answer is.......

Need a list to populate on another worksheet using data (conditions) from another.

Example.
Need all Locations, that need repair/replacing or need to be watched, to populate a list on another worksheet. Which will allow
the technician to type in comments on the repair needed. Then print it and add to the service contract.

I also need it to adjust the list to fit as many locations as necessary.


Thanks a mil!

[jaslake]

Hi cblgod1

Welcome to the Forum!!!

In your Sample File, what is the Room (perhaps Water Heater?)? What is the Location (perhaps Safety Sticker?)?

[cblgod1]

Room= kitchen, bathroom, etc.
Location= faucet, valve, etc.

[jaslake]

Hi cblgod1

I assumed such...get back to you.

[jaslake]

Hi cblgod1

This Code is in the attached. All Code is in the Code Module for Sheet Checklist. Let me know of issues.

Please Login or Register  to view this content.