Forum Discussion
Moving data from excel spreadsheet to spreadsheet based on present or absent criteria
Hi, this is a problem that I cannot solve myself. I have an excel spreadsheet which has unique customer codes in one column and a column next it which contains comments based on my phone conversation...
I found that IndexMatch does what I want it to do on a worksheet or between worksheets on different tabs. Excellent! However, I want two separate workbooks (separate excel files) to do this between. Is this possible?