Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-25 Thread Paul Schreiner
24, 2013 7:59:30 AM Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet I THINK I understand what you're trying to say... You have a workbook with sheets named for each DAY of the month. You want to SPECIFY a range to sum the values for those days (from

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-24 Thread Paul Schreiner
-- --- From: Rajesh thrissur rajeshka...@gmail.com To: excel-macros excel-...@googlegroups.com Sent: Tue, January 22, 2013 7:36:40 AM Subject: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet Hi Experts

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-24 Thread Paul Schreiner
@googlegroups.com Sent: Thu, January 24, 2013 7:59:30 AM Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet I THINK I understand what you're trying to say... You have a workbook with sheets named for each DAY of the month. You want to SPECIFY a range to sum

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-23 Thread kasper
22, 2013 8:13:42 AM *Subject:* Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet Hi Paul Thanks for the idea you gave. Is there any way to add date criteria also there eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13. With regards and thanks Rajesh kainikkara

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-23 Thread Bé Trần Văn
Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet Hi Paul Date is in the consolidation page there i give it under the heading from 01/01/13 to 05/01/13 Regards Rajesh kainikkara On Tuesday, January 22, 2013 7:03:13 PM UTC+5:30, Paul Schreiner wrote: how

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-23 Thread Rajesh thrissur
: Tue, January 22, 2013 8:13:42 AM Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet Hi Paul Thanks for the idea you gave. Is there any way to add date criteria also there eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13. With regards and thanks Rajesh

$$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-22 Thread Rajesh thrissur
Hi Experts, Is there any method to consolidate data from many worksheets to one master worksheet, here I attached a simple work book it have only 5 data sheets and 1 master sheet. being data is very less I solve it with just adding data from reference cells but when data is more this method is

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-22 Thread Paul Schreiner
- From: Rajesh thrissur rajeshkainikk...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Tue, January 22, 2013 7:36:40 AM Subject: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet Hi Experts, Is there any method

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-22 Thread kasper
*- -- *From:* Rajesh thrissur rajeshka...@gmail.com javascript: *To:* excel-macros excel-...@googlegroups.com javascript: *Sent:* Tue, January 22, 2013 7:36:40 AM *Subject:* $$Excel-Macros$$ Consolidate data from 31 sheets

Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet

2013-01-22 Thread Paul Schreiner
To: excel-macros@googlegroups.com Sent: Tue, January 22, 2013 8:13:42 AM Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master sheet Hi Paul Thanks for the idea you gave. Is there any way to add date criteria also there eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13