Inserting blank lines and formulae

Hello,

I have a worksheet that contains data arrange in fields from columns A to J. The relevant columns for the purposes of the macro are columns B (customer codes) and G (sales values). Column B may contain a single instance of a customer code, or multiple (over 50), depending on how active a customer has been. The worksheet always contains many different customer codes with varying numbers of rows for each customer, sorted by customer. What I'm trying to do is write a macro that will loop through the worksheet and insert a blank line immediately after a change in value of column B (customer code), and in this blank line, insert the customer code in column B (which comes from the cell immediately above), a sum formula for all values within a range that relate to that particular customer in column G, and an IF statement in column J that relates to the SUM formula. The loop concludes when there are no longer values in column B.

I have managed to insert blank lines on change in values in column B, but am not sure about the best approach for inserting the SUM formula or the IF statement in columns G and J respectively.

If anything requires clarification, please let me know. Any assistance would be greatly appreciated.

Thanks very much.
Peter

To insert a formula you would use something similar to

Formula:

Please Login or Register  to view this content.

The first puts a formula in A1 that sums B2 and C2
The second is an If statement

If you need something more in depth please attach a sample workbook or your code within code tags.

Hi there,
I've attached a sample file. It should be a little more clear after looking at the worksheet. My diatribe was
understandably confusing.
Thanks,
Peter