Завершен

Create a report on XLS file using a macro

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.

Навыки: Excel, Visual Basic, Microsoft Access, Обработка данных, Архитектура ПО

Показать больше: print access report pdf file using vba, save output agng report xls file oracle apps, export dataset formated xls file using aspnet, create report java swing using mysql, java create report text file, create view xls file php, create xml csv file using perl, read xls file using, create table xml file using, create mysql xls file, upload xls file using extjs, create rss feed file using perl, export excel text file using macro, query csv file using macro, reading xls file using php, how to create a doc file using php, how to create executable jar file using maven in eclipse, how to create a word file using python

О работодателе:
( 59 отзыв(-а, -ов) ) Genova, Italy

ID проекта: #30903210

Поручен:

ksriniravi

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 p Больше

$20 USD за 1 день
(229 отзывов(-а))
7.1

11 фрилансеров(-а) готовы выполнить эту работу в среднем за $41

(226 отзывов(-а))
7.1
(71 отзывов(-а))
6.5
(20 отзывов(-а))
4.8
LordVilagi

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 provid Больше

$20 USD за 7 дней(-я)
(3 отзывов(-а))
4.2
kosmicforger

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. Больше

$30 USD за 1 день
(5 отзывов(-а))
3.5
(8 отзывов(-а))
3.1
rahulg5466

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 Больше

$20 USD за 1 день
(5 отзывов(-а))
2.1
amitlamba007

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 за 3 дней(-я)
(0 отзывов(-а))
0.0
Madanmrawat

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 за 3 дней(-я)
(0 отзывов(-а))
0.0
Suunshineee00

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 Больше

$25 USD за 7 дней(-я)
(0 отзывов(-а))
0.0