+ Reply to Thread
Results 1 to 2 of 2

EXCEL -- Button for new row relative to button location

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    na
    MS-Off Ver
    EXCEL 365
    Posts
    1

    EXCEL -- Button for new row relative to button location

    I have the following:
    - excel sheet with data, limited set, to be used as a "Form"
    - there are 5 timeframes i want to seperate the data by
    -i want to include a button that is set in a cell, and accomplishes the following function in relation to its location: click button (f9), insert new row below, copy and paste a-e format from hidden cells.


    i have it working for the 1st set, but the lower buttons do not take into account the rows added.

    thanks
    cp

  2. #2
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Re: EXCEL -- Button for new row relative to button location

    Can you upload a sterile sample spreadsheet of what you have and what you are looking for?
    I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!



    Please mark your threads as Solved once it is solved. Check the FAQ's to see how.

+ 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] Copy Paste Macro Relative to Button Location
    By Lacaycer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-21-2017, 01:21 PM
  2. Inserting Row Macro using Command Button (ActiveX) relative to Button
    By mebailey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2016, 09:17 PM
  3. Macro to calculate columns relative to button location
    By Fullalove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2015, 12:48 PM
  4. create macro relative to button location
    By edgonzo101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 03:17 PM
  5. [SOLVED] Excel Command Button: Location hopping using row number.
    By Ataraxicatom in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-18-2012, 03:46 AM
  6. Insert an icon relative to the button location
    By Armidion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2009, 10:04 AM
  7. Recording new excel macro, relative reference button doesn't show
    By Dano in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-23-2005, 03:05 PM

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