theodoros1
New Member
- Joined
- Aug 9, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hey Folks,
I am looking for a vba solution or any advice you can give on how I might achieve the following;
I have 2 worksheets; Sheet1: "Works" (which includes all the works i.e. those that are completed and those that are in progress with their expected finish date) and Sheet2 "Active Works" which is blank and show only dates of a week period on A:A. The dates of Sheet 2 are updating every day. The expected finish date of the active works is changing.
My hope is that I can run a macro that will use the expected finish date of each work in progress and copy the entire row (all details of the work) in repsective date of the Sheet2. The finished works marked with C so those to be ignored.
Any help or suggestions would be much appreciated.
Many thanks in advance,
Theo
I am looking for a vba solution or any advice you can give on how I might achieve the following;
I have 2 worksheets; Sheet1: "Works" (which includes all the works i.e. those that are completed and those that are in progress with their expected finish date) and Sheet2 "Active Works" which is blank and show only dates of a week period on A:A. The dates of Sheet 2 are updating every day. The expected finish date of the active works is changing.
My hope is that I can run a macro that will use the expected finish date of each work in progress and copy the entire row (all details of the work) in repsective date of the Sheet2. The finished works marked with C so those to be ignored.
Any help or suggestions would be much appreciated.
Many thanks in advance,
Theo