Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-14 Thread Shekhar Sharma
> > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *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-Mac

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-14 Thread Rajan_Verma
[IM-Gtalk] 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 with

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-14 Thread dguillett1
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

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-14 Thread Shekhar Sharma
> a macro. Provide a file and your desires. > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Shekhar Sharma > *Sent:* Friday, May 11, 2012 4:59 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-12 Thread dguillett1
-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 (separa

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-11 Thread Asa Rossoff
a From: excel-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(

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-11 Thread Asa Rossoff
a-3-d-reference-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$$ Definin

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-11 Thread Rajan_Verma
ps.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. -

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-11 Thread NOORAIN ANSARI
Dear Shekhar, Please share your workbook with group, It is possible through Indirect Function. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, May 11, 2012 at 3:29 PM, Shekhar Sharma wrote: > I'm wondering if it's possible to define one name

$$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

2012-05-11 Thread Shekhar Sharma
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