Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Run a macro to copy selective items
I receive daily several lists of part orders from the customer in Excel file that I do not have any control of. In the Excel file: Column A contents catergory 1 to 100 Column B contents items descriptions of each catergory (about 20 different items per catergory) Column C contents quantities of each item that are changed daily. How can I run a macro that will copy from the customer Excel file and paste only certain catergories within my department (i.g catergory 1 -20) and ignore the rests. Appreciate for any of your help Chris -- chrisdtran ------------------------------------------------------------------------ chrisdtran's Profile: http://www.excelforum.com/member.php...o&userid=15962 View this thread: http://www.excelforum.com/showthread...hreadid=395190 |
#2
|
|||
|
|||
I'd create a worksheet with just the categories I wanted in column A.
Then I'd add a formula to each row that checks the category against this list. =isnumber(match(a2,sheet2!a:a,0)) (and drag down) Then apply Data|filter|autofilter to that helper column. filter to show just the True's. Copy the visible cells and paste where you need to. chrisdtran wrote: I receive daily several lists of part orders from the customer in Excel file that I do not have any control of. In the Excel file: Column A contents catergory 1 to 100 Column B contents items descriptions of each catergory (about 20 different items per catergory) Column C contents quantities of each item that are changed daily. How can I run a macro that will copy from the customer Excel file and paste only certain catergories within my department (i.g catergory 1 -20) and ignore the rests. Appreciate for any of your help Chris -- chrisdtran ------------------------------------------------------------------------ chrisdtran's Profile: http://www.excelforum.com/member.php...o&userid=15962 View this thread: http://www.excelforum.com/showthread...hreadid=395190 -- Dave Peterson |
#3
|
|||
|
|||
I will try that. Thanks a lot for your help Dave -- chrisdtran ------------------------------------------------------------------------ chrisdtran's Profile: http://www.excelforum.com/member.php...o&userid=15962 View this thread: http://www.excelforum.com/showthread...hreadid=395190 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
copy macro assigned buttons in an array | Excel Worksheet Functions |