- Joined
- Jun 26, 2015
- Messages
- 1
- Reaction score
- 1
Hello guys,
I am new to this forum, have read that you are very good in helping people out.
Maybe my excel languague is very basic, hopefully you ll be able to understand what i m struggling with.
I want to use a VBA to select the value of a range in sheet1 and then got to sheet2 and distribute the values to the corresponding rows (each value represents a quantity of a text box in sheet 1.
Small example:
Sheet 1:
Name: Quantity:
Remote control 6
mousepad 5
keyboard 8
Sheet 2: Quantity:
Mousepad ?
HDMI cable ?
usb-HUB ?
Remote control ?
usb-stick ?
keyboard ?
Hopefully you have the solution for me.
Thank you,
alspinazio
I am new to this forum, have read that you are very good in helping people out.
Maybe my excel languague is very basic, hopefully you ll be able to understand what i m struggling with.
I want to use a VBA to select the value of a range in sheet1 and then got to sheet2 and distribute the values to the corresponding rows (each value represents a quantity of a text box in sheet 1.
Small example:
Sheet 1:
Name: Quantity:
Remote control 6
mousepad 5
keyboard 8
Sheet 2: Quantity:
Mousepad ?
HDMI cable ?
usb-HUB ?
Remote control ?
usb-stick ?
keyboard ?
Hopefully you have the solution for me.
Thank you,
alspinazio