Excel macro, VBA
$10-30 USD
Betalades vid leverans
Need to create macro, which will take pasted data(every day new) and will sort it in desired structure for further use as historical data
1. Every day, except weekends, sheet "data update" will be updated with new information with same structure ( columns). Previous day will be deleted and new day info will be pasted instead of it
2. After click on "Update" button on "data update" sheet:
A)It needs to update Pivot tables on "per state" and "per state(days sitting)" sheets (I did it with refreshAll function, you can left it be like that)
B) Newly pasted data should be added as values to next empty column at "backend" sheet with matching to TrL CD column, which will be static. At the top of that data would like to have date, at which it was pasted, so when I will need to, I would be able to search historic data and compare them. TL'DL "backend" should save everyday historic data from "data update" sheet so it can be viewed as records sheet to compare performance.
(not required, but will tips for that)3. Macro will need to group pasted in "backend" data, so it would be easier to navigate; create table which will automatically add last record data to its column.
let me know if you have any question, can schedule google meets so we can discuss it more
Projekt-id: #30542596
About the project
7 frilansare har lagt bud på i genomsnitt $26 för det här jobbet
Hello, Dear I have read your project and I have understood your projects I have the experience to do this type of project earlier. I have worked many platforms before. So I have the confidence to do this. If you want w Mer
HELLO, MYSELF KARTHICK. I’M A PROFESSIONAL DATA ENTRY EXPERT. I WILL CONVERT PDF INTO EXCEL. I WILL PROVIDE YOU WITH HIGH-QUALITY SERVICES IN REASONABLE DELIVERY TIME. FEEL FREE TO CONTACT ME AT ANY TIME. LOOKING FORWA Mer
Hi, I am having the relevant experience in developing macros. Also developed 100s of excel automated solitons using macros. If you find my profile suitable let us take this n the conversation. Loking forward for your Mer