If you dont have to make any changes you paste special the file before
you move it from main file

Regards
Santosh Bahuguna

On 4/16/09, Mudassar Ramzan <johnplaye...@gmail.com> wrote:
> Your can use find & replace option to replace formula.
>
>
> Thanks & regards,
>
> || Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 |
> 0321 7325277 ||
>
>
>
>   ----- Original Message -----
>   From: Shelly Mehta
>   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
>
>
>
>
>
>
>
> >
>

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