Again thanks for the response!! Bob

I am completely blind in excel VBA instead of using some excel functions to automate my simple tasks.

Actually, I need to transfer data from multiple excels to single (consolidate) file.

So, again I have explained a very straight forward and attached sample

I need to transfer the values from two kinds of excel to one consolidated excel file at the end of the row every time.

From these three files, the QA tracker is static and the other two files have dynamic values or files but the naming of the excels is not changed. So, if try to get values from two dynamics excels to one consolidated file for respective columns

I have highlighted in yellow in each file to identify.

If there is an option to get data from two excel files to on QA tracker using Button is best for me!

Please let me know if you need anything further.

Thanks in advance!
Ganesan. G

Attached Files

	Defect Checklist.xlsx (18.1 KB, 7 views)
	Opportunity for Error Summary Master_v2.xlsx (19.4 KB, 7 views)
	QA Tracker.xlsx (26.0 KB, 7 views)