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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to