Đã hoàn thành

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.

Kĩ năng: Excel, Excel Macros

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Napierville, Canada

ID dự án: #21838208

Được trao cho:


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 Thêm

$80 CAD trong 1 ngày
(177 Đánh Giá)

10 freelancer đang chào giá trung bình $118 cho công việc này


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 Thêm

$200 CAD trong 2 ngày
(308 Nhận xét)

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] Thêm

$155 CAD trong 3 ngày
(89 Nhận xét)

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 Thêm

$140 CAD trong 1 ngày
(28 Nhận xét)

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 Thêm

$70 CAD trong 3 ngày
(8 Nhận xét)

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 trong 1 ngày
(3 Nhận xét)

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 Thêm

$100 CAD trong 3 ngày
(0 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)
$72 CAD trong 5 ngày
(0 Nhận xét)
$155 CAD trong 3 ngày
(0 Nhận xét)