New to VBA - Looking for help

Wispa

New Member
Joined
Nov 19, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,003
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

New Member
Joined
Nov 19, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Apr 11, 2012
Messages
10,003
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,099
Messages
5,576,128
Members
412,698
Latest member
Lilly13m
Top