Hi,
I have received very quick responses for the queries I have placed and I am Very thankful of all of you. I am again stuck with a problem and would appreciate assistance...
I have attached a spreadsheet which contains multiple sheets.
Sheet 1, 2 & 3 are named as per agents i.e. A, B & C.
Sheet 4 is where I require the end result which is consolidated data of the three sheets.
I tried the option of multiple pivot range table but cannot get it correct.
I am all ok with formulas as well....
Thanks
Adi.
Bookmarks