Is there a function/formula in excel 2007 that can be used to automatically add rows?
I have a table set up that has 12 rows. Once data is entered into row 11, I need for the table to start expanding by adding one row above the last row in the table (e.g. initially row 12). The intent is to always have two data free rows at the bottom of the table. There is a formated row counter in column A that needs to self populate, but other than that the new line should be blank.
Thanks, RT
Hi rtinallentx
Use tables on the insert tab.
Using Tables
Hi Kevin,
Thanks for the reply. Unfortunately, I didn't see anything on the insert/tables tab or on the link that will help with what I'm wanting to do. I already have the table set up; I just need to figure out how to get it to add additional rows once all the empty rows are used.
I guess what I'm looking for is something like this:
In cell A29 =IF(COUNTBLANK(C28:J28)<8,add row above A29)
I just don't know what the function would be for "add row above A29" (if there is one)? There is also a formula in A28 that would need to copy as well.
Last edited by rtinallentx; 12-11-2012 at 02:49 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks