Insert Rows if data is missing from main sheet

Hello All,

I am trying to write a formula that will add in 4 extra rows if a number in the check sheet is not in the main sheet and have the same text as the rest in column B with the same formatting. I will describe what is going on in my sample book as an explanation.

In the main sheet, you have your price, cost and GP and all the accounts that were active in that period. On the check sheet, you have all the accounts in the system that need to be included on the main sheet. I am trying to find a way to do a count to see if all the numbers on tab "Check" are in tab "Main". As you can see, there are 4 that are not. I am trying to write a macro that does a countif and if it is less than 1, insert 4 new rows with that account number and have it display the PRICE, REVENUE and GP like it is formatted in the main tab. It would be great if there was a way to make it insert after the previous number in the series, e.g. 4905 being inserted after 4904 and before 4906.

Thank you all!

Good Morning,


I would do something like this

Please Login or Register  to view this content.

Try,

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Stnkynts, yours seems to work pretty well. It inserted it into the correct rows but when it hit the 5000s it started to go from the upper numbers to the lower, e.g. 5905, 5904, 5903.... instead of 5903, 5904, 5905