Đã Đóng

Changing excising Excel VBA program with a new CSV input format

I have a Excel VBA program with some function and would now like to change the input CSV file format to a slightly different csv format.

New Functions Program MS-CSP V1.7

Black text existing function that should remain

Green text Disable functions

Red Text new functions or changes

The main thing here is that I´m changing the input file with another column format and I want the Program MS CSP to adapt for the new format.

The output from this new file should be the same as the input file in meaning the column, It means that the program should not delete any columns or move them for the output file.

When using Import Button:

The new file has 108 colomns (A-DD) (And the old one had 107 columns A-DC)

The file name begins now with XSP_DailyBillFeed

When Using "Report Button" Button Change following from where it should take the information in the new file.

Change column from CI to CQ

Change column from CK to CS

Change column from CL to CO

When Using "Calculate" Button change following functions

The Program should not change and delete any columns, is should be the same format as it first is imported as it should be as output format.

If Column (CI) "Reseller Reference" (Exact spelling) exist, delete the whole column.

If Column (CJ) "Customer Reference" exist, delete the whole column.

If Column (CK) "Category" exist, delete the whole column.

If Column (CL) "Issue Date" exist, delete the whole column.

If Column (CN) "Validation Date" exist, delete the whole column.

If Column (CO) "Arrow Contact ERP ID" exist, delete the whole column.

If Column (CP) "Reseller Contact ERP ID" exist, delete the whole column.

If Column (CQ) "Customer Contact ERP ID" exist, delete the whole column.

If Column (CR) – “Retail Unit Price” exist, delete the whole column.

If Column (CS)- “Retail Total Price” exist, delete the whole column.

If Column (CT)- “Rate” exist, delete the whole column.

If Column (CU)- “Customer Unit Price” exist, delete the whole column.

If Column (CV) – “Customer Total Price” exist, delete the whole column.

If Column (CW) – “ERP Invoice ID” exist, delete the whole column.

And move Column "Billing ID" after column (CG) "Reseller Company Tags"

And move Column “Customer Billing ID” after column (CH) “Billing ID”

And move Column “Exchange Rate (Service Provider Currency)” after column (CI) “Customer Billing ID”

And move Column “Vendor Unit Price (Service Provider Currency)” after column (CJ) “Exchange Rate (Service Provider Currency)”

And move Column “Total Vendor Price (Service Provider Currency)” after column (CK) “Vendor Unit Price (Service Provider Currency)”

And move Column “Pro/Rated Wholesale Unit Discounted Price (Service Provider Currency)” after column (CL) “Total Vendor Price (Service Provider Currency)”

And move Column “Total Wholesale Price (Service Provider Currency)” after column (CM) “Pro/Rated Wholesale Unit Discounted Price (Service Provider Currency)”

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng, Xử lí dữ liệu, Kiến trúc phần mềm

Xem nhiều hơn: excel vba paste csv cells, networking vba excel database program, excel vba input function, search data csv excel vba, excel vba program front end example, simple excel vba open external program, search excel vba csv simple database, pricing custom excel vba inventory control program, excel vba write csv cvs, excel vba csv format, excel vba starting external program, excel vba program network multi user, excel vba program, write smile excel vba program, csv input format, excel vba select sheet user input

Về Bên Thuê:
( 6 nhận xét ) Kista, Sweden

ID dự án: #30119639

19 freelancer chào giá trung bình$38 cho công việc này

(474 Nhận xét)
8.4
(314 Nhận xét)
7.4
(460 Nhận xét)
7.3
(208 Nhận xét)
6.9
finecodervw

Hi, I am well versed with Excel VBA and can help on this. Please share the VBA program so that I can look at the existing code and also can correlate the instructions in Word document better. Looking forward to your Thêm

$35 USD trong 2 ngày
(224 Nhận xét)
6.8
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours

$20 USD trong 1 ngày
(147 Nhận xét)
6.2
(87 Nhận xét)
5.8
(76 Nhận xét)
5.6
(34 Nhận xét)
5.7
(28 Nhận xét)
4.8
maguirrer

Hello, I can help you to update the code for the desired output, please send me a message with more details and I can start working on it inmediately

$20 USD trong 1 ngày
(40 Nhận xét)
4.4
ShivaniGoyalsai

Hi I have 10+ years of experience in VBA programming and database management. I checked all the requirement and can make changes in the tool as per new requirement or new input file. I worked several similar project Thêm

$20 USD trong 1 ngày
(22 Nhận xét)
4.0
vw8193609vw

Hello, **Delivers high quality product on time** **Implements Coding Standards** **Write comments for easy maintenance** I have gone through the requirements, Please share the existing macro and new csv file. So that Thêm

$30 USD trong 2 ngày
(9 Nhận xét)
3.3
(1 Nhận xét)
2.4
cutepraba

Is the vba job still pending? I can finish it for you. description are nice and neat still its better to see excel file before start the work. please come in chat. have a good day.

$25 USD trong 1 ngày
(3 Nhận xét)
2.4
NoSonforhim

Hello, I read your project description and understand all. I have 20 years in Database development, Training, Database administration, System Analysis, Data Analysis using Ms. Word, MS power point, Ms. Access, Ms. Exce Thêm

$30 USD trong 7 ngày
(2 Nhận xét)
1.5
GulFaraz178

Hello, I am interested in this job. I am very confident that I can do this. I can Change excising Excel VBA program with a new CSV input format.

$20 USD trong 7 ngày
(0 Nhận xét)
0.0
sum1raj

I have read your Job description and I basically think its the right kind of work that I would like to put myself into. As with your description, I am very well acquainted with creating customized spreadsheet models (i Thêm

$20 USD trong 3 ngày
(0 Nhận xét)
0.0
junursal2

Dear Sir/Madam, I am an engineer by profession, but I love Excel, especially the logic & programming aspect of the application like data analysis, creating formulas, macros & Visual Basic for Applications (VBA) codes. Thêm

$20 USD trong 5 ngày
(0 Nhận xét)
0.0