jmeleshenko
New Member
- Joined
- Jul 1, 2013
- Messages
- 4
so I have some equipment with 15 fixed slots for each cabinet. I can have up to 5 cabinets in a stack. I can have up to 64 stacks.
With that said, I'm looking for a way to take my current configuration and run a macro where it would find the spare slots in each cabinet within each stack and insert and highlight a line so I know which slots in each stack I could use
attached is my data
https://www.dropbox.com/s/gqyzkx82vrwqadi/example.xls
i.e.
01A00 up to 01A15 then if there is a second cabinet in that stack it would be 01B00 to 01B15
if there was a second 'stack" that would be 02A00 up to 02A15, etc
With that said, I'm looking for a way to take my current configuration and run a macro where it would find the spare slots in each cabinet within each stack and insert and highlight a line so I know which slots in each stack I could use
attached is my data
https://www.dropbox.com/s/gqyzkx82vrwqadi/example.xls
i.e.
01A00 up to 01A15 then if there is a second cabinet in that stack it would be 01B00 to 01B15
if there was a second 'stack" that would be 02A00 up to 02A15, etc
