ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help on inserting rows and formatted content (https://www.excelbanter.com/excel-programming/363460-help-inserting-rows-formatted-content.html)

tanyhart[_2_]

Help on inserting rows and formatted content
 

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



All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com