View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeffbert jeffbert is offline
external usenet poster
 
Posts: 50
Default Loop thru two sets of numbers

I am new to VBA, basically I record macros/get help here and then manipulate
the code until it works.

I have a macro written to input data into certain cells. The user inputs the
sku # and then inputs the location #, and then the macro is fired. I have a
set list with one hundred skus, and twenty location numbers. What I would
like to do is have Excel look at the first sku number (13328960) and run the
process for each of the twenty locations (161, 181, 182, etc, etc). Once done
with the twenty locations, then go to the next sku number (13328978) and
repeat the process until there are no more sku numbers.

161 181 182 188
13328960
13328978
13328994
13329001

I appreciate any direction that you can give, whether sample code or
references to review.

Many thanks

Jeff