Automate Daily Metrics in Excel

₹750-1250 INR / hour

Posted less than 20 seconds ago

•

Ends in 6 days

₹750-1250 INR / hour

My team tracks key numbers in a master spreadsheet that lands on my desktop every morning. Right now I spend far too long copying the newest tab into yesterday’s workbook, merging rows, refreshing formulas, building trend calculations, and dressing it all up with charts before anyone even sees the numbers. I need a VBA-driven (or Power Query / Power Automate if you prefer) solution that will: • pull the fresh data from the incoming Excel file, • append it to our historical sheet, refreshing all formulas and trend calculations automatically, • generate a clean, date-stamped daily report file, and • fire off a concise email summary (totals and key variances) to our distribution list each morning. The heaviest time sinks for me today are the copy-and-combine steps, the rolling total and trend math, and the consistent chart and formatting work—so those all need to be hands-free when you’re done. Please build the automation so that scheduled execution is possible (Task Scheduler or equivalent) and leave clear, commented code so I can tweak ranges or add metrics later. Once the workflow runs end-to-end on my machine and the email summary lands in my inbox without manual touch, we’re good to sign off.

Project ID: 40818903

About the project

Open for bidding

Remote project

Active 57 yrs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅