Hi
If you are talking about
Union(Sheet1.Range("A1:A10"),Sheet2.Range("A1:10")).Name="RngMyRange"
Then
It's not possible I think
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 11 May 2012 3:45
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Dear Shekhar,
Please share your workbook with group, It is possible through Indirect
Function.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
<http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com
On Fri, May 11, 2012 at 3:29 PM, Shekhar Sharma <shekhar1...@gmail.com>
wrote:
I'm wondering if it's possible to define one name for columns in multiple
worksheet. Basically I'm working on an estimating spreadsheet with multiple
sheets; each sheet contains hundreds of individual costs (separate lines)
which are categorized into more generic numerical buckets. So each line has
a column for the generic buck and the cost. I'd like to have a summary sheet
with a column summarizing these numerical buckets and the total cost for
each bucket which is added from each sheet.
Let's say the generic bucket column in each tab is called WBS, and the cost
column is called COST. In my summary tab, I'd like a formula such as
=SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I
can solve this?
--
Shekhar Sharma
"Life consists not in holding good cards but in playing
those you hold well"
"Before you judge another, think of your own last mistake."
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
