Hi Bob,



Thanks for the reply!!!

You correctly understood my concern.

Based on your question,

How am I doing so far? Is this even approximately correct?

As I mentioned earlier, the current cursor/cell position, the respective row's data range should copy to the respective workbook (XT or SB).

And by the way, what language are you used to?
I hope Excel VBA is a better language for this.

Please let me know if anything required.

Thanks in Advance!!!!
Ganesan. G

When I asked about languages I meant (for example) Bahasa. Or maybe Tamil? Just guessing. Neither one is among my accomplishments, so maybe we'll just have to stick to English.

Anyway, let's talk about the program: How much of it have you written so far? Which parts are working and which parts puzzle you?

If you're starting from the very beginning—if you don't know even how to start a VBA program in Excel—I'll have to start explaining from the beginning too. I want to know how much you already know, and have done, so I won't waste your time.

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)

Sorry for the delay, ganesang. I take it "completely blind" means you've never written an Excel program before, and don't know anything about it. But if you want to write this program, you'll have to learn. I don't mind coaching you, but if you'd rather not do that—if you're hoping someone will write it for you—I recommend you repost your question and hope someone else will answer. I'll leave the post alone, if you do that, so other people won't see my response and think your question is answered already.

But if you want to learn to write programs, let me know and I'll teach you, one step at a time.