Merge Excel Sheets Using VBA?

If you need a more presice answer, you would need to try something first and then ask for help in area you have got stuck. My suggestion is you begin by; 1. Start writing a VBA script in OG.

XLS, as a first step try to access the file A. Xls and reading the columns and pasting them (they can initially be at any location in any order). 2.

Once you are able to do this, next step is to see if you put the data in right column (say 5000 in your example) by setting up right kind of variables and using them and incrementing them. 3. Your next step should be to to read the column headings in A.

XLS and finding them OG. XLS and identifying them. Initially you can begin by doing a simple string comparision, later you can refine this to do a VLOOKUP.

4. During this process, if you encounter any specific problem, raise it so that you will get a better answer.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.