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.

Evner: Excel, Excel Macros

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Napierville, Canada

Projekt ID: #21838208

Tildelt til:


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 Flere

$80 CAD på 1 dag
(177 bedømmelser)

10 freelancere byder i gennemsnit $118 på dette job


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 Flere

$200 CAD in 2 dage
(308 bedømmelser)

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] Flere

$155 CAD in 3 dage
(89 bedømmelser)

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 Flere

$140 CAD på 1 dag
(28 bedømmelser)

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 Flere

$70 CAD in 3 dage
(8 bedømmelser)

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 på 1 dag
(3 bedømmelser)

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 Flere

$100 CAD in 3 dage
(0 bedømmelser)

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 in 7 dage
(0 bedømmelser)
$72 CAD in 5 dage
(0 bedømmelser)
$155 CAD in 3 dage
(0 bedømmelser)