Reformat Excel Sheet Project 2

Reformat excel files in a format such that they can be uploaded to Quickbooks.

For each sheet (card ) of each workbook ( monthly statement)

1)Unmerge all cells in sheet.

2)Expand unmerged columns

3)Convert data to text so reference number is not lost as an exponential.

4)Expand data using text to column where necessary.

5)Move expanded data to like-columns to form only 10 columns: transaction date, post date, reference number, transaction description, exchange, currency, Amount, Account, Location

There are 5 workbooks. One for each month. Each workbook has 4-7 sheets. Each sheet has 2-50 transactions.

6)Add a new column. Strip off the location in the description(eg. VA, CA, WA ) and paste into the column:

7)Move the exchange rate to the corresponding column for the transaction of the row above.

There are 5 workbooks.

Here are examples of the initial- before and final - after files from one sheet of a workbook . In this an average example.

Compétences : Excel, Excel VBA

en voir plus : project excel sheet, project numbering excel sheet, project status maintenance excel sheet template, project budget excel sheet, excel portfolio project sheet, free project budgeting excel sheet format, ready project free excel sheet, excel sheet project status data sheet, project manager workload excel sheet, project update excel sheet, microsoft project convert excel sheet, excel sheet roller blind project costing, excel sheet asp project, actual excel sheet containing project, project data excel sheet, data entry excel sheet job project, excel sheet project management budget, import excel sheet mysql java excel api, copy names from plotted map points to their correct excel sheet category.--2

Concernant l'employeur :
( 0 commentaires ) Napierville, Canada

Nº du projet : #21856240

Décerné à:


Hi, I have good data entry and excel skills with years of experience as well as I have completed a great number of projects for Excel and Data Entry. Your work will be delivered on time and will be responsible till you Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% CAD en 1 jour
(179 Commentaires)

7 freelance font une offre moyenne de $98 pour ce travail


Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(29 Commentaires)

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(14 Commentaires)

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(12 Commentaires)

it`s an easy project and can be finished in less than the determined time. I`m interested in your project pleas contact me to discuss the other details thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(4 Commentaires)

I'm very happy to bid on your project. I read your description carefully and am very interesting in your project. I can start right now and I can confirm high quality. If you hire me,I will do my best for your job and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(0 Commentaires)

Hello, Sir. I read your opinion seriously. I have experience of 7 years and done similar projects before. As a man of trust, I can develop your website with full perfection. Let me go on, you can get the best project t Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(0 Commentaires)