RE: $$Excel-Macros$$ Query for Code

2015-08-12 Thread gargee singh
-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query for Code Also, based on your statement:"in the summary sheet we want to see total of all centres based on the month of selection which is a respective start date" implies that, if you have 30 centres:let's say 10 started in May

Re: $$Excel-Macros$$ Query for Code

2015-07-28 Thread Paul Schreiner
can, As long as ever you can.” - John Wesley - From: gargee singh To: "excel-macros@googlegroups.com" Sent: Tuesday, July 28, 2015 1:05 AM Subject: RE: $$Excel-Macros$$ Query for Code Dear Paul, Good morning and Thank you for the repl

Re: $$Excel-Macros$$ Query for Code

2015-07-28 Thread Paul Schreiner
ohn Wesley - From: gargee singh To: "excel-macros@googlegroups.com" Sent: Tuesday, July 28, 2015 1:05 AM Subject: RE: $$Excel-Macros$$ Query for Code Dear Paul, Good morning and Thank you for the reply. I will try and explain this in a better way. If a user se

RE: $$Excel-Macros$$ Query for Code

2015-07-27 Thread gargee singh
: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query for Code So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the column for May 1, 2016 on the Summary sheet (column "G") will be populated?and it will be a sum of all sheets in which the first

Re: $$Excel-Macros$$ Query for Code

2015-07-27 Thread Paul Schreiner
So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the column for May 1, 2016 on the Summary sheet (column "G") will be populated?and it will be a sum of all sheets in which the first column matches the date selected?In your example, even though sheets A and C have a colu