Hi guys,
just to check, is it possible to create a macro to perform the following actions ?
1. Workbook A contained calculated data, ranging from cell A1 to G1 (Fixed as the data varies on a daily basis)
2. Workbook B contained all the past dated data which is copied from workbook A, recorded on a daily basis
3. Cell A2 and B2 in workbook A is copy and paste in workbook B base on previous date
4. Others cells in workbook A is copied and paste in workbook B based on today -2 (excluding weekend)
5. Different tabs are created in workbook B on a monthly basis
6. Location of the destination cell to be copied to workbook B varies on a daily basis
7. workbook B is password protected
Apologize, as i'm still quite new to macro and are trying to learn it along the way ...
thanks !
just to check, is it possible to create a macro to perform the following actions ?
1. Workbook A contained calculated data, ranging from cell A1 to G1 (Fixed as the data varies on a daily basis)
2. Workbook B contained all the past dated data which is copied from workbook A, recorded on a daily basis
3. Cell A2 and B2 in workbook A is copy and paste in workbook B base on previous date
4. Others cells in workbook A is copied and paste in workbook B based on today -2 (excluding weekend)
5. Different tabs are created in workbook B on a monthly basis
6. Location of the destination cell to be copied to workbook B varies on a daily basis
7. workbook B is password protected
Apologize, as i'm still quite new to macro and are trying to learn it along the way ...
thanks !