final pivot table mg metals globals positions data dear please see attached spreadsheet think way automate position update right manual process convert text file andreas sends us proper spreadsheet format pivot table results takes 20 minutes however note version la var model links via vlookup spreadsheet attached know use vlookup mg necessarily positions forward months whilst pivot table produces numbers forward months position regards anjam x 35383 positions 19 th july forwarded anjam ahmad lon ect 25 07 2000 20 41 enron europe anjam ahmad 25 07 2000 19 17 cantekin dincerler hou ect ect cc tanya tamarchenko hou ect ect kirstee hewitt lon ect ect grant masson hou ect ect andreas barschkis mgusa com enron subject positions data pivot table noticed copper position 19 th july option included reported mercur guess include 5 248 tonnes copper option 2000 09 show gamma forwarded anjam ahmad lon ect 25 07 2000 19 18 enron europe anjam ahmad 25 07 2000 19 14 tanya tamarchenko hou ect ect cc cantekin dincerler hou ect ect andreas barschkis mgusa com enron subject positions data hi tanya using data 19 th july andreas see file attached using reconcile mercur print got andreas last wednesday mind perhaps cantekin try new sheet attached already looked would like see cantekin come independently think positions changed lot 3 rd july data 19 th july thanks anjam kirstee