lostandconfuzzeled
New Member
- Joined
- Dec 13, 2021
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
I need help with a VBA code and have absolutely no experience/knowledge with it. I have looked into it but ultimately come up confused where i am suppose to change data to match my workbook.
I am trying to copy data based on one cell with multiple and changing factors into other sheets for a collection process.
I have a master list I would like all the data to remain in (I know VBA can delete data from one sheet to move it to another and there is a way to copy it instead). I was able to figure out formulas to help make it easier (maybe) to determine which sheet it should go in.
Below is a pic of my worksheet. The top line is my practice line to work on. In L2 i have it set up based on G2 data to determine which sheet below it should go in. Basically depending on the ongoing date, G2 will updated by days and eventually L2 will change from "Current", "2 Months", "3 Months", and "Lien". K will be hidden data (it deals with balance remaining). I'm wanting the data to swap the the corresponding data between sheets based off the data in L2.
I am trying to copy data based on one cell with multiple and changing factors into other sheets for a collection process.
I have a master list I would like all the data to remain in (I know VBA can delete data from one sheet to move it to another and there is a way to copy it instead). I was able to figure out formulas to help make it easier (maybe) to determine which sheet it should go in.
Below is a pic of my worksheet. The top line is my practice line to work on. In L2 i have it set up based on G2 data to determine which sheet below it should go in. Basically depending on the ongoing date, G2 will updated by days and eventually L2 will change from "Current", "2 Months", "3 Months", and "Lien". K will be hidden data (it deals with balance remaining). I'm wanting the data to swap the the corresponding data between sheets based off the data in L2.
