New to VBA - Looking for help

[Wispa]

I have looked through the boards and this question may have been answered but whilst I know my way round Excel, my limited knowledge of VBA isn't helping.

I have a 'master' spreadsheet that holds a large amount of data that at present I am manually copying from other sources.

I would like to be able to automatically copy data from a batch of spreadsheets in a folder, with the data in a column, to a sheet on the master spreadsheet, switching the data from vertical columns to horizontal rows in the process and adding it to the first blank row.

Is this possible?

Is it also possible to do the same in reverse and generate the initial blank spreadsheets with basic data from the master spreadsheet similar to a mail merge?

Sorry to ask so many questions.

Thanks in advance

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your master sheet and a t least one of your source sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

Is it also possible to do the same in reverse and generate the initial blank spreadsheets with basic data from the master spreadsheet similar to a mail merge?

Also, please explain in more detail what you mean in the above quote again referring to specific cells, rows, columns and sheets using a few examples from your data.

 

[Wispa]

Thanks for the quick reply. I can certainly do that but it will take me a day or so as I will have to make the source sheet. I was trying to find out if it was possible before I spent the time making the sheets and changing the processes we follow.

It shouldn't take me long though but won't be today.

to use a well known phrase, "I'll be back"

 

[mumps]

The sheets only need enough rows of data to demonstrate how that data is organized. Try to use actual sheets names. Also post the full path to folder containing the source files.