Delete Rows based on cell value and then Insert rows alternatively with a formula

Hi Friends & Gurus,

I am having a workbook consists a number of formulas & functions. I would like to do the following:

1) In (Ranges A2:Z1000) if cell value is 0 in column A, then the entire row should be deleted.

2) Then, in between two rows, one row must be inserted with a formula.

I have attached a sample file and explained the problem also.

As like earlier, I hope someone will help me to solve this problem.

Thanks in advance.

acsishere.

If you are in a hurry then you really should search the Forum. There's numerous entries for deleting specific rows.

acsishere,

Please read forum rules below. If you wish to cross post the question on other forums feel free however we ask you always provide a link here

VBA Noob

Thanks for the given link. I read it now.

Actually I was not aware of these rules and hence cross-posted. One will do things in right way only by experience. Henceforth, I will try to stick to rules.

However, basically the intention is that to get the answer quickly. Not to violate the rules. Still, I feel sorry.

Thanks for your suggestions.

acsishere.

Maybe

Please Login or Register  to view this content.

VBA Noob