create Excel macro sheet + deconcatenate example raw data sheet

I need the following job completed in under 48 hours (by Monday @ 12PM, Noon CST in US). This should take someone good with macros under an hour I assume..

Make a excel macro/program that I can use in the future for clients that does the following…and use the sample sheet (attached) as proof it works. If the sheet cannot handle the exceptions, at least I need the sample sheet to be correct (even if some manual work must be done).

1. Move “multi-record” rows into just 1 row per record (begins with date, then item/description, then finally $ Amount) in spreadsheet under the following Tabs. Some of the data bleeds into the next row and others are disjointed due to the way they were copied in from each page from PDF statements. **

a. Q_Chase Bank C

b. Q_Chase Bank D

c. P_Wells

d. ZM_Wells

2. Deconcatenate each new row record into one of 3 columns: Date, Item/Description, $ Amount.

3. After #1 and 2 above, make sure the following:

a. Sheet can be sorted by date.

b. Item begins with item description (not extraneous symbol / letters).

c. Amount is a usable number with Excel (not text).


**Also, on some deposits (noticed on ZM_Wells tab), a $ Amount will be followed by a space and then another $ Amount. In these cases, please eliminate the 2nd $ Amount. Also, sometimes a 2nd date is included within the Item/Description column. So:

11/27 Online Transfer to Kurtis R Checking xxxxxx2019 Ref #Ib05G7Nsfr on 11/27/18 4,000.00 500.00

Should be:

[column 1] 11/27 [column 2] Online Transfer to Kurtis R Checking xxxxxx2019 Ref #Ib05G7Nsfr on 11/27/18 [column 3] 4,000.00

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel worksheet separator, split excel sheet into multiple files based on column, how to split excel sheet into multiple worksheets, split excel sheet into multiple sheets based on rows vba, how to split data into multiple workbooks based on column in excel vba, split excel sheet into multiple workbooks based on column, macro to split data into separate files, split excel sheet into multiple sheets based on column value, excel macro copy selected cell data cell, excel macro add row fill data, excel macro visit website pull data, excel macro import file parse data, excel macro choose tab paste data, excel macro input large amount data, excel macro doesnt work paste data, excel macro copy find paste data, create excel macro check active directory account status, powershell create excel macro, excel macro download yahoo finance data, create excel macro run powershell script

About the Employer:
( 44 reviews ) Dallas, United States

Project ID: #18852148

Awarded to:


Hi, I have checked you attached file and project description. Please share your PDF document and I will make these Excel sheets wit data with high accuracy. Quality work with high accuracy and 100% customer satisfa More

$50 USD in 3 days
(62 Reviews)

5 freelancers are bidding on average $91 for this job


Hi there, I have understood your requirement, I have done similar job done for one of my retail client. He was copying data, but not all were coming into same row, and thus I have built one solution for him. Howev More

$88 USD in 1 day
(34 Reviews)

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$50 USD in 1 day
(21 Reviews)

I am Muhammad [login to view URL] of Business Administration (MBA). My skills includes Thesis writing, Paper writing, Report Wriing , Technical Writing, Business Plan and Research Proposal related MBA Finance, HRM,Marketing a More

$100 USD in 3 days
(0 Reviews)

Exce Macro Expert Dear Sir. I've read your job very carefully and understand what you want. I'm a Senior developer with 10+ years experience. I've special skills in Web Developing and Mobile Any of your requireme More

$166 USD in 2 days
(0 Reviews)