Re: $$Excel-Macros$$ File Consolidation and Data SummarizationFormula Help Needed

2011-04-09 Thread John A. Smith
Again, thank you Ashish very much. You have taught me a lot. John On Sat, Apr 9, 2011 at 6:27 AM, ashish koul wrote: > > in excel 2007 format > > > On Fri, Apr 8, 2011 at 2:49 AM, John A. Smith wrote: > >> Ashish, >> >> One more thing please; that macro in a 2007 format? I ran out of column

Re: $$Excel-Macros$$ File Consolidation and Data SummarizationFormula Help Needed

2011-04-07 Thread John A. Smith
Ashish, One more thing please; that macro in a 2007 format? I ran out of columns. Thank you again. John On Thu, Apr 7, 2011 at 11:22 AM, ashish koul wrote: > try this > > run macro to merge the data and check sheet 2 and 3 for formula > > On Tue, Apr 5, 2011 at 11:10 PM, John A. Smith > w

Re: $$Excel-Macros$$ File Consolidation and Data SummarizationFormula Help Needed

2011-04-07 Thread John A. Smith
Ashish, Perfect! Thank you for your patience and your teaching. John On Thu, Apr 7, 2011 at 11:22 AM, ashish koul wrote: > try this > > run macro to merge the data and check sheet 2 and 3 for formula > > On Tue, Apr 5, 2011 at 11:10 PM, John A. Smith > wrote: > >> Ashish, >> >> I have attac

Re: $$Excel-Macros$$ File Consolidation and Data SummarizationFormula Help Needed

2011-04-05 Thread John A. Smith
Ashish, I have attached the My Questions tab as a file by itself. Thank you for your kind help. John On Tue, Apr 5, 2011 at 12:55 PM, wrote: > Ashish, > > There are 22 employees. I don't need any blanks if no data for an employee. > If their name isn't on the list they were off. If their name

Re: $$Excel-Macros$$ File Consolidation and Data SummarizationFormula Help Needed

2011-04-05 Thread johnasmith13
Ashish, There are 22 employees. I don't need any blanks if no data for an employee. If their name isn't on the list they were off. If their name is on the list but no orders pulled, they were assigned to a utility job and don't need to be on the summary either. As soon as I can get to my comp