Results 1 to 8 of 8

copy to SumSheet, Save new tab, save as Pdf

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    copy to SumSheet, Save new tab, save as Pdf

    Hi there Gurus.

    I made an excel sheet and was hoping to have one button to do all I need - where I have like 4 Buttons. (Going on Maternity soon and replacement does not know a lot about excel)

    What is to happen in the Spreadsheet:

    Person fill in only on the SUMMARY PRINT SHEET (grey is Formulated; Green is where they may Tipe)
    After filling in They must press "THE BUTTON" to do the following:

    Selected Cells to be copied to the Summary sheet (See yellow cells in Summary sheet - Where the Data must go)
    Then The SUMMARY PRINT SHEET must be saved to a new Tab (Like in Example), with the Date (D3) as the name of Tab
    THEN the page is to be SAVED AS PDF (Person who will use this is not Excel skilled)

    Then lastly, wil press the Clear sheet Button to clear the GREEN areas for the next entry.

    I would rather have on button than 4 to help this person do my job

    Thanks alot
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-29-2016, 11:55 AM
  2. Macro to Auto save a backup copy in a seperate location OR save file with a pop up
    By kdsanderson30 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2014, 12:38 PM
  3. [SOLVED] Make another copy and save in diffrent path when i apply save
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2014, 09:00 AM
  4. Replies: 1
    Last Post: 09-05-2013, 02:39 PM
  5. Save copy as, open copy, alter copy, save copy and close copy
    By tradinup2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2013, 04:42 PM
  6. Disable Save As and Save - enable Save via button
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-07-2011, 05:42 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