esprit_y2k
New Member
- Joined
- Jan 17, 2006
- Messages
- 5
How to use VBA in excel to change and amend the text in column A to a specific text based on certain criteria? (description in column A based on the number to multiply with column B and get the result in column A)
Example.
Column A = description (text)
Column B = Quantity
Column A1 consist of the following text: "Package 1, WD40, 20 units"
Column A2 consist of the following text: "Promotion - A4 Paper - 5 pieces"
Column A3 consist of the following text: "Best buy Pencil Box 100 units"
Column B1 consist of number (quantity): "2"
Column B2 consist of number (quantity): "5"
Column B3 consist of number (quantity): "1"
After the VBA coding;
Column A1 will become: "Package 1, WD40, 2 x 20 = 4 units"
Column A2 will become: "Promotion - A4 Paper - 5 x 5 = 25 pieces"
Column A3 will become: "Best buy Pencil Box 1 x 100 = 100 units"
Any help will be highly appreciated.
Example.
Column A = description (text)
Column B = Quantity
Column A1 consist of the following text: "Package 1, WD40, 20 units"
Column A2 consist of the following text: "Promotion - A4 Paper - 5 pieces"
Column A3 consist of the following text: "Best buy Pencil Box 100 units"
Column B1 consist of number (quantity): "2"
Column B2 consist of number (quantity): "5"
Column B3 consist of number (quantity): "1"
After the VBA coding;
Column A1 will become: "Package 1, WD40, 2 x 20 = 4 units"
Column A2 will become: "Promotion - A4 Paper - 5 x 5 = 25 pieces"
Column A3 will become: "Best buy Pencil Box 1 x 100 = 100 units"
Any help will be highly appreciated.