gt; dguille...@gmail.com
>> -Original Message- From: debasish
>> Sent: Sunday, December 04, 2011 11:38 PM
>> To: MS EXCEL AND VBA MACROS
>> Subject: Re: $$Excel-Macros$$ update link automatically in excel sheet
>>
>>
>> Thanks for the reply.
>>
A MACROS
> Subject: Re: $$Excel-Macros$$ update link automatically in excel sheet
>
>
> Thanks for the reply.
> But i have multiple no. of cells which needs to be updated from
> separate cells of source file (file to which links are made).
> So I have to click 100 times for browsing to
Haven't followed this but have you tried
edit/replace
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: debasish
Sent: Sunday, December 04, 2011 11:38 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ update link automatically in excel
Thanks for the reply.
But i have multiple no. of cells which needs to be updated from
separate cells of source file (file to which links are made).
So I have to click 100 times for browsing to the file. It takes hail
lot of time. (same result even I use Ctrl+H).
I need a solution by which I dont h
Hi Debasish,
Also try Find and Replace option.
*Select the cells > Ctr+H *
[image: find replace.jpg]
Regards,
MARIES.
+971559828492
On Sat, Dec 3, 2011 at 2:43 PM, Sam Mathai Chacko wrote:
> The edit links feature in Excel is specifically given for this. YOu just
> need to browse for the
The edit links feature in Excel is specifically given for this. YOu just
need to browse for the new file, and OK it. Did you try that?
Regards,
Sam Mathai Chacko
On Sat, Dec 3, 2011 at 12:20 PM, debasish wrote:
> Hi,
> I maintain my monthly production figure in a excel file.The file is
> maint
Hi,
I maintain my monthly production figure in a excel file.The file is
maintained for each Financial year.
In one of the sheet I keep values for different months by giving links
to values present in other sheets from same files & some values from
other excel file.
Now I want to make new file for