Hi I have some raw data which is basically customer order information with the following column
Date ordered / customer name / item ordered / quantity / unit price /net value
The problem i have is that in the long list of data the date ordered and customer name only appears in the first row of that orders details so if the customer has purchased more than one item after item 1 rows a and b are empty.
I therefore need some code that will look a cell a1 and if there is an entry in that cell look at the row below and if a2 is empty and there is an entry in c2 copy a1:b1 down and repeat this until it gets to the bottom of all of the data.
Many thanks in advance, Kerrold
Date ordered / customer name / item ordered / quantity / unit price /net value
The problem i have is that in the long list of data the date ordered and customer name only appears in the first row of that orders details so if the customer has purchased more than one item after item 1 rows a and b are empty.
I therefore need some code that will look a cell a1 and if there is an entry in that cell look at the row below and if a2 is empty and there is an entry in c2 copy a1:b1 down and repeat this until it gets to the bottom of all of the data.
Many thanks in advance, Kerrold