EXCELlant
New Member
- Joined
- May 28, 2009
- Messages
- 29
</SPAN>I understand that a Macro is good for completing tasks which will be repeated but I have no idea how to even start with something like this.</SPAN>
I sometimes use the record macro option but this time I need to include a search function.</SPAN>
I downloaded some data at work labeled sheet 1 (see below) which shows both changes to a vendor and newly created vendors, and I would like to split them into two new sheets.</SPAN>
Here is an example of two vendors I would like the macro to look at column E and if grouped together has more than 2 “ *** Created *** </SPAN>” in column J it removes the data and puts it into a new sheet.</SPAN>
If there is 2 or less “*** Created *** “ then it will remain in the current sheet.</SPAN></SPAN>
<TBODY>
</TBODY>
The aim at the end of the task would be to have two sheets.</SPAN>
The one sheet displaying all of the vendors which have had modifications in the month (here highlighted in blue).</SPAN>
With another sheet with all of the new vendors for the period displayed (in the above picture highlighted in green).</SPAN>
Obviously the original data can have hundreds of lines with many new vendors or vendors which have had changes.</SPAN>
Any help, suggestions would be greatly appreciated.</SPAN>
Thank you.</SPAN>
I sometimes use the record macro option but this time I need to include a search function.</SPAN>
I downloaded some data at work labeled sheet 1 (see below) which shows both changes to a vendor and newly created vendors, and I would like to split them into two new sheets.</SPAN>
Here is an example of two vendors I would like the macro to look at column E and if grouped together has more than 2 “ *** Created *** </SPAN>” in column J it removes the data and puts it into a new sheet.</SPAN>
If there is 2 or less “*** Created *** “ then it will remain in the current sheet.</SPAN></SPAN>
E</SPAN></SPAN> | F</SPAN></SPAN> | G</SPAN></SPAN> | H</SPAN></SPAN> | I</SPAN></SPAN> | J</SPAN></SPAN> |
Vendor</SPAN></SPAN> | Changed By</SPAN></SPAN> | Field Name</SPAN></SPAN> | Company Code</SPAN></SPAN> | Purch. Organization</SPAN></SPAN> | New value</SPAN></SPAN> |
300874</SPAN></SPAN> | Confirm.status</SPAN></SPAN> | ||||
300874</SPAN></SPAN> | Name</SPAN></SPAN> | ||||
300874</SPAN></SPAN> | Bank Details</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
300874</SPAN></SPAN> | Chk double inv.</SPAN></SPAN> | 2000</SPAN></SPAN> | |||
300874</SPAN></SPAN> | Confirm.status</SPAN></SPAN> | ||||
300874</SPAN></SPAN> | Name</SPAN></SPAN> | ||||
300874</SPAN></SPAN> | IBAN</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Confirm.status</SPAN></SPAN> | ||||
303901</SPAN></SPAN> | ConfirmSt (CCd)</SPAN></SPAN> | 1000</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Bank Details</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Company code data</SPAN></SPAN> | 1000</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | ||
303901</SPAN></SPAN> | General data</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Purchasing Data</SPAN></SPAN> | 1000</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | ||
303901</SPAN></SPAN> | IBAN</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Cntrl Addr.Admn</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Cntrl Addr.Admn</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Cntrl Addr.Admn</SPAN></SPAN> | *** Created ***</SPAN></SPAN> | |||
303901</SPAN></SPAN> | Cntrl Addr.Admn</SPAN></SPAN> | *** Created ***</SPAN></SPAN> |
<TBODY>
</TBODY>
The aim at the end of the task would be to have two sheets.</SPAN>
The one sheet displaying all of the vendors which have had modifications in the month (here highlighted in blue).</SPAN>
With another sheet with all of the new vendors for the period displayed (in the above picture highlighted in green).</SPAN>
Obviously the original data can have hundreds of lines with many new vendors or vendors which have had changes.</SPAN>
Any help, suggestions would be greatly appreciated.</SPAN>
Thank you.</SPAN>