Dear all,
I know that these days I should focus on something else, but I just cannot take it out of my mind and cannot find another way to do it but with macros. So I need some help with the following:
1. When Excel file opens up the macro copies from H11 to H16 and paste special with truncate in sheet2 in the next available empty row from A2, if date (Sheet1!H11) does not exist in Sheet2!column A:A.
2. Right after that, the macro copies the values from G11 to G16 in sheet1 and pastes the values from H11 to H16 (sheet1).
3. G11 date is equal to Filedatetime: C:\Users\admin\Desktop\book1.xls
The macro in point 2 two it's easy and I have even managed to make it when Excel opens up. Point 1 is too complicated for me because of the if condition. Point 3 I have tried many times adding the path but always get sseveral and different errors. Don't know exactly what I am doing wrong in there.
Many thanks all for your help. Attached the example.
Bookmarks