Can anyone help me in VBA with searching values in another workbook (preferrably a closed one)and then copying the values into a new spreadsheet. I would also like to check to see if the values match as well. I'm not sure how to start this. Any help would be great. THanks

hi,

without opening the workbook with the worksheet u need data from, try this:

path = [path where the file is located] (with \ at the end)
filename= [workbook where data has to be collected]
sheetname = [sheet from worbook with data]
'
string = "'" & path & "[" & filename & "]" & sheetname & "'!" & "r" & i & "c" & j
(i represents the row, j represents the column)
value = ExecuteExcel4Macro(string)

put this piece of code in a loop and you're done