Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am editing a spreadsheet that is used to create an estimate for completion of work. Under each separate job type there are a list of tasks that need to be charged (such as travel, cleanup, installation, etc) and most of the time there is a list of 12 tasks. What I need to do is create a macro that would allow the user to add another task to the master list and have it keep the same formatting and formulas that the previous lines had. Each task consists of three rows and I would like to be able to copy all three rows and insert them whenever the user would like to. Hopefully this is easy to understand, if not, I can try to clarify. I would appreciate any help on this, I am new to VBA and am trying very hard to learn. -- tanyhart ------------------------------------------------------------------------ tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148 View this thread: http://www.excelforum.com/showthread...hreadid=549079 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting rows inbetween rows of data ? | Excel Discussion (Misc queries) | |||
inserting a hyperlink into a conditionally formatted cell, Excel 2 | Excel Discussion (Misc queries) | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
Inserting multiple rows in excel with data in consecutive rows | Excel Programming | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions |