VBA/Macro to remove old data and adjust current data

**Joker2111`** · 09-29-2021, 12:41 PM

Hello,

I am needing assistance with creating a Macro that will look at the dates entered for an employee's sick occurrences and once an occurrence has aged past 1 year the macro will remove the entry and then move the entries that are less than a year old over.

For reference on the spreadsheet I uploaded, the Macro would be for the spreadsheet to remove the occurrences that are older than 1 year for the first test employee and then move the other entries over to the left, and once that is done both the first and second 'test' employees would be identical. I hope that is clear with what I am needing help with. If any additional information is needed please let me know.

I do appreciate any and all help/advice that is given. I am just looking for an easier way to keep this spreadsheet up to date for around 500 employees.

**WideBoyDixon** · 09-29-2021, 02:20 PM

There are probably some unanswered questions here but this is a start at least:

Please Login or Register  to view this content.

WBD

**alansidman** · 09-29-2021, 03:30 PM

crossposted: https://www.ozgrid.com/forum/index.p...04#post1252904

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

VBA/Macro to remove old data and adjust current data

LinkBack

Thread Tools

Rate This Thread

Display

VBA/Macro to remove old data and adjust current data

Re: VBA/Macro to remove old data and adjust current data

Re: VBA/Macro to remove old data and adjust current data

Thread Information

Users Browsing this Thread

Similar Threads

Adjust current macro for column selection

[SOLVED] Adjust VBA macro for a fixed location and remove user input

[SOLVED] macro to adjust data on same row

[SOLVED] Adjust a macro that consolidates data from multiple workbooks

Adjust macro to copy filtered data

Adjust Macro so that it does not delete rows containing certain data

Sort - Merge Current Data into blank cells, remove duplicate information

Bookmarks

Bookmarks

Posting Permissions