MissRibena
07-24-2006, 02:07 PM
Hi everyone
I've been teaching myself some VBA with online resources and a book from J. Walkenbach. I've fiddled around with different Do While and For Each combinations but I'm getting nowhere.
The "Before" worksheet in attached workbook represents the file as it is exported from our accounts package. I need to copy the Customer name in C Column (e.g Plastic Components) beside each item on that customers account so that the customer's name appears in the B Column (see "After" worksheet) (for each customer). I just can't seem to get the code to recognise that each customer may have different numbers of transactions.
Maybe this is way to advanced for me as a beginner. And sorry in advance if I've posted in the wrong forum and thanks a million for having a look.
Rebecca
I've been teaching myself some VBA with online resources and a book from J. Walkenbach. I've fiddled around with different Do While and For Each combinations but I'm getting nowhere.
The "Before" worksheet in attached workbook represents the file as it is exported from our accounts package. I need to copy the Customer name in C Column (e.g Plastic Components) beside each item on that customers account so that the customer's name appears in the B Column (see "After" worksheet) (for each customer). I just can't seem to get the code to recognise that each customer may have different numbers of transactions.
Maybe this is way to advanced for me as a beginner. And sorry in advance if I've posted in the wrong forum and thanks a million for having a look.
Rebecca