TestBook.xlsx

Hi,

What I am trying to accomplish is to be able to override an equipment with another equipment number for capacity studies. Please see attached file.

The specific job may have one or two processes and therefore two equipment lines to run through.

This override would be entered by individuals on the shop floor so I would like to have this as a sort of pop up window so that they do not need to mess with an =IF function which will work but not as simple as the macro doing the work.

I'm not sure if anything like this is possible but I would really appreciate any feedback you may have.

Thank you!

Jessica