Hello!
I have a spreadsheet that lists employee insurance information. I am using a power query to update the table every month. I am wanting to create a code that loops through the ListObject and moves the row to a new sheet based on the effective date.
Example:
Effective date
10/01/2021-moves row to sheet "October"
02/01/2021-moves row sheet "February"
Can someone point me in the right direction? Thanks!
I have a spreadsheet that lists employee insurance information. I am using a power query to update the table every month. I am wanting to create a code that loops through the ListObject and moves the row to a new sheet based on the effective date.
Example:
Effective date
10/01/2021-moves row to sheet "October"
02/01/2021-moves row sheet "February"
Can someone point me in the right direction? Thanks!