HelloWorld123
New Member
- Joined
- Oct 1, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi, I have just got a hang of macro but need some help with coding in VBA!
I have a calendar with a lot of different activities placed in different cells. Let's pretend that my activities are A,B,C. The cells in the calendar (workbook A) will be externally referenced with data (dates) from workbook B. Once I update the data in workbook B I want my cells to, with a macro, move from one column to another (still be placed in the same row) depending on the column's value in workbook A and cells value in workbook B.
Workbook A (Calendar)
Workbook B
So if i change the date in workbook B (Cell L1) from 2021-05-09 to 2021-05-10, then I want that the cell in workbook to move automatic to that specific date, like this:
Before:
---> After:
How do I create a macro that can achive that? (I'm not experienced with coding)
Is it possible to create a macro that makes all the activities to do the same, so I don't have to make a macro for each cell?
Thank you!!
I have a calendar with a lot of different activities placed in different cells. Let's pretend that my activities are A,B,C. The cells in the calendar (workbook A) will be externally referenced with data (dates) from workbook B. Once I update the data in workbook B I want my cells to, with a macro, move from one column to another (still be placed in the same row) depending on the column's value in workbook A and cells value in workbook B.
Workbook A (Calendar)
So if i change the date in workbook B (Cell L1) from 2021-05-09 to 2021-05-10, then I want that the cell in workbook to move automatic to that specific date, like this:
Before:
How do I create a macro that can achive that? (I'm not experienced with coding)
Is it possible to create a macro that makes all the activities to do the same, so I don't have to make a macro for each cell?
Thank you!!