Find Cell Containing Word in Excel, Grab Offset Cell Contents

I’ve been having some issues completing this task:

Search Column A in an excel file for a cell that contains the words Employer Contribution somewhere with in the cell (will have other words in it). When found grab the data 3 cells over in Column D. Copy this cell’s contents and paste into a different workbook.

I understand from the paste onward as I can save the copied result in a variable and use write cell to specify where I want it in the new workbook. But how would I search and grab the data? I’m sure I can do this in VBA but would rather not since I won’t be saving the workbook.

Read data table, then use select query with like operation as %Employer Contribution% then take the column value from which you want to copy the value…

1 Like