I have a PR spreadsheet with 12 worksheets labeled by month - i have
names and salary amount for each month separate. Presently there are
only 35 employees. In July we had about 60, Aug 50 Sept 40 Oct till end
of June we will have 35 permanent employees . For labor negatation
purposes, management wants to work on figures involving the current 35
employees. I would like to create a "summary" worksheet that selects
names that appear on the three worksheets in one column and next column
either by month or the total YTD paid for the selcted employee.The extra
help are seasonal while we operate with 35 employees. By way of example:
worksheet July in col A has names, in B has amounts, the same format for
all consecutive months. Our fiscal year is July to June. Does any one
know an easy way to do this? Thanks in advance




--
ab3d4u