Re: $$Excel-Macros$$ Require Froumula for change data in some other format

Thanks Paul!! Its working absolutely fine. is there any formula to perfome the same. Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

Re: $$Excel-Macros$$ Require Froumula for change data in some other format

this macro seems to handle it: Sub ReFormat_Data()     Dim LastRow, LastCol, R, C, RepRow     Dim SheetRaw, SheetRep     Dim Mgr_Name, Mgr_ID, City         SheetRaw = "Raw Data"     SheetRep = "Required Data"         Sheets(SheetRep).Range("A2:Z65000").ClearContents         Sheets(SheetRaw).Sel