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 sheets on