Завершено

Reformat excel sheets.

Reformat Visa statements that are in excel format so 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 7 columns: transaction date, post date, reference number, transaction description, exchange conversion, Amount, Account, Location

There are 10 workbooks. One for each month. Each workbook has 3-4 sheets. Each sheet has 2-120 transactions.

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

There are 10 workbooks.

Here are examples of the initial- before and final - after. In this an average example. some have more merged cells some have less.

Квалификация: Excel, Excel Macros

Показать больше compare excel sheets, reformat excel spreadsheet, posting excel sheets web page, differences excel sheets, add form website, add form html joomla, customer service excel sheets, combining excel sheets access, company data excel sheets, updating excel sheets manually code visual basic, datasheet add form excel, vs2008 add excel sheets resources, form display select excel sheets vba, add form excel, excel add form spreadsheet

О работодателе:
( 0 отзыв(-а, -ов) ) Napierville, Canada

ID проекта: #21838208

Поручен:

datakillers

Hi, I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my c Больше

$80 CAD за 1 день
(177 отзывов(-а))
6.7

10 фрилансеров(-а) в среднем готовы выполнить эту работу за $118

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Больше

$200 CAD за 2 дней(-я)
(308 отзывов(-а))
7.9
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] Больше

$155 CAD за 3 дней(-я)
(89 отзывов(-а))
6.7
StormLion227

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 bid Больше

$140 CAD за 1 день
(28 отзывов(-а))
4.6
regphak

I'm a data entry specialist. I type at 45wpm. I love to help the client convert their PDF/jpg to MS-word documents, text, or excel. With a microsoft excel certification, I trust my excel skills and I will surely do thi Больше

$70 CAD за 3 дней(-я)
(8 отзывов(-а))
3.5
Amrsamra

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

$70 CAD за 1 день
(3 отзывов(-а))
1.6
Snail0917

Please give me a chance to work with you. Excel & VBA is a simple project for me. Hello sir! Nice to meet you. I am very interested in your project. I am a VBA expert. I have rich experience in this field. I am Больше

$100 CAD за 3 дней(-я)
(0 отзывов(-а))
0.0
gembern22

Hello there, I am very much interested in this job post. Please message me for more information. I am best fitted for this job since I am experienced and this is my line of job. Thank you!

$140 CAD за 7 дней(-я)
(0 отзывов(-а))
0.0
$72 CAD за 5 дней(-я)
(0 отзывов(-а))
0.0
$155 CAD за 3 дней(-я)
(0 отзывов(-а))
0.0