How automate to search and move data from one excel to another

Closed
Jlytee98 Posts 1 Registration date Monday April 28, 2014 Status Member Last seen April 28, 2014 - Apr 28, 2014 at 01:21 PM
 Blocked Profile - Apr 29, 2014 at 10:23 AM
Dear Friends,
I need a excel script to search columm A data from my lslpp-report and match the phrases in column A with the data from the lslpp raw data excel sheet once found than pull and copy data from the same row in column b and c into my lspp-report in column g and h . Right now I am searching manually and copying the data and pasting in the separate sheet. Will like to automate the task, Can someone some me How to do this please? Thanks in advance

1 response

Blocked Profile
Apr 29, 2014 at 10:23 AM
Ok, does the built in filter function work? You can filter a column based on the data. Have you tried that?
0