Copy a row from worksheet to another based on date occurring

Hello,

I need a help in VBA/ Macros... I have an excel document where i have several sheet, each sheet related to a client tasks which needs to be done by my team. i need a Macros to copy an entire row from any of these sheets to the Tasks dashboard worksheet based on the date occurrence in the project worksheets.

attached is the workbook, for example in the worksheet SABIS when the start date is falling within one week from today date, i want the entire row to be copied to the tasks dashboard worksheet without deleting it from SABIS.

hope above briefing is sufficient to support me in this issue.

The following code will copy the rows automatically when you enter the date in column H. Copy the code into the code modules for worksheets "SABIS" and "CCC" (not into a regular module).

Please Login or Register  to view this content.

Dear Mumps 1,

Thank you very much, it is working perfectly. I’m wondering if the following could be coded as well
1- In case a date occurred in SABIS and the row has been copied to the dashboard, is it possible to automatically delete the row from the dashboard in case the start date again got changed in the original worksheet (for example SABIS)?
2- Is it possible to delete a row automatically in the dashboard (only) in case its status is changed to ‘’closed” in any of the worksheets (SABIS & Dashboard)?

Regards
Salam

Hello Salam. In order to do what you asked, each client task must have a unique identifier such as a 'Work Order Number' or something of that nature. It can be anything as long as it is unique for each task. Without this information, I have no way of identifying it and separating it from the other tasks on your 'Tasks Dashboard' sheet. Perhaps you can add another column which would contain this information for each task. If you can do this, please attach the revised file so that I can see what it looks like.

Hi Mumps1,

it is OK if i utilize alphabetic with numeric identifier?

That's OK as long as each is unique.

Sir,

Attached is the sheet updated based on your request.

appreciated.

Hi Salam. Replace the previous code in your revised file with the following and let me know if it works out for you.

Please Login or Register  to view this content.

Hi Mumps,

basically it is working with some snags, don't know if these issues are easy to be done or not. however if you feel that my requirements will be giving you bad time then ignore it.

here is the result of the test

- If i insert a date which is before today date in SABIS, the row is getting copied to the dashboard
- If i change the date several time within the 7 days range in SABIS, the row is getting copied to the dashboard several time as well
- If i delete the date in the SABIS, the row is getting copied in the dashboard
- while changing the status in Sabis to closed, the row is getting deleted in the dashboard. but if again you change the status to started for example in SABIS for the same row it's not getting copied
- If by mistake you delete the row in the dashboard it's not getting copied automatically

Hi Salam. Try the following code in each of the two worksheets. I believe that I have corrected the problems but it is best if you try it out and let me know how things go.

Please Login or Register  to view this content.

Hi Mumps,

So far so good, it's piece of art. appreciate all the effort you have provided and the professional work. i'll tested for the coming couple of days and let you know the result.

Hi Mumps.

it's working as needed, wonderful... i need another coding for a sheet, i was trying to search in the posts but didn't find something similar to my requirements. well my document is consisting of one worksheet only. i need the rows to be shifted up and down based one the date we insert in each row.

attached is a sample with proper dates. what i need is for example if i change the date in row 6 to be 11 May i want the row to be shifted to be after 10 may. if possible also for the formula at the the balance column to be updated that will be great.

Hi Salam. Place this code into the worksheet code module:

Please Login or Register  to view this content.