It sounds pretty basic. However, I can't open your file because I'm stuck at office 2003.
If you could repost with a .xls file, I could help.
hi everyone,
i need a VBA code for my sheet. and in that sheet i need the sum of each items year qty, i have attached a example sheet to this request. in this sheet i have three items in the first columns and there value are given in date wise columns. i need a code to add the values of each item for each year. please have a look and suggest me a code.
It sounds pretty basic. However, I can't open your file because I'm stuck at office 2003.
If you could repost with a .xls file, I could help.
Hi Dave,
i am uploading the 2003 version of the file so that you can see.
No need for VBA, a formula will do the job.
In cell B11 paste:
Copy/autofill across & down.Code:=SUMPRODUCT(--(YEAR($B$1:$H$1)=B$10),INDEX($B$2:$H$4,MATCH($A11,$A$2:$A$4,0),0))
Thanks a lot it is solving my problem.
Bookmarks