Re: $$Excel-Macros$$ Linking same format sheet

2011-10-05 Thread chhajersandeep
o not change. >> >> My object is to link blank column 2 of worksheet 2 of every sheets with a >> formula where name of the worksheet becomes variable..so that I can use a >> single formula for every sheet. >> >> Hope I can make u all understood. >> >> T

Re: $$Excel-Macros$$ Linking same format sheet

2011-10-05 Thread Sam Mathai Chacko
and for all ur co operation. > > Sandeep Chhajer. > > > Sent on my BlackBerry® from Vodafone > > -----Original Message- > From: "dguillett1" > Sender: excel-macros@googlegroups.com > Date: Wed, 5 Oct 2011 09:42:55 > To: > Reply-To: excel-mac

Re: $$Excel-Macros$$ Linking same format sheet

2011-10-05 Thread chhajersandeep
1" Sender: excel-macros@googlegroups.com Date: Wed, 5 Oct 2011 09:42:55 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Linking same format sheet I, for one, still do not understand your requirement. Perhaps attaching a file or two would be helpful. -O

Re: $$Excel-Macros$$ Linking same format sheet

2011-10-05 Thread dguillett1
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

Re: $$Excel-Macros$$ Linking same format sheet

2011-10-05 Thread chhajersandeep
Message- From: "dguillett1" Sender: excel-macros@googlegroups.com Date: Wed, 5 Oct 2011 09:03:57 To: 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

Re: $$Excel-Macros$$ Linking same format sheet

2011-10-05 Thread dguillett1
-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

$$Excel-Macros$$ Linking same format sheet

2011-10-05 Thread chhajersandeep
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 na