Recreate the same function, just like the MS Excel Template
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:
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!
Last edited by ebase02; 08-25-2017 at 09:37 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By mjd128 in forum Excel Formulas & Functions
Last Post: 04-19-2014, 05:33 AM
By henpen in forum Excel - New Users/Basics
Last Post: 07-31-2013, 09:19 PM
By skyline255 in forum Excel Formulas & Functions
Last Post: 06-28-2013, 12:54 AM
By bermandl in forum Excel Charting & Pivots
Last Post: 11-14-2011, 07:05 AM
By MSCraven in forum Excel Formulas & Functions
Last Post: 08-12-2006, 10:50 PM
By R P Kief in forum Excel General
Last Post: 03-27-2006, 11:20 PM
By rjamison in forum Excel Programming / VBA / Macros
Last Post: 06-13-2005, 08:05 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1