+ Reply to Thread
Results 1 to 1 of 1

Recreate the same function, just like the MS Excel Template

  1. #1
    Registered User
    Join Date
    04-28-2017
    Location
    Irvine
    MS-Off Ver
    2016
    Posts
    13

    Recreate the same function, just like the MS Excel Template

    Hello everyone,

    Thank you for your visit. I need your guide to recreate the same function of the existing Ms Excel template called "Employee Attendance Tracker" that will be imported to Google Excel.

    I imported the file to a Google Excel, but due to the fact that they do not really sync together, some of the features are literally missing. I already fixed the name ranges, and I am currently missing some vital features that I really need.

    - Make the excess dates disappear. For some reason, even though the formula is already written in the imported Google Excel File, the dates are still present which is a bit out of place as they do not match the calendar. In the attached file, only the correct dates are shown in each year, while on the Google Excel File everything is shown.

    I was trying to make it disappear as well but to no afford, I really can't duplicate the same feature to Google Excel File.

    - Color markup, in the attached file versus the Google Excel File. The dates written in the Employee Leave Tracker sheet tab, are color marked up in the Calendar View in the attached file. While in the Google Excel File, it is not even showing what are the dates similar to the tab.

    This is the link for the Google Sheet:
    https://docs.google.com/spreadsheets...gid=1443273952
    While the attached file is the actual template, generated from a MS Excel Template called Employee attendance tracker.

    Thank you for reading.

    Have a great day!
    Attached Files Attached Files
    Last edited by ebase02; 08-25-2017 at 09:37 PM.

+ 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. Replies: 12
    Last Post: 04-19-2014, 05:33 AM
  2. Want to recreate "Monthly Meal Planner" template
    By henpen in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-31-2013, 09:19 PM
  3. Recreate Gantt Chart logic used in Microsoft Project in EXCEL
    By skyline255 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2013, 12:54 AM
  4. How to recreate this chart in excel?
    By bermandl in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-14-2011, 07:05 AM
  5. Need set up template/function in Excel to gather survey answers
    By MSCraven in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-12-2006, 10:50 PM
  6. Replies: 1
    Last Post: 03-27-2006, 11:20 PM
  7. [SOLVED] Recreate AutoScroll
    By rjamison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2005, 08: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