VBA Code: Transferring information to a new sheet

[Joe87noir]

Hi Forumers,
I am seeking a method to automate an excel sheet that has various projects that are either under progress or have been completed (percentage of completion varies from 0 to 100 percent). I would like to transfer projects that are still in progress (< 80%) over to a new sheet based on the year it was created i.e 2020 to 2021 etc.

In the new sheet, however there are already existing projects that are in progress so the old ones would (somehow have to start from the top of the new sheet below the title bar. Does anyone know how to work this?


Many thanks.

 

[OaklandJim]

Joe. It is not totally clear what is needed. It does seem that you'll need some VBA to automate as you describe. Someone might be able to assist but, ideally you post a workbook so the helper does not have to create dummy data. That is a significant impediment. You can post a link to a file in Dropbox or 1drive. Use the links icon at th top of a post to embed a link to the file.