andygen
asked on
Copy rows into a new excel document, where column has a value in.
Hi
I have a document that contains lots of rows, I want to automatically copy all the rows that contain a number in column G, into a new excel spreadsheet.
So I am thinking a macro would work best for this?
Thanks,
Andy
5digitareacodestest.xls
I have a document that contains lots of rows, I want to automatically copy all the rows that contain a number in column G, into a new excel spreadsheet.
So I am thinking a macro would work best for this?
Thanks,
Andy
5digitareacodestest.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER
Worked great thanks!
Andy