| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
| Creating Tables From Multiple Worksheets | Excel Worksheet Functions | |||
| creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) | |||
| creating multiple files from a spreadsheet | Excel Discussion (Misc queries) | |||
| Creating a Multiple Warehouse Inventory Spreadsheets | Charts and Charting in Excel | |||
Hybrid Mode
