Adding in two blank rows using 2 If values (straightforward, I think....)

[JerryWork]

Hey all.

Been searching around this forum and others for hours to try and fix a little formula, but as it's my first day ever looking at them I'm a bit confused.

I got this formula from another thread

Please Login or Register  to view this content.

which is basically bang on except I want to add another If condition and change it from pasting in one row to two. I want to have the macro such that if, for example, the company name or the currency type changes, then two rows are added below it. So to turn it from this:

Heading 1 Heading 2
Company 1 USD
Company 1 USD
Company 1 GBP
Company 2 USD
Company 2 CAD
Company 2 EUR

to this

Heading 1 Heading 2
Company 1 USD
Company 1 USD


Company 1 GBP


Company 2 USD


Company 2 CAD


Company 2 EUR

Make sense? I appreciate the help!

[RHCPgergo]

Hey JerryWork,

does this work for you?

Please Login or Register  to view this content.

[barryleajo]

Hello JerryWork
With acknowlegements to RHCPgergo, looks like I picked this up at the same time.
I'll post it because there are a couple of slight differences that may be of interest.
1. There is a variable rws that you can set to determine the number of blank rows to insert - may be useful
2. Assumes that Company i/d and the Currency are in separate columns A and B

Please Login or Register  to view this content.

[JerryWork]

Hey guys.

Thanks a million for the super-quick responses. Barry, yours works flawlessly, and that's the one I'll use. It's awesome. I meant to mention that the there were in fact two columns as you say.

Special thanks to you too RHCPgergo . I appreciate the effort involved!