Hello,
I need to design a macro and I don't know where to start. What I want the marco to do is to look for a value in a column on my source workbook. If it finds that value I want it to copy the entire row into a different workbook. With each Value going to a different sheet. Example:
Source:
Column A
10
20
10
15
20
10
Everytime the number 10 shows up, I want that entire row copied and pasted to my new workbook and its corresponding sheet.
New Workbook
Sheet 10
10
10
10
Sheet 20
20
20
Sheet 15
15
Thank you in adavnce for your help.
I need to design a macro and I don't know where to start. What I want the marco to do is to look for a value in a column on my source workbook. If it finds that value I want it to copy the entire row into a different workbook. With each Value going to a different sheet. Example:
Source:
Column A
10
20
10
15
20
10
Everytime the number 10 shows up, I want that entire row copied and pasted to my new workbook and its corresponding sheet.
New Workbook
Sheet 10
10
10
10
Sheet 20
20
20
Sheet 15
15
Thank you in adavnce for your help.