Hello,
I’m trying to compare two different excel files and I want to automate it in VBA. What I really need help with is copying over a range of data and making it into a table.
I want to be able to click a button on workbook1 sheet1 called “JData” that allows me to select a previously saved excel file workbook2. I want to copy the range of data on the first sheet of workbook2, paste it into workbook1 sheet2, make the data range into a table, and be able to sort the first column.
I would be able to modify the the code and use it for the second button on my own.
You’re help would be much appreciated!
I’m trying to compare two different excel files and I want to automate it in VBA. What I really need help with is copying over a range of data and making it into a table.
I want to be able to click a button on workbook1 sheet1 called “JData” that allows me to select a previously saved excel file workbook2. I want to copy the range of data on the first sheet of workbook2, paste it into workbook1 sheet2, make the data range into a table, and be able to sort the first column.
I would be able to modify the the code and use it for the second button on my own.
You’re help would be much appreciated!
