+ Reply to Thread
Results 1 to 2 of 2

Adding a button next to a row as it is added to a sheet

  1. #1
    Registered User
    Join Date
    12-18-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    30

    Adding a button next to a row as it is added to a sheet

    My company uses excel to write up service reports for our customers on a call by call basis. Each ticket has a specific number that is generated. When the ticket is completed, I have the program open up a log sheet and add the customers information to a list for easy referencing.

    It has been requested that I make a button or a command of some kind they can click on and export certain cells in that row to a time sheet so they do not have to fill it out manually every week. I am confident I can to the exporting portion of it but is there a way to add some kind of command to each line they can click on to make this happen? It would have to be specific to the row it is in and be added to every line.

    I do not let my techs access the original log sheet but I have a second sheet that when opened it imports the sheet to there workbook. I have attached examples of the forms I am using.

    Thank you.

    Max
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Adding a button next to a row as it is added to a sheet

    I am looking at the ticket log. How do I know that Max is working any of these jobs? Or is the entire log Max's log? also the data does not seem to match. On the log, somebody works Project Number PO12347 but the time sheet shows PO12346.

    I could see a better way of doing this. Pull the time from the log to the time sheet. Use a button on the time sheet to open the log and find all the entries for a date range and pull them in.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Automatically add button when data added to cell and apply macro to button?
    By dori2o in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2016, 11:56 AM
  2. Replies: 0
    Last Post: 03-23-2015, 12:12 PM
  3. Adding new Sheet added to workbook to exisiting Chart
    By jennyblack9 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-17-2014, 09:59 AM
  4. Adding Rows to one sheet when Data is added to the first one
    By Phoebus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2014, 07:39 AM
  5. Adding celldata in other sheet with button
    By roelof bakker in forum Excel General
    Replies: 1
    Last Post: 04-13-2014, 03:32 PM
  6. Adding a button into a sheet
    By ste_mulv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2009, 01:57 PM
  7. Adding hyperlink to last added sheet
    By Mr.G. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2009, 02:47 AM

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