There's no such thing as a stupid question, but they're the easiest to answer.


Software Development Software Development
Search Search
Search for:
Tech Support Guy > > >

Need help with excel scripting (complicated)


johnm524's Avatar
johnm524 johnm524 is offline
Member with 20 posts.
Join Date: Apr 2009
Experience: Beginner
22-Apr-2009, 05:52 PM #1
Question Need help with excel scripting (complicated)
I'm developing this tool for work and I am stuck on how to implement what I need. See Attachment

Somehow I need to be able to let people add and remove lines under each stage (B8:B14), esentially copy and insert a row and delete the row if needed.
So far I have managed to get two possible methods by modifying scripts I found on the web:
Button 1 (I8) will copy cells B2:B8 and insert wherever I have specified. The problem is I don't know how I can force it to insert the copied cells under the corresponding stage.
Button 2 (I9) will insert a row directly below the button without having to copy cells B2:B8, however it does not copy the formulas down and it also shifts the content in column J and K.
Another problem I need addressed is how to remove the inserted lines if the user needs to. What I wanted to do was add a checkbox in front of the newly inserted lines so that if selected the user could push the "Delete Checked" button in (I7) and it will delete the checked rows.
Attached Files
File Type: xls ROM_SampleFinal.xls (91.5 KB, 175 views)
foxydude's Avatar
foxydude foxydude is offline
Computer Specs
Member with 363 posts.
Join Date: Mar 2009
Location: Sydney Australia
Experience: Newbie for VBA
23-Apr-2009, 04:26 AM #2
I think you might be better pitting your request into the Businees Applications Forum. Their a lots of gurus their that will eat this for lunch
johnm524's Avatar
johnm524 johnm524 is offline
Member with 20 posts.
Join Date: Apr 2009
Experience: Beginner
23-Apr-2009, 07:40 AM #3
Mods please move to the Business Applications forum if possible
MRdNk's Avatar
MRdNk MRdNk is offline
Computer Specs
Member with 439 posts.
Join Date: Apr 2007
Location: UK
Experience: Damn I'm good!
23-Apr-2009, 05:59 PM #4
Hi Johnm 524,

Welcome to the forums.
This should really be in the Business Application section of the forums.
However, this is possible, and I'll check out the solutions tomorrow for you.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

excel, macro help, scipt, vba

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

You Are Using: Server ID
Trusted Website Back to the Top ↑