Power BI & VBA Automation Expert

$10-30 USD

Completato

Pubblicato

9 mesi fa

$10-30 USD

Pagato al completamento

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the portal]". • Automate the process of compiling engagement codes account wise.

Excel

VB.NET

Software Architecture

Rif. progetto: 37995741

Info sul progetto

3 proposte

Progetto a distanza

Attivo 9 mesi fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato a:

@anowarbss

Hi There, I read your project details carefully, as a professional and dedicated freelancer, I understand the value of accuracy. I have an excellent command over VBA, Macro, Python, Power BI, PDF, Acrobat, Photoshop, illustration, I am confident in my ability to complete this project efficiently and effectively. I am committed to delivering high-quality results that meet your expectations. so please contact me then I am ready to start now.

$10 USD in 1 giorno

5,0

(30 valutazioni)

4,1

3 freelance hanno fatto un'offerta media di $10 USD

@sajidjasi

Dear Md S., https://www.freelancer.com/u/sajidjasi Hope my message finds you well. With an experience of more than seven years in MS Power BI report development, I am writing to express my strong interest in the project titled "Power BI & VBA Automation Expert". With a proven track record in data analysis, and visualization using POWER BI and other tools, I am well-equipped to deliver valuable insights and actionable reports. My skills in Power BI encompass data modeling, DAX scripting, and creating interactive dashboards. I have a deep understanding of data integration, having successfully connected Power BI to various data sources, including SQL databases, Excel, google sheets, and other online services. I have knowledge and experience of handling complex data models to maintain data integrity and provide best data visualizations. Sincerely, Sajid Hussain

$10 USD in 3 giorni