Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

2012-10-09 Thread Matty
, 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 *- -- *From:* Matty whee...@msn.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Mon

Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

2012-10-09 Thread Matty
*- -- *From:* Matty whee...@msn.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Mon, October 8, 2012 4:33:06 PM *Subject:* Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based

$$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

2012-10-08 Thread Matty
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

Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

2012-10-08 Thread Matty
*- -- *From:* Matty whee...@msn.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Mon, October 8, 2012 2:47:52 PM *Subject:* $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based

Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new worksheet based on Mult Data Values

2012-10-08 Thread Matty
*- -- *From:* Matty whee...@msn.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Mon, October 8, 2012 3:06:00 PM *Subject:* Re: $$Excel-Macros$$ Macro to Filter OR Copy and Paste row data to a new

$$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
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

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Matty *Sent:* 26 September 2012 8:07 *To:* excel-...@googlegroups.com javascript: *Subject:* $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed I need to sum up a range of data based

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
))*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.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Matty *Sent:* 26 September 2012