Excel macro, VBA

Stängt Publicerat 2 år sedan Betalades vid leverans
Stängt 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

Excel Visual Basic Visual Basics för apps Databehandling

Projekt-id: #30542596

About the project

7 offerter Distansprojekt Aktivt 2 år sedan

7 frilansare har lagt bud på i genomsnitt $26 för det här jobbet

mrirfankhan1991

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

$20 USD inom 3 dagar
(0 omdömen)
0.0
karthick9698

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

$20 USD inom 7 dagar
(0 omdömen)
0.0
ptskishore2016

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

$26 USD inom 5 dagar
(0 omdömen)
0.0