Hi All,
I am having 2 workbooks, In workbook1 we are having yearly data merged in the workbook, but every week we manually download the workbook. in the workbook we have to copy last week days like(monday to saturday) only that data we have to copy and paste it in another workbook last row. can you please tell me how to write the vba code for taking last week data based on last week which day to which day, we want.
I am having 2 workbooks, In workbook1 we are having yearly data merged in the workbook, but every week we manually download the workbook. in the workbook we have to copy last week days like(monday to saturday) only that data we have to copy and paste it in another workbook last row. can you please tell me how to write the vba code for taking last week data based on last week which day to which day, we want.