Hi guys, I'm making a map of a warehouse using excel mac 2008. I made the grid into small squares, and drew the floor plan with racks/shelving and such. I used cell borders to indicate walls and aisles.
I don't simply want to use this as a "snapshot in time" map, I want to use it as an interactive document for our inventory manager to plan out where to put boxes of our product (pallets of boxes). I would really like to program the worksheet so it locks the wall and shelving cell borders, so the user can drag our products (merged cell groups colored brown with text in them) in and out of the racks without replacing the border formatting. Is this possible? From what I know, I'm guessing there would be a VB script/formula/macro that constantly refreshes, and sets those borders every time something is dragged around. Is that correct? or is there a setting to drag and drop without overriding border formatting? any suggestions are appreciated, thanks!
I don't simply want to use this as a "snapshot in time" map, I want to use it as an interactive document for our inventory manager to plan out where to put boxes of our product (pallets of boxes). I would really like to program the worksheet so it locks the wall and shelving cell borders, so the user can drag our products (merged cell groups colored brown with text in them) in and out of the racks without replacing the border formatting. Is this possible? From what I know, I'm guessing there would be a VB script/formula/macro that constantly refreshes, and sets those borders every time something is dragged around. Is that correct? or is there a setting to drag and drop without overriding border formatting? any suggestions are appreciated, thanks!