j.smith1981
02-23-2009, 05:29 AM
I have a big big problem.
I am wanting to make a macro loop within a loop (or at least years ago when I attempted something like this it was a loop within a loop).
The thing is (I have attached the 2 files for peoples reference).
I want the macro to take the '!PRODUCTCODE' column for each cell, go to the data.xls file, find the corresponding 'product code' in the first column.
Then move to the right and select 'Manufacturer' this would then auto input a slash '/' and then input the cells value to the right Printer.
If the product code is the same below, like same column but the row down, has the same value as the preceding cell, then this would add a new column after categories and do the same again.
Repeating the process down the list, how would this be possible please?
Thanks in advance,
Jeremy.
I am wanting to make a macro loop within a loop (or at least years ago when I attempted something like this it was a loop within a loop).
The thing is (I have attached the 2 files for peoples reference).
I want the macro to take the '!PRODUCTCODE' column for each cell, go to the data.xls file, find the corresponding 'product code' in the first column.
Then move to the right and select 'Manufacturer' this would then auto input a slash '/' and then input the cells value to the right Printer.
If the product code is the same below, like same column but the row down, has the same value as the preceding cell, then this would add a new column after categories and do the same again.
Repeating the process down the list, how would this be possible please?
Thanks in advance,
Jeremy.