LRA546
01-10-2018, 01:39 PM
Hey Guys,
This is my first time using VBA so I'd be really grateful for any help/advice. I've done a few online tutorials so have learnt the basics but this is my first project as such.
I'm looking to create a code which is able to copy data out of one file and place into a summary folder.
For example, I have files such as 1056, 1057 through to 1186. Within these workbooks, I need to copy data out of a sheet which the name is velocity and the data is in cells C6:D17. It would great to also put the file name above the data. The data needs copied into a new workbook which is called summary.
Any help to get me up and running with this project would be greatly appreciated,
Thank you :)
This is my first time using VBA so I'd be really grateful for any help/advice. I've done a few online tutorials so have learnt the basics but this is my first project as such.
I'm looking to create a code which is able to copy data out of one file and place into a summary folder.
For example, I have files such as 1056, 1057 through to 1186. Within these workbooks, I need to copy data out of a sheet which the name is velocity and the data is in cells C6:D17. It would great to also put the file name above the data. The data needs copied into a new workbook which is called summary.
Any help to get me up and running with this project would be greatly appreciated,
Thank you :)