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