ales#'s for that SalesID?
>
> I'll see what I can do.
> I'll get back with you in the next few minutes.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you
the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-----
>
>
> ---
gt; To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Matty >
> *To:* excel-...@googlegroups.com
> *Sent:* Mon, October 8, 2012 3:06:00 PM
> *Subject:* Re: $
t; To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Matty >
> *To:* excel-...@googlegroups.com
> *Sent:* Mon, October 8, 2012 2:47:52 PM
> *Subject:* $$Exce
I need a macro that will copy specific rows based on the first value in my
example:
A1 B1, C1, D1, E1, Etc... thru AA1
0041
0042
0043
0041
0041
0043
Etc...
A1 is the reference value. B1 through AA1 indicate the Data range I need
copied to a new worksheet but a workbook would be bet
TCH(1,N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4),0)),1,,,SUM(N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4
> *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups
[IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Matty
> *Sent:* 26 September 2012 8:07
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Sumif Based on First Number of a Date Range
> Help Need
I need to sum up a range of data based on multiple criteria using only the
first number in a date string. For example I have a range of data I have
to sum attached to specific dates. I need to sum the total product for the
month and I am trying to base that criteria on the first number in the
