Dear Mudassar, Find n replace is not possible as the formula is different and it cant be replaced. Also if we cut the sheet n copy to another file than the formula shown is different. we have to once again use the vlookup to the concerned pivot and than paste it to 250 locations.
thanks for the reply On Thu, Apr 16, 2009 at 3:26 PM, Mudassar Ramzan <johnplaye...@gmail.com>wrote: > Your can use find & replace option to replace formula. > > > > Thanks & regards, > > ||* **M**udassar Ramzan** *|* **MIS Officer** **|* *WorldCALL Telecom Ltd* > *|** 061- 814-3999 *|* 0321 7325277 **||* > > > > ----- Original Message ----- > *From:* Shelly Mehta <shellyme...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, April 16, 2009 1:40 PM > *Subject:* $$Excel-Macros$$ Help required ..... Thanks > > > Dear All, > > > > Pls. help/ advice on the following query: > > > > *Background: * > > I have to prepare invoices (approx 250) every month (eg. Month of Jan) > which I link with the Pivot sheet as a supporting for each month. I have > made one sheet (attached) which I copy and move to another file every month > (eq. Feb pivot details). > > > > *Query:* > > But in that case I always have to change the formula marked in yellow (in > the sheet attached) that means approx 250 times. > Is there any easy way out to replace the formula rather than making changes > 250 times. Pls. suggest in case if there is a easy way out apart from the > one i m following. > > Thanks in anticipation. > > > > > > Regards, > > Shelly Mehta > > > > > -- Regards, Shelly Mehta Chartered Accountant 9323556033 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---