I've posted this on another board - got lots of views but no responses
so I'm hoping Santa will be good to me and someone reading this thread
will have an answer.
We have 100+ employees. We need to track PTO, Vacation in hours and
then also log other instances of time away from work (f= fmla,
t=travel, c=comp time, h=work at home). However these "other
instances" do not need to be tracked in terms of hours used.
The only suggestion that came on the other board was to have 3 rows per
employee - not a good solution.
My solution so far has been to have 3 columns for each day but this is
causing me to run out of columns before I get to April.
I thought I could use SUMIF but apparently I'm wrong. Why can't I put
something like "8v" (indicating 8 hours of vacation used) and then have
my totals column look at the range and sum if it says 8v, the column
next to this would sum if it said 8p.
Any help would be appreciated.
Donna123's Profile: http://www.excelforum.com/member.php...o&userid=26962
View this thread: http://www.excelforum.com/showthread...hreadid=495940
1. Attendance Tracker Automation in Excel
2. Excel as Attendance Tracker
3. Attendance Tracker
4. Attendance Tracker
5. Need help setting up an Attendance Tracker
6. Excel as a Front End To an Access Database (without access)
7. Using Excel as a database
8. HYPERLINK another Excel as READONLY?
9. How to Import Visio Text Boxes into Excel as Text
10. using excel as a job tracking tool---help!
11. Publishing the excel as web page
12. Open Excel as an Application from Internet Explorer
13. Using Excel as a platform to chat with someone through inter
14. Removing spaces from SAP report exported to Excel as HTML
15. Excel as a product configurator
16. Using Excel as a Gradebook:Calculating sum excluding blanks and ze
17. How do I run Excel as a service?
18. Building an Attendance Tracker
19. Using Excel as a gradebook with ability to drop lowest grade
Im very new to the VBA coding & Macros, I need a favour from You hope i will get help
I have an Excel sheet named as Attendance Tracker in which i maintain attendance of employees.
seniors are asking me to automate the same & their requirements are -
we will create seperate sheets for all the team leadersEach team lead should access only their team sheet and should not have
access to other sheetsWe should have consolidated sheet where in all team leads data has to be consolidated.consolidated
sheet should be accessible only from managers.
I've posted this on another board - got lots of views but no responses so I'm hoping
Santa will be good to me and someone reading this thread will have an answer.
We have 100+ employees. We need to
track PTO, Vacation in hours and then also log other instances of time away from work (f= fmla, t=travel, c=comp time, h=work
at home). However these "other instances" do not need to be tracked in terms of hours used.
suggestion that came on the other board was to have 3 rows per employee - not a good solution.
My solution so far
has been to have 3 columns for each day but this is causing me to run out of columns before I get to April.
thought I could use SUMIF but apparently I'm wrong. Why can't I put something like "8v" (indicating 8 hours of
vacation used) and then have my totals column look at the range and sum if it says 8v, the column next to this would sum if
it said 8p.
I have been tasked with coming up with an attendance tracker at work. I have been messing with it for
a while now and I have been surfing the web for answers. I have found a lot of things that are similar, but I can't quite
adapt them to what I want to do.
So, we award 1/3 of a point for a tardy and 1 point for an absence.
The Tardy/Absence criteria will pull from another spreadsheet.
I used a countif to determine the number of
points based on Tardy/Absent.
I am now trying to create a rolling 90 day total and a rolling 365 day total. So I
will pull up the file, add a new column that will pull the previous day's Absences/Tardies and then have my 90/365 day period
update to reflect the new date.
I have been messing around with OFFSET and EDATE, which are new to me. If anyone
can help me come up with a formula to figure this out, I would be ecstatic! It would be even better if you could explain how
it was done as well so I can learn. Thanks!
I have attached here an attendance tracker that I maintain.
Now using Pivot Table I want to pull data in regards
to information for each employee. I need to know the no of leaves he has taken in a particular month as well as on a total
Also I need to know how many morning/afternoon shifts they worked in a month as well as on a total basis.
Hi all, I created a workbook that uses VBA userforms to add and retrieve and edit records from a worksheet. This works great
when it isn't shared, but causes too many save conflicts when 5 or 6 people are using it at the same time. I have seen in
other posts some references to using excel as a front end to an access database even if you do not have access installed. Can
anyone point me in the right direction with this, any tutorials, links articles etc will be very welcome... thanks
I am working off a document created by someone else in Visio. They have
create a 'spreadsheet' using lines and individual text boxes. I want to
import/copy this text from visio(ideally keeping the formatting, but not
essential) and paste it into Excel cells.
If I select one text box from visio and copy and paste it into excel, it
pastes the text into a cell as text (which is what I want). However, If I
select multiple text boxes it will paste this into excel as an image. I have
tried paste special but this only gives me different image types to paste it
Can anyone assist or point me in the right direction.
Our office is using excel as a publications job tracking tool (I know, WHY?!...but I'm just the messenger! ). I have a
workbook that has two active worksheets - the annual calendar on a week-to-week basis and an annual calendar on a day-to-day
basis. The primary worksheet is the week-to-week calendar. The dates are in a header row in the day/month format.
Each job is listed in a vertical column with four rows associated with each (representing the person responsible for a
specific portion of the process).
Here's what I would like to do:
When the week-to-week information is
updated, I would like to have the day-to-day range for that particular week be automatically updated. The information that
needs to be mirrored is a text block (person's first name) and cell color.
Does anyone know what formula, or code
snippet I should use for this?
I am trying to save an excel sheet as a web page. But I am facing with the following problem:
The excel sheet when originally prepared,was compressed in size from 100% to 55% and images were pasted on it. Now when I
save this excel as a webpage, it saves as 100% making it really big causing a horizontal scroll bar in the web page. This
makes it very difficult to read and understand.
Is there a way to maintain the same size percentage and show it as
it is on the web page also. That is save the excel sheet as a webpage keeping it at 55% ?
Your help will be highly
I have a report exported from SAP, saved as an HTML file. I parsed the file by Data - Text to columns, using "Fixed Width".
Each column now has blank spaces where the data string ends. For example, I have a string of numbers in a cell
9-9999-99 that now has 16 additional spaces at the end. (9-9999-99bbbbbbbbbbbbbbbb where b = blank space) I can backspace
the blanks out, but it's not practical for 1000 lines in a report.
When I try to Edit - Replace the space with
nothing, I get a message that Excel cannot find the space. I have look to see that nothing is checked in Match Case and
Match entire cell contents, have tried Search by Rows and by Columns, and tried Look in Formulas and Values.
work around I found was to paste this column of data into a Word document as unformatted text, the paste it back into Excel
as text. I can then do Edit - Replace to remove the space.
I have many of these reports to format, so if someone
knows of a way to remove the spaces without moving the data to Word first, it would be extremely helpful.
I have created and have been maintaining an Excel based configuration tool for almost 2 years now. Am self-taught with Excel
as it helps with my IT sales job quite a bit. Response from my customers is overwhelmingly positive. Its been nothing short
of astonishing. Response from anyone in management on the opther hand, is either indifferent or fearful/ignorant. They seem
to see only risk, not opportunity. Will not let me take my ideas any further in their org.
I think I've found a
large void that needs to be filled in my industry but unsure of what to do next. Can't seem to find much in the way of
existing career paths for Excel based product config tools.
Are there any? I have no formal programming background
of any kind, just a lot of 'learn as I go'. But I think that's the beauty of it. Did not seem too difficult to go from zero
knowledge to where I am now.
I am attempting to use Excel as a gradebook and I would like to total the
values of a series of columns where the values are not blank and are greater
Should I test each value in a range for blank or >0?
If so, how would I go about doing that?
I have basic programming skills based out of Java (very elementary), and
would like to understand what I am doing. So if you reply, could you please
I need Help! The only way I can think to do this is create a separate
worksheet for each employee which we will interact with on a daily basis.
I'm struggling because I want to have a worksheet that collects all of the
data from each employees worksheet and puts it all together in one view. I
would love some suggestions on how to do it or on how I should design this
Attendance Tracker. FYI there are about 550 employees.
I use Excel as my gradebook using separate worksheets for subcategory. In the
test worksheet, I would like to be able to, for each student, drop the lowest
test grade. This may be a different test for each student.