Worksheets

J

JUDY DEFEO

I keep a workbook of weekly expenses per employee for about 5
employees. The workbook consists of a sheet for each week plus
monthly total. I also keep a sperate workbook which contains on
worksheet with all the months totals and the year to date. 13 column
in all. If the employees keep changing, what is the best way t
automatically get the data from the monthly spreadsheet to the YT
spreadsheet? I need to keep the data for the old employees as well a
the new employees
 
S

Steve

How about a single sheet with a row for each employee and a column for
each week. Then you could use the sorting and subtotaling functions to
produce all the per employee, per week, per month and YTD data you
might need. Each employee row could have a column for active or
inactive and the former employees could be sorted out or moved to a
different sheet at the appropriate time.

There are some slick things you can do with subtotals to convert them
to values (versus formulas) and keep them permanently.
 
D

Dave Peterson

Just my opinion....

I would think that the best thing to do would be to put all your data in one
worksheet--add a column that can be used to indicate what week that entry is in.

Then you could use data|pivottable and group the expenses by month.

I've always found it easier to keep the data in one spot and if really, really
necessary split it up (for reporting purposes only--no inputs allowed on those
report sheets).
 
K

Ken Wright

I'll second Dave's suggestion, and it's pretty much the only solution i'd
consider if i was doing it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top