Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-05 Thread Mr excel
gt; >>>> >>>> On Tue, Oct 4, 2011 at 11:09 PM, Sam Mathai Chacko >>>> wrote: >>>> >>>>> For the sake of an alternative, here's one using Pivots, though I would >>>>> go with Don. >>>>> >>>&g

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-05 Thread Sam Mathai Chacko
gt;>> For the sake of an alternative, here's one using Pivots, though I would >>>> go with Don. >>>> >>>> Regards, >>>> Sam >>>> >>>> >>>> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1 wrote: >>>> >>&

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-05 Thread Mr excel
hacko wrote: >> >>> For the sake of an alternative, here's one using Pivots, though I would >>> go with Don. >>> >>> Regards, >>> Sam >>> >>> >>> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1 wrote: >>

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-04 Thread Mr excel
> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1 wrote: >> >>> What is the reason that you do not like my idea of filtering? >>> >>> *From:* Mr excel >>> *Sent:* Tuesday, October 04, 2011 8:42 AM >>> *To:* excel-macros@googlegroups.com >>>

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-04 Thread Mr excel
gt; >> What is the reason that you do not like my idea of filtering? >> >> *From:* Mr excel >> *Sent:* Tuesday, October 04, 2011 8:42 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter >> >> any help

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-04 Thread dguillett1
What is the reason that you do not like my idea of filtering? From: Mr excel Sent: Tuesday, October 04, 2011 8:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update sheets on Enter any help from anybody please? On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 wrote

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-04 Thread Mr excel
ber 03, 2011 11:56 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter > > huhh..My COmmunication is sucking day by day...sorry guillet.i could > not communicate to you properlyHope this time i could make it clear > > Fr

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-04 Thread dguillett1
I, or some of the others can amend my code to do as desired. However, again, I suggest you try this where you simply use filters on ONE sheet. From: Mr excel Sent: Monday, October 03, 2011 11:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update sheets on Enter huhh

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-03 Thread Mr excel
huhh..My COmmunication is sucking day by day...sorry guillet.i could not communicate to you properlyHope this time i could make it clear >From the Worksheet *MAKESHEETS example *given by you.You are adding/creating sheets based on the REP cell...Here the macro starts only when it is r

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-03 Thread dguillett1
OK. I now see what you wanted which means a slight modification to my macro. However, I also posted a STRONG suggestion to just use filters. From: Mr excel Sent: Monday, October 03, 2011 4:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Update sheets on Enter Hi group

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-03 Thread dguillett1
I don’t understand what you need There is a master sheet and no sample sheet for your desires. My macro and the other do essentially the same thing. From: Mr excel Sent: Monday, October 03, 2011 10:54 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update

Re: $$Excel-Macros$$ Update sheets on Enter

2011-10-03 Thread dguillett1
I suggest, instead that you use ONLY one sheet and filter as desired. See attached and filter by region and then by date. to clear filters use data>filter>show all From: Mr excel Sent: Monday, October 03, 2011 4:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Update

$$Excel-Macros$$ Update sheets on Enter

2011-10-03 Thread Mr excel
Hi group, I had been struggling with a solution for a problem from many days.. Recently i had seen a macro in this group which is very much nearer to my problem.The sample data is taken from one of the previous examples given by guillet. Going by the same sample data : the main sheet c