I don't have any worksheet readily available with me now.
But I am trying to explain it with example:
I have a worksheet 1 with below mentioned sheets:
Annex 1
Annex 2
And so on...
I have anothe sheet say worksheet 2 with same name sheets viZ
Annex 1
Annex 2
And so on...
Now in annex 1 of worksheet 1 I have data as below:
Column 1. Column 2
Row 1 Fixed assets. 25000
Row 2 Investment. 50000
And so on
In annex 2 I have data as below
Column 1. Column 2
Row 1 direct income 25000
Row 2 direct expenses 50000
And so on...
Now in annex 1 of worksheet 2 I have data as below:
Column 1. Column 2
Row 1 Fixed assets.
Row 2 Investment.
And so on
In annex 2 I have data as below
Column 1. Column 2
Row 1 direct income
Row 2 direct expenses
And so on...for all annexure
Column 3,4 and towards right side all sheets (name of the sheets are annexure
1,2 and so on) of worksheet 2 contains old linked data which I required and do
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.
Thanks for taking pain and for all ur co operation.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-----Original Message-----
From: "dguillett1" <dguille...@gmail.com>
Sender: excel-macros@googlegroups.com
Date: Wed, 5 Oct 2011 09:42:55
To: <excel-macros@googlegroups.com>
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.
-----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
--
----------------------------------------------------------------------------------
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
