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