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
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 Plus
5 freelance font une offre moyenne de $91 pour ce travail
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 Plus
Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;
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 Plus
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 Plus