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.