If I am developing a template for my boss to input information, is there a way that an additional row could be inserted after she enters information into a cell?
Thanks.
If I am developing a template for my boss to input information, is there a way that an additional row could be inserted after she enters information into a cell?
Thanks.
Hello Saintr,
Copy the code below using CTRL+C. Right click the Worksheet tab you want to place the macro in. Click "View Code" on the popup menu, and Paste the code in using CTRL+V. Save the changes using CTRL+S. This is set to isert a new row if you change any cell in column "A". You can change the column by changing the letter in red to what you want.
Sincerely,![]()
Please Login or Register to view this content.
Leith Ross
Last edited by Leith Ross; 05-09-2007 at 05:39 PM.
I just tried this code, because I need it too, especially if specific text is entered in the cell (not just a change).
code only added extra cells, not the whole row, and kept doing it till it eventually crashed.
how do i:
when "FD" or "STD" is chosen from the dropdown list in, say, L26, instead of changing entry in L26, it inserts a row below it (row 27), copies all the formatting (but only the formatting) from the row above or below or whatever, & inserts "FD" or "STD" into the new row (in L27).
so sorry to piggyback on your original enquiry, saintr, terrible manners, but I was getting around to asking anyway...![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks