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
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
[column 1] 11/27 [column 2] Online Transfer to Kurtis R Checking xxxxxx2019 Ref #Ib05G7Nsfr on 11/27/18 [column 3] 4,000.00