Find Jobs
Hire Freelancers

Create a report on XLS file using a macro

$15-25 USD

Fullført
Lagt ut over 2 år siden

$15-25 USD

Betalt ved levering
Hello people, i need to add a macro on a Excel file in order to create a report on XLS and/or PDF format where to show desired results according to needed criteria. This report will be created after clicking a button and it will show a grid with results. All data is already added to file and extracted to my DB: i only need to elaborate these informations and create a report (it must be possible to select output format XLS or PDF). Please contact me for further details. DASHBOARD --> Create a selectable calendar near Order Delivery Time --> Create output format selector for the report (PDF or XLS) --> Create a button to start the macro and create the desired report on a separate file LAN_ORDERS --> DB query results (no modifications needed) LAN_POP_PRODUCTS --> Grid with products informations and parameters (each group column show the a different number according to group) LAN_POP_GROUPS --> Grid with assigned group to shops FINAL REPORT --> Show desired results according to these critieria: List all product codes for each filiale that are not meeting the minimum quantity for the selected Order Delivery Time date i.e. Delivery Date Time 22/07/2021 Shop Product Code Description Minimum Quantity Ordered Quantity 1 | 65826 | SALE IODATO GROSSO 1KG | 12 | 5 | The code 65826 must be ordered on a quantity => of 12 because shop 1 is added to group B.
Prosjekt-ID: 30903210

Om prosjektet

11 forslag
Eksternt prosjekt
Aktiv 3 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Greetings! This is a pretty straightforward requirement. Please share Excel file with sample data and I would come up with a macro as per requirements. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Have a Great Day! Srinivasan
$20 USD om 1 dag
5,0 (229 omtaler)
7,1
7,1
11 frilansere byr i gjennomsnitt $41 USD for denne jobben
Brukeravatar
Dear Client, I'm proposing for this job as I'm very experienced with Excel, particularly macro coding in VBA. I've done a lot of projects beyond this website. I made an CRM system for a company in VB.Net. I also provide a long-time support for all my projects after completion. Best regards František Világi
$20 USD om 7 dager
5,0 (3 omtaler)
4,2
4,2
Brukeravatar
Hi there, This can be done with C# .NET. However it will be an external software which you will drag and drop the excel files into, click a button to generate wither PDF or XLS of the results. Let me know. Thanks. Kind Regards, Paul G.
$30 USD om 1 dag
5,0 (5 omtaler)
3,5
3,5
Brukeravatar
Hello there, ✅24 hours availability ✅Unlimited revisions ✅Fast response I read the project's description and I'm sure I can do this task as per your requirement. Please give me a chance to share my work before hiring anyone. Here you can see my profile :- https://www.freelancer.com/u/rahulg5466 Let's connect over chat to discuss about the work and get started Thank you ! Stay Safe !
$20 USD om 1 dag
4,9 (5 omtaler)
2,1
2,1
Brukeravatar
I will do this within time limit and 100% accuracy I have good experience in it and I am expert in data entry
$17 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi sir, This is M. Rawat and I have 50 plus expert employee , Can we discuss more details about this project? Thanks, M Rawat
$20 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I'm Debbie Charles, 23years old, A college graduate of Business Management and I have a diploma in Computer science. I know I'm a strong candidate for this Job because; 1. I have a special ability to juggle multiple projects, In my previous internship, I worked on trademarks for a famous installation artist while going to school, together with my 4hrs SRT (single Review Tool) Job, Reviewing ads for Facebook. I was able to complete all the task given to me with excellence. 2. I have an excellent customer service skills, I'm totally friendly and I have good communication skills, I also show Empathy to my clients. 3. I'm a problem solver( I see it, I own it). I'm resilience, Analytical, levelheaded, creative and Innovative. I often stop at nothing till I get closure on a problem. 4. I speak and write very well with English. I'm very much Computer savvy(I have a diploma) and I'm very proficient in Microsoft Skype,  Outlook, Quickbook, Excel, PowerPoint etc. During the pandemic I took a visual Teaching Job. I prepared my lessons using PowerPoint, they reached out to me using Outlook and Gmail, and we had a Visual Lesson using Skype and Zoom. 5. I'm very Agreeable, Teachable and you'd never have to tell me what to do twice.
$25 USD om 7 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

ITALYs flagg
Genova, Italy
5,0
59
Betalingsmetode bekreftet
Medlem siden nov. 27, 2010

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.