+ Reply to Thread
Results 1 to 3 of 3

Programmed button to copy certain rows

  1. #1
    Registered User
    Join Date
    06-16-2022
    Location
    Poland
    MS-Off Ver
    2019
    Posts
    18

    Programmed button to copy certain rows

    Hello guys

    In my sheet formulas for interpolating some charts are working smooth and nice but i want to change an input based on a model of pump. Because simple index doesn't work well because after using formula in cell it is no longer empty and excel is trying to aprox. some strange values. I thought about vba and programmable button for copying certain rows just by pressing it.

    The model of the pump is stored in row 2 column B, and the input values are in row 20 column C:BA, and my goal is to either change that input row by changing model in B2 alone or changing B2 + pressing the button - it depends what is easier because I never used VBA and that will be my first time. All informations will be stored in catalog in each row containing 2 pictures (some are simple icons to reduce size), model, company and input value. Also the range for search should be as long as it is possible because i do not know how many pumps i will have inside sheet.

    Thank you for your help!

    ASDG
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Programmed button to copy certain rows

    You don't really need a separate button - just use the Sheet Change event for the cell containing the Data validation list...

    (Watch out for the '99' in 1 row. Just there to confirm all necessary columns are copied).

    Edited. A dynamic named range has been added so the data validation will only show items that exist in Col C (No blank rows in the DV list) and it will automatically adjust as items are added or deleted.
    Attached Files Attached Files
    Last edited by cytop; 06-17-2022 at 03:32 AM.

  3. #3
    Registered User
    Join Date
    06-16-2022
    Location
    Poland
    MS-Off Ver
    2019
    Posts
    18

    Re: Programmed button to copy certain rows

    Thank you very much! It works flawless. Tbh i have no idea what you've done, i need to sit and learn some VBA to speed up my work.

    Again, than you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Add dynamic button to copy rows VBA MACRO
    By AhmedGRE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2018, 11:53 AM
  2. Button that will copy cell to different workbook into rows with same ID
    By michaljireht in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-04-2014, 10:01 PM
  3. Insert rows (and copy formulas) using command button
    By roseme in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2014, 01:42 PM
  4. Copy button macros to rows below
    By pdale18 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2013, 08:29 PM
  5. [SOLVED] Copy and paste set of rows repeatedly at click of button
    By RoxanaN in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2013, 02:30 AM
  6. Macro for button - copy and paste rows
    By cbrd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 04:29 PM
  7. copy 45 rows down, repetativly, only on button click?
    By foxgguy2005 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1