Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Updating worksheets to my Summary in workbook

  Asked By: Mada    Date: Sep 19    Category: MS Office    Views: 782
  

I am struggling please, i need your expertise. I build a workbook
with different worksheets and include my summary. On those worksheets I
linked to my summary using formula. My big challenge is that I want to
write a macro in which will calcute many years as we wish.For example
right now I have linked only year to summary but I don't know how to
approach changing 2 or 3 years without deleting 1 year data result. My
logic is that to program in my summary or have one cell in summary if I
type 1 or 2 or 3 automatically Excel VBA will calculate column in
worksheets and update my summary according to the command. Is my logic
possible to do macro ? If so how I go by doing that since I am nebie in
ExcelVBA.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Updating worksheets to my Summary in workbook Or get search suggestion and latest updates.




Tagged: