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 wrote:
> Your can use find & replace option to replace formula.
>
>
> Thanks & regards,
>
> || Mudassar Ramzan | MIS Officer | WorldCALL Telecom
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 r