Excel Vba Expert Needed
Budget: $2 – $8 USD
I need an excel spreadsheet created.
I currently download an excel spreadsheet for work. It always has five columns with data. Each row : Description/ ID / Market Value / Class /Security Type. The descriptions rarely change, the market value is really the only cell that changes. I'd like to be able to copy the data into my spreadsheet and have the accounts populate into their respective tabs. Some times I have new accounts. So I need a way to see that there is a new account and if I need to make a new tab or otherwise add it to an existing tab. This is something I'd like to be able to do on demand but really only needs to be done once a quarter; due to it's currently being labor intensive. I currently have to upload the information onto each tab one at a time
I currently download an excel spreadsheet for work. It always has five columns with data. Each row : Description/ ID / Market Value / Class /Security Type. The descriptions rarely change, the market value is really the only cell that changes. I'd like to be able to copy the data into my spreadsheet and have the accounts populate into their respective tabs. Some times I have new accounts. So I need a way to see that there is a new account and if I need to make a new tab or otherwise add it to an existing tab. This is something I'd like to be able to do on demand but really only needs to be done once a quarter; due to it's currently being labor intensive. I currently have to upload the information onto each tab one at a time