Results 1 to 10 of 10

Thread: Problem inserting new worksheet in Excel daily time tracker w/ date format (at specific location in book)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Junior Member
    Join Date
    Aug 2020
    Posts
    5
    Rep Power
    0
    That's working but I want the new tab to be at the front - pushing older tabs to right. I tried changing the copy line from After to Before, but that only works once. I've attached a sample workbook; green tabs would be created by the macro (produced manually in this case). Yellow tabs indicate starting point for the file. Should look like this:
    time tracker.PNG
    Also, w/in the work book module1 - test sub is some of the code that should be used to append a pivot table to the new sheet.
    HTH

    p.s., cross posted on ExcelForum, answers.microsoft and MrExcel ... little traction there.

    Thanks!
    Attached Files Attached Files

Similar Threads

  1. Extract Time in 24H format from Date and time.
    By zorro in forum Excel Help
    Replies: 3
    Last Post: 09-01-2016, 07:20 PM
  2. Replies: 7
    Last Post: 08-25-2016, 04:14 PM
  3. inserting date
    By CORAL in forum Excel Help
    Replies: 5
    Last Post: 08-05-2014, 02:22 AM
  4. Inserting time in spreadsheet
    By papabill in forum Excel Help
    Replies: 17
    Last Post: 10-25-2013, 01:34 PM
  5. work book format
    By Prabhu in forum Excel Help
    Replies: 1
    Last Post: 03-25-2012, 10:33 PM

Posting Permissions

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