Käynnissä

Update Custom VBA script to incorporate new CSV input format

We have an existing VBA script for Microsoft Excel that processes a CSV input and produces an Excel file as output. However, the format of the CSV has changed, and we'd like the script to account for those changes. (The CSV file is produced by Squareup.com.)

Changes:

* Many of the columns are shuffled around

* Some of the columns are re-titled

* Previously, a single column contained values for "Card - Swiped" and "Card - Keyed"; in the new scheme, there are two columns, "Card - Swiped" and "Card - Keyed", and the column contains the value of the transaction

* Previously a column titled "Payment Type" contained values for "card" and "cash" for method of payment; in the new scheme, there is a separate column for cash transactions, with the column containing (again) the value of that transaction

Attached files:

The BookSalesMaster (2) [url removed, login to view] is the current script. The [url removed, login to view] file represents the current CSV style, which is not compatible with the current VBA script. Finally, the [url removed, login to view] represents the ideal output of the VBA script.

Additions:

Depending on the complexity/feasibility, there are several additional modifications we would like to pursue.

* Modify script to also work on other (older/more limited) versions of Excel, LibreOffice, etc.

* "Financials" tab of output file should have limited column width (e.g., ~8) and be formatted for wrap text

* "InputData" tab of output file, if possible, should exclude all columns except, Date, Time, Payment Type, Sales, Card Brand, Device Name, Description, and Card Number

Taidot: Excel, Visual Basic for Apps

Näytä lisää: custom number format in excel, vba time, microsoft vba, microsoft excel VBA, excel 2013 vba, vba e, name format, libreOffice, input method, incorporate, excel vba script, brand new name, csv script vba, vba update excel, microsoft excel account, scheme excel, excel scheme, 2013 visual basic applications excel, excel csv tab, excel 2013 microsoft visual basic, csv update, xls visual basic, csv column format, 2013 excel visual basic, excel custom number format

Tietoa työnantajasta:
( 8 arvostelua ) Cambridge, United States

Projektin tunnus: #4245228

Myönnetty käyttäjälle:

MDavidCrompton

Hi, I have worked on creating specific Excel applications for 20 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. Example in PM. I am UK based, on GMT time, available on skype and a native E Lisää

100 $ USD 2 päivässä
(24 arvostelua)
5.1

24 freelanceria on tarjonnut keskimäärin 125 $ tähän työhön

mrbrave

Excel VBA expert here.....Lets start and get it done quickly.

80 $ USD 1 päivässä
(103 arvostelua)
5.7
nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b Lisää

140 $ USD 3 päivässä
(48 arvostelua)
5.6
cheapexcell

Hello, I am an expert in VBA with over 10 years of experience. Let's get started. Thanks, Alex

120 $ USD 2 päivässä
(42 arvostelua)
5.5
dominique1

No problem, I can make the changes.

150 $ USD 2 päivässä
(86 arvostelua)
5.2
slavisatosic

Hello, I am offering you to make these changes till the end of the week. Please see private message for details.

150 $ USD 3 päivässä
(55 arvostelua)
5.1
bob1982

Hi I am very good in Excel VBA

250 $ USD 5 päivässä
(65 arvostelua)
5.0
satsin7

Hi I am an experiened excel and VBA user and I can tell you that working on someone else's code is much more difficult than creating your new program. Anyway, i have seen the code and I think it can be edited to sui Lisää

250 $ USD 10 päivässä
(18 arvostelua)
4.6
parsermonster

Dear Project Manager, Software automation is my specialty. I would like to help you update your script. I have a special offer for you! Please check your inbox. Regards, Mitchell Allen

60 $ USD 2 päivässä
(10 arvostelua)
4.4
salih0vicx

I can update your current VBA code and adjust it to accept new values in certain columns. Looking forward to working with you...

99 $ USD 2 päivässä
(7 arvostelua)
4.4
MarlinSoftware

Hello, I have had a look at the excel and csv files you have made available and could make the changes for you without any difficulty.

50 $ USD 2 päivässä
(5 arvostelua)
4.4
FreeLAS

Excel/VBA Expert

70 $ USD 1 päivässä
(13 arvostelua)
4.4
naveenvarthaan

Hi harvardbooks, I checked the macro. Seems simple. I will modify it to suit new CSV file and also will include additional features as per your requirements. I am starting to read the macro so that I can modify a Lisää

75 $ USD 2 päivässä
(16 arvostelua)
4.3
vikashgadia

excel vba expert for u

150 $ USD 5 päivässä
(15 arvostelua)
3.6
cosconeaionut

Hi ,I can help you. If you need me , contact me. Best regards, Ionut

60 $ USD 2 päivässä
(7 arvostelua)
3.6
adim

More than 10 years experience in Excel and VBA.

130 $ USD 3 päivässä
(6 arvostelua)
3.4
ksnrajesh912

Hi please check PM

100 $ USD 1 päivässä
(4 arvostelua)
2.8
bubu77

Hi, Excel expert having 8+ yrs of IT experience. I have completed your last requirement. Please see your PM for more details.

100 $ USD 4 päivässä
(1 arvostelu)
2.0
razvancd

This is a simple script to modify. I have worked with extensive VBA scripts, for data collection and processing. As I am new to Freelancer, I made a very competitive offer which will help you get your job done chea Lisää

70 $ USD 3 päivässä
(0 arvostelua)
0.0
kvraghuram

VBA Professional with 6 years experience. i will complete the task with good accuracy

150 $ USD 10 päivässä
(0 arvostelua)
0.0
jozefk2

Hello, here is my bid. Task description match very well my experiences.

100 $ USD 3 päivässä
(0 arvostelua)
0.0