Copy data from several workbooks to one master workbook

Hi!

I have multiple Excel workbooks (with different names) and I want to copy some data from column A and column C (the cell names/reference are same in all the workbooks). I want to paste this data to 1 master excel file such that the data goes to the next available row instead of overwriting.

Can you please tell me the steps to record a macro for this purpose. I do not know how to write the VBA script.
From Company ABC file to Master file.
A1 to go to A4;
N5 to go to B4;
P5:P12 to transpose and go to C4:J4.

Such that the data from the next Company file should go to row 5 in the Master file.

Seriously need your help. My job is in danger!!
Please please respond quickly.

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

Actually i missed out in declaring a variable. I have edited the above code and you can try it and let me know. Change the path in this line

Please Login or Register  to view this content.

to reflect the path where your files are located.