Paddy1979
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 608
Hello All,
Please can you help?
I have an order form the Worksheet is named 'Stock Orders' Column A contains part codes Column B is for qty's required.
On another worksheet named 'Pack Sizes' column A has part codes and Coulmn B contains pack sizes, i.e. part AI56 comes in packs of 10.
Is there away in VBA where if someone places an order for AI56 qty 6 the cell automatically will round to 10.
If anybody has a link, or any advice that would be much appreciated.
Please can you help?
I have an order form the Worksheet is named 'Stock Orders' Column A contains part codes Column B is for qty's required.
On another worksheet named 'Pack Sizes' column A has part codes and Coulmn B contains pack sizes, i.e. part AI56 comes in packs of 10.
Is there away in VBA where if someone places an order for AI56 qty 6 the cell automatically will round to 10.
If anybody has a link, or any advice that would be much appreciated.