I, for one, still do not understand your requirement. Perhaps attaching a
file or two would be helpful.
-----Original Message-----
From: chhajersand...@gmail.com
Sent: Wednesday, October 05, 2011 9:17 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Linking same format sheet
Dear all
actually I get daily sheet from branches (they send day wise) and need to
update all my annexures (I need it to be kept for every day with the same
format) accordingly.
So please suggest any other furmula if indirect dose not work.
Sent on my BlackBerry® from Vodafone
-----Original Message-----
From: "dguillett1" <dguille...@gmail.com>
Sender: excel-macros@googlegroups.com
Date: Wed, 5 Oct 2011 09:03:57
To: <excel-macros@googlegroups.com>
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Linking same format sheet
Indirect may only be used with OPEN workbooks.
Instead, have your formula to the closed workbook and use edit/replace to
modify formulas.
-----Original Message-----
From: chhajersand...@gmail.com
Sent: Wednesday, October 05, 2011 7:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Linking same format sheet
Dear excel gurus
I need to link two work sheet with same format.
Like I have to link annexure 1 (name of a sheet) with corresponding figure
in another workbook where also the sheet named annexure 1(I have 25 sheets
with name annexure 1 to 25 and have to link all the sheets with
corresponding name sheet of another file all the format is same in both of
the workbook. Please provide with a solution)
I want to use "indirect" kind of formula so that same formula can be used
for linking all the sheets.
Thanking you in advance.
Sent on my BlackBerryŽ from Vodafone
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
