Hey guys,
I am very new to visual basic and I am still trying to learn the basics. I would like to have some data in a workbook, then have that data copied out to the next empty row in either all open workbooks or I would create a list of the files to add the data to. Anyone have an idea of how to easily accomplish this? If you don't know the full answer, examples of code for the various tasks would be helpful, for example, code that finds the next cell, code that opens a list of files, code that copies and pastes a range, etc......
I am very new to visual basic and I am still trying to learn the basics. I would like to have some data in a workbook, then have that data copied out to the next empty row in either all open workbooks or I would create a list of the files to add the data to. Anyone have an idea of how to easily accomplish this? If you don't know the full answer, examples of code for the various tasks would be helpful, for example, code that finds the next cell, code that opens a list of files, code that copies and pastes a range, etc......
