VBA to Autofill cells from Multiple Combo Box Selections & Add below last entry in list

Hi All

Please find attached workbook with format layout and sample data. We have 3 identical turbines that require us to lock out certain switches valves when working on the equipment. The only diffrence in the location / name of the switch or valve to lockout.

I would like if possible to have 2 dropdown lists one is to select which turbine the other what part of the system you are working on. depending on the selection the cells A7-A51 on the main worksheet would be filled with data from the Unit selected worksheet. and then if more than one part of the system needs to be locked out the code would see where the last entry is in colum A and add the next selection below this.

The maximum ammount of locks/tags per system would be 15 but i have only added some sample locks on each units worksheet

If the list of locks on the main sheet was more than the cells avalible as i have formatted for A4 print could it create an extra page or maybe im getting ahead of myself.

Any help apreciated also if this seems a bit too much i will purchase 100 points to speed up the process

Thanks

Hey thanks for the quick reply and great code it does work a treat.

Only problem is if the data goes over row 51 i get an error 1004 cannot change part of a merged cell.

I thought the problem was in the last bit of code ws1 should it be LR1 not LR but i tried that without success. I then tried to just move the data over to colum F which worked ok but only once the data would not keep adding below just over writing the last entry.

Thanks again i suppose i could just do 2 sheets if i have over 51 entrys to make. I just wanted to make it as easy and safe as possible for my guys to use They end output will be printed and used to walk around the plant.

Hi John

I would ultimately like to be able to print at A4. With the Header i have in rows 1-6 at the top of my print, then the footer rows 52-55 at the bottom of the print
And then the data in the middle maximum of 80 rows total. Can be 2 pages printed of course.

I was thinking maybe after row 51 the next data added would be placed in F7 and continue adding below that like you have it now. I can then duplicate the header and footer for print purposes.

Or maybe theres an easy way

Thanks again

Hi John

Great work with the multi page. I just have one issue.

Data will only copy over to the second page if it started on the first page. When i try to add data below the last entry on page 2 the Counter in A1 adds up but nothing is shown on page 2.

I though it was because i had messed about with the layout format, but seems to be the same on the LockoutV1 you originally posted.

Also i added some code to clear BG colour aswell.

Thanks