Excel Project Help Column search within a Column search

[ltd_edition]

Sorry if this is the wrong location but I am struggling to complete a project at work. I need to have a macro that can look through a column to find a certain tool name and then be able to shift over to the second column and find a certain process name. This is meant to be used to copy data from one document, find the location in this document and then paste it in the correct location and repeat until the document is populated. If the process that I am suggesting is not the most optimal I am open to suggestion. Thank you for the help.

Doc1.pdf

[jdc2000]

This sounds like it should really be in the Office Development forum, since it looks like you want to use VBA.

Also, I think we need some more details on exactly what you are wanting to do. Are you copying the Excel data from one spreadsheet to another, or to a Word document? Are both sheets part of the same workbook? Will the data you are searching for be on different rows for each column?

Maybe you could post a screen capture or two. I cannot download and view the attached .pdf at my current location.

[westconn1]

you could use a SQL query to return all rows that match the tool and process, something like

sql = "select * from [woksheetname$] where somecolumn = 'mytool' and nextxcolumn = 'myprocess'"

to do like this you would need to make an ADO connection to the workbook, then open a recordset using the sql criteria
replace the worksheet and column names as appropriate, the column names will depend if your columns have headers or not