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?
Yes: open both workbooks in Excel.
You can then point to a range in a sheet in the other workbook when you create the INDEX/MATCH formulas.
When you're done, close (and if necessary save) the 'source' workbook. this will add the path of that workbook to the formulas in the 'target' workbook.
Finally, save the 'target' workbook.
