Have you considered using a filter, then you would only have
to maintain a single worksheet.
http://www.contextures.com/tiptech.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"kat2005" wrote ...
I have an input worksheet that totals to a category. I then have a seperate <separate
worksheet for each category according to Month and Year. I want the value of
the category from the input worksheet to go the proper cell in its Month and
Year. I know how to get the values there but I want it to adjust each time I
change the input cell. Ditto between different workbooks.