Same Name For ranges available in
multiple tabs
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
Not the BEST solution.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shekhar Sharma
Sent: Monday, May 14, 2012 7:16 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Thanks guys, it got
]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shekhar Sharma
Sent: 14 May 2012 5:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Thanks guys, it got resolved
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma
*Sent:* 14 May 2012 5:46
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Defining Same Name For ranges available
in multiple tabs
** **
Thanks guys, it got resolved with the suggestion of
=SUMIF
-Macros$$ Defining Same Name For ranges available in multiple
tabs
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
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
: 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
-to-the-
same-cell-range-on-multiple-worksheets-HP010102346.aspx.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shekhar Sharma
Sent: Friday, May 11, 2012 2:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Defining Same Name
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Friday, May 11, 2012 8:18 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Hi Shekhar,
You can use:
=SUMIF(sheet1!WBS,A1,sheet1