• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to Automate Manual Formula for Adding Rows in Large Excel 2007 File

A

alcharbonneau

New Member
Hi


I have a large worksheet with revenues/expenses of organizations. Each organization is represented by an identifying number and 5 or 6 rows of data. I need all organizations to be represented by 6 rows even if one row contains 0s. I have been using =COUNTIF(B:B,B2)=6 to screen for those organizations reporting 5 rows of data. When I get a false, I insert a row with a 0 in the column for revenues and expenses. This manual process has worked well on the state level where there are 30 or so organizations. On the national level, more than 2000+ organizations, I need to automate (1) identifying those with 5 rows and (2) inserting the 6th row.


Thank you for considering/responding to this request.


Al
 
Hi, alcharbonneau!


Give a look at this file:

https://dl.dropbox.com/u/60558749/Need%20to%20Automate%20Manual%20Formula%20for%20Adding%20Rows%20in%20Large%20Excel%202007%20File%20%28for%20alcharbonneau%20at%20chandoo.org%29.xlsm


It has 3 parameters:

J1 (named range NumberOfRowsCell): rows desired (6)

L1 (named range DeleteRowsCell): Y, delete; N or other, mark

N1 (named range ConditionalFormattingCell): Y, applies CF; N or other, no


Also uses dynamic named range DataTable from A2 in advance.


Just advise if any issue.


Regards!
 
You must log in or register to reply here.
Back
Top