Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Removing completed work from main sheet to monthly tab automatically when date inserted to column i

0
New workbook for new job my employer is looking for the completed work to disappear from the master sheet that has all our outstanding work onit and automatically appear in the correct month completed tab along the bottom once the date completed is added in column I. So when I enter the date say 01/04/2017 in column I the this row should move from the first sheet to the tab labelled April 17. so therefore only leaving outstanding work on the very first sheet. I know I will have to use macros but its been soo long since I have used them I have completely forgotten. any help would be much appreciated.
Answer
Discuss

Answers

0

this shows up as unanswered post, since april 2017

is this the case

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login