Help with Input Box.

M

mju

I am trying to write a program using input box and a loop. I want the
program to ask the user for info for column c(blank cell), which is the
miles, then info for coln a, & B. The program will then take the given info
for col C then loop thru column A . Col C will then be populated with the
given miles until the state(col A) changes. Then another input box will pop
up prompting the user for the new state, miles, qty.

Below is a sample of my data
Col A(state) Col B(qty) Col C(Miles)
NY 2
NY 2
NY 2
TX 1
TX 1
CA 3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent help with input box & loop 1
How Do I 6
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
import text 1
Compare data set 1 with data set 2. Add to data set 2 if not found 0
Loop thru xx No. of sheets until the four strValue combo's are found 6
Cancel (Dismiss) Input Box 1
compare column color row 2

Top