Hello VBA/macro Expert group, I've attached file in which I want to add new row at the end of last used row. Using simple macro I can add blank row but I want to add pre-populated row with certain condition. Ex: *Col A:* It'll have ID# as A1 A2, A3....A10. If I use Macro, it should insert new row with pre-populated column for A as A11.[Progressive value] *Col C:* Pre-populate with existing Column C details i.e. Plan, SSn, other data *Col H:* It has drop down with validation "Pass", "Fail", "Pass with Exception". New row should have same. *Col I:* It has hyperlink with another sheet cell reference. After every 8th row in the screenshot tab, it should have hyperlink having reference of that cell. [Progressive value]
Please refer attached file for example and details. Please let me know in case you need further clarification. It looks to be little complex but I know, in this forum all of you are genius and expert of VBA and hence if you could help me with this then It'll be really great thing for us. Regards, Pankaj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Add_new_row.xlsx
Description: MS-Excel 2007 spreadsheet
