Excel with VBA for generating outputs

終了済み 投稿 5年前 着払い
終了済み 着払い

My idea is, that the user opens a empty Excel file (with macros) and has several options to generate different types of outputs. The VBA code should:

- open a window to choose the csv file

- read and clean data

- sort data according to my specifications

- generate output as new Excel files and PDF files

The data is structured and comes with headers. The output is "repetitive".

Task 1) Say you have structured data of lots of items and they belong to different categories (which are defined by a value/string in a column), then you group by the category and you make an output (Excel sheet) per each category. The design of the Excel sheet is simple and the same for each output (1 output per category). Additionally there is a function to print all the Excel sheets as PDF.

Task 2) You use the same data but you create 3 outputs based on different criteria. And again, there is a function to print PDFs.

P.S. Something like a licence key thing needs to be implemented to. More infos via chats.

エクセル Excel VBA ビジュアルベーシック

プロジェクトID: #18409299

プロジェクトについて

61個の提案 リモートプロジェクト アクティブ 5年前

61人のフリーランサーが、平均$337 で、この仕事に入札しています。

ParisPallas

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. According to your brief, you want to have some macros to transform data and export it into Excel or pdf files. もっと

$400 USD 5日以内
(639件のレビュー)
8.7
asin1987

Dear Employer, I understand your requirement and I will do the VBa job for you. Please message me. I will create the macro which will do all 3-4 functions that you are ooking for. Do try me once!! :) Thanks an もっと

$555 USD 10日以内
(288件のレビュー)
8.4
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Excel with VBA for generating outputs. I can assure you the quality job. I have good experience in Excel, Excel VBA, Visual Basic. We have wo もっと

$300 USD 6日以内
(562件のレビュー)
8.5
seaanddream

Hi, my name is Selim. I read your `Excel with VBA for generating outputs` project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we もっと

$300 USD 5日以内
(303件のレビュー)
8.1
sloker18

I am proficient with Microsoft excel and macro/VBA development, I had solid experience to extract report from large amount of data and export with preferred format, I can write the macro to generate customized output a もっと

$400 USD 5日以内
(186件のレビュー)
7.7
bouslimi1979

Hi, can you please provide sample input files we will use ? Thanks ****************************************************************************************************************

$250 USD 3日以内
(338件のレビュー)
7.9
zekovicm

Hi there,I am Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agree もっと

$500 USD 5日以内
(163件のレビュー)
7.8
sumon355

Hello, As an experienced VBA developer, i am very much interested to do this project. Let's discuss more. Thanks

$600 USD 10日以内
(192件のレビュー)
7.5
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Ive done this kind of macros several times. Check my r もっと

$400 USD 7日以内
(337件のレビュー)
7.5
zExcel

I'd be happy to help you with this project. I'm experienced with all Excel functions including advanced formulas and macros and I have an excellent record of quick turnaround time. Just let me know when you're ready a もっと

$250 USD 2日以内
(257件のレビュー)
7.7
dgled

I would like to suggest to you a Microsoft Excel application which enables you to manage databases of resources in a spreadsheet. There is a search engine with high search capability to find specific information. The もっと

$500 USD 10日以内
(96件のレビュー)
7.5
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.

$400 USD 5日以内
(194件のレビュー)
7.1
nagyzoltan68

Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel, working with multiple files with transferring data with / without changing もっと

$250 USD 3日以内
(189件のレビュー)
7.0
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl もっと

$250 USD 2日以内
(195件のレビュー)
6.9
dvcontact

Hi, You may not select the right candidate without knowing what your project on writing Excel VBA to open csv file, read and clean data sort data and generate the output as new Excel spreadsheet and pdf will look like もっと

$250 USD 10日以内
(77件のレビュー)
7.1
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$250 USD 10日以内
(127件のレビュー)
6.7
nvchien94

Hi there, I am an Excel VBA coder. Your project can be completed in 2 days I think. Contact me and share some sample of CSV input and I will give you demo result. I do everything very fast. So let make contact. もっと

$250 USD 2日以内
(230件のレビュー)
6.6
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I will create excel vba program to open and access csv files and print results into new ex もっと

$250 USD 3日以内
(141件のレビュー)
6.2
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Expert in PYTHON,.NET, VB, VBA, MYSQL, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formu もっと

$250 USD 3日以内
(88件のレビュー)
6.2
Sercho56

I have extensive experience in Excel and VBA. I will work with you to develop a very simple User Interface that will enable your user to import and sort the CSV files as requested. Can I ask if you are using Mac or Wi もっと

$388 USD 10日以内
(43件のレビュー)
6.1