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

   End If     Next R     Sheets(SheetRep).Select End Sub Paul From: Deepak Rawat To: excel-macros@googlegroups.com Sent: Fri, July 2, 2010 6:14:50 AM Subject: $$Excel-Macros$$ Require Froumula for change data in some other format Hi Friends I have attached a file, there are two sheets

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

Hi Friends I have attached a file, there are two sheets 1st is the raw data and 2nd sheet has final data. actually i have a large number of data to work on. is there any formula or simple technique to do the same in quickly. Deepak Rawat -- --