1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Need help with excel scripting (complicated)

Discussion in 'Software Development' started by johnm524, Apr 22, 2009.

Thread Status:
Not open for further replies.
Advertisement
  1. johnm524

    johnm524 Thread Starter

    Joined:
    Apr 22, 2009
    Messages:
    20
    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:

  2. foxydude

    foxydude

    Joined:
    Mar 24, 2009
    Messages:
    363
    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
     
  3. johnm524

    johnm524 Thread Starter

    Joined:
    Apr 22, 2009
    Messages:
    20
    Mods please move to the Business Applications forum if possible
     
  4. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    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
As Seen On...

Welcome to Tech Support Guy!

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.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/821024