create Excel macro sheet + deconcatenate example raw data sheet

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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

Entrada de datos Procesamiento de datos Excel Visual Basic Visual Basic para aplicaciones

Nº del proyecto: #18852148

Sobre el proyecto

3 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

TechnoGuruu

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 Más

$50 USD en 3 días
(91 comentarios)
6.1

3 freelancers están ofertando un promedio de $79 por este trabajo

imteyazkhan85

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 Más

$88 USD en 1 día
(48 comentarios)
5.6