Hi All,
I have a workbook that i would like to copy some data from, to another workbook. I need it to find all values greater than £0.01 in column L the copy the data from column B and L only to Workbook 2, sheet 1. Starting from A9. Everytime the button is clicked it need to clear all the data in workbook 2 below row 8, then paste the new data in. Once the data has been pasted, then save and close workbook 2. It will need to loop though the data as quantitys of data can change each month.
Workbook1, sheet "MergedData") contains data to be copied.
Workbook2, Sheet1, is where the data need to be copied, starting a A9.
I don't have any code so far, so am staring from scratch.
Any help will be greatly appreciated!!!
Thanks
Aarron
I have a workbook that i would like to copy some data from, to another workbook. I need it to find all values greater than £0.01 in column L the copy the data from column B and L only to Workbook 2, sheet 1. Starting from A9. Everytime the button is clicked it need to clear all the data in workbook 2 below row 8, then paste the new data in. Once the data has been pasted, then save and close workbook 2. It will need to loop though the data as quantitys of data can change each month.
Workbook1, sheet "MergedData") contains data to be copied.
Workbook2, Sheet1, is where the data need to be copied, starting a A9.
I don't have any code so far, so am staring from scratch.
Any help will be greatly appreciated!!!
Thanks
Aarron