View Single Post
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default cell to adjust in another workbook when cell changes

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.