Insert Rows based on Countif results

[NBVC]

Hi everyone,

I am trying to insert rows based on the result of Countif's. How would I go about doing this using VBA....still trying to grasp many VBA concepts.

In Sheet1 I have a bunch of names in A1:A30, many are duplicates.

In Sheet2 I have a unique list of names that are found in sheet 1. This list is in A1:A5

Starting at A10, I want to insert the name in A1 and insert rows below = the number of times that name is found in Sheet1!A1:A30. Immediately following I will insert next name and repeat procedure until all names have been cycled through.

Thanks in advance.

 

[Norie]

NBVC

As far as I can see that piece of code is just replacing the formula with the value.

 

[Gates Is Antichrist]

As far as I can see that piece of code is just replacing the formula with the value.

How is that?

I thought I had a good grasp on Offset and Resize, but

 

[Norie]

Gates

It's nothing to do with the resize or offset, the key thing is Value.

 

[NBVC]

NBVC

As far as I can see that piece of code is just replacing the formula with the value.

You are right, Norie.

If I comment that line out, then I do see the formulas in the spreadsheet.

If I leave the statement, I see the values only.

Thanks.

 

[Krishnakumar]

Hi NBVC,

Sorry for the late reply. But I think Norie answered your query.