ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating Multiple Entrys (https://www.excelbanter.com/excel-worksheet-functions/101937-creating-multiple-entrys.html)

DarklyCute1

Creating Multiple Entrys
 

Not really sure how to name this one - but here's an explination about
what I'm trying to do. I'm working on creating an employee absence
tracker and I'm nearly finished but I didn't take into acount for neww
hires or retired/fired people. The workbook consists of a year to date
kind of thing followed by the months of the year.
Is there a way to add boxes (10 rows X 14 columns = ytd ; 10 rows X 6
columns = monthly) for the new people and subtract boxes for the old
ones leaving without messing with the values of others (this is in
alpha order)
Also, Is there a way to correspond the boxes, when one gets added in
the ytd it's automatically added to the other sheets (all months).
Sorry if this seems confusing, I can answer any qs.
Thanks,
Darkly


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=565969



All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com