Closed

excel macro modifications

I need some changes on an excel worksheet(macro) because it doesn’t not correctly calculate outputs if I use file in database with a date beyond the actual day:

1. Let the macro works also for dates beyond the actual day.

Use the file name of worksheet in database to understand the date of the most recent file, their name is always in this format: YYYY-M-DD (2022-8-23) or in cell E4.

Use this information for calculate on SOSTITUZIONI sheet the value “Giorni da ultima sostituzione” instead then actual date.

2. On SOSTITUZIONI sheet Divide(split) with a white line, or something else that is belived a better solution, the field between two persons histogram.

Skills: Excel, Visual Basic

About the Client:
( 7 reviews ) udine, Italy

Project ID: #34758165

31 freelancers are bidding on average $49 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a More

$50 USD in 1 day
(515 Reviews)
8.4
(537 Reviews)
7.9
(415 Reviews)
7.6
(231 Reviews)
7.0
(230 Reviews)
6.6
(446 Reviews)
6.7
(220 Reviews)
6.6
AccountantArman

""""""""""""""""""""""EXCEL VBA MACRO EXPERT"""""""""""""""""""""" "Sir, I am Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountan More

$30 USD in 1 day
(193 Reviews)
6.7
(44 Reviews)
6.3
(195 Reviews)
6.5
PERPETUAL0

Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t More

$35 USD in 1 day
(161 Reviews)
5.9
(134 Reviews)
6.0
(88 Reviews)
5.4
merinsinha

Excel Macro expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipati More

$25 USD in 1 day
(139 Reviews)
5.6
(84 Reviews)
5.2
(96 Reviews)
5.0
(36 Reviews)
5.2
Maherun75

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta More

$20 USD in 1 day
(14 Reviews)
3.8
benrached46

Hi, I am Rached a software engineer, i made many project on Excel/ Vba macros, i can fix your macro code, contact me.

$20 USD in 7 days
(2 Reviews)
3.7
AlbertoBarberoIt

Ciao Udine! Sono l'unico italiano qui......Bello il tuo file! Posso provare a sistemarlo io? Ho cercato la cella E4 l'ho trovata solo in un foglio ma non sono sicuro che tu ti riferisca a quello. Ho messo 7 gg indicati More

$30 USD in 7 days
(9 Reviews)
3.7