Hi,
i hope someone can help me with this matter
I try to explain it very simple
My excel sheet has different values in column A, but there could be also duplicates
I want now that for every value in Column 1, vba asks me to put a value into an input box and pasts the answer in the corresponding filed(s) in column 2.
For the excel above i want that vba ask me 3 times to input a value (A, B and C) and then copies the value in the column 2
for example, It asks me one time to input a value for "A" and copy the input from inputbox in cells B2, B3 and B4
thanks in advance
i hope someone can help me with this matter
I try to explain it very simple
My excel sheet has different values in column A, but there could be also duplicates
I want now that for every value in Column 1, vba asks me to put a value into an input box and pasts the answer in the corresponding filed(s) in column 2.
For the excel above i want that vba ask me 3 times to input a value (A, B and C) and then copies the value in the column 2
for example, It asks me one time to input a value for "A" and copy the input from inputbox in cells B2, B3 and B4
thanks in advance