In Progress

MS Excel - Copy and Paste (VBA and Macro required)

I have financial data in one format which must be converted into another report format

1. Copy data from Report format 1 (Spreadsheet 1) and paste to Report format 2 (Spreadsheet 2)

2. Spreadsheet 2 is password protected for both file and worksheet

3. Must firstly unlock Spreadsheet 2 (Password provided)

4. By way of mapping and lookup (eg value for Sales Type A in Spreadsheet 1, Sheet 1, Cell B10 to be copied to Spreadsheet 2, Sheet 3, Cell C20

5. Must convert numbers in Spreadsheet 1 which has decimals to whole(round numbers) first

6. Password protect the file, worksheets using same Password

The VBA, macro must be simple enough for me to update in future as there may be additional accounts ledger added in Report 1/ Report 2.

Skills: Accounting, Excel

See more: vba excel copy paste, excel copy vba macro, copy paste macro vba, excel vba macro copy paste, vba excel copy, vba copy paste worksheet, macro excel report format, worksheet in accounting, vba unlock sheet, unlock vba password, unlock vba, unlock protected excel, unlock password protected excel, spreadsheet accounting, simple accounting spreadsheet, password protected excel, ms lookup, future of accounting, excel vba ledger accounts, macro password protect worksheet, excel vba paste worksheet, me vba, excel 2013 vba, ledger accounting, vba excel macro

About the Employer:
( 3 reviews ) Singapore, Singapore

Project ID: #4264150

Awarded to:

mrbrave

VBA expert with great experience here.....Lets start and get it done in few hours now...Guaranteed.

$60 USD in 1 day
(61 Reviews)
5.2
sokhom168

I have done that every days in my jobs. My colleague calls me "King of Excel VBA" because I have made the excel tool to make their life easier. 1 days manual jobs can be done in just one click.

$30 USD in 2 days
(1 Review)
1.3
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet co More

$60 USD in 1 day
(38 Reviews)
5.3

33 freelancers are bidding on average $48 for this job

binaryromel

===== Excel expert here! Please check PM. =====

$45 USD in 1 day
(34 Reviews)
4.9
pierreho

Dear victorpw, this is really easy. I can give it to you within 1 hour or 2 max. Kind regards

$70 USD in 1 day
(24 Reviews)
4.8
slavisatosic

Hello, I am offering you to make this VBA macro by tomorrow. Please see private message for details.

$50 USD in 1 day
(32 Reviews)
4.7
samitXI

Please check your inbox. Thanks

$70 USD in 0 days
(15 Reviews)
4.2
jal540

I have done many custom Excel VBA projects and have excellent ratings.

$75 USD in 5 days
(8 Reviews)
4.1
madiy

Hi, A job can be done as required. Please feel free to contact with me. Thanks

$80 USD in 2 days
(7 Reviews)
3.8
cosconeaionut

Hi, If you need me , contact me. Best regards, Ionut

$50 USD in 1 day
(6 Reviews)
3.6
vikashgadia

we have more than 13 years of experience in excel vba

$45 USD in 0 days
(13 Reviews)
3.5
jaylancer43

Please check your PM..!!

$40 USD in 1 day
(6 Reviews)
2.9
excel4engineers

Please refer to my private message to get my exclusive offer.

$40 USD in 1 day
(7 Reviews)
2.9
buyaspreadsheet

Why pick me? Firstly, I have more than 7 years experience of designing and implementing advanced Microsoft Excel and VBA based solutions. Secondly, past employers have included both PricewaterhouseCoopers (PwC) and UBS More

$60 USD in 1 day
(5 Reviews)
2.7
epdailo

I have done many of these typs of macros before. Please consider my bid..

$30 USD in 7 days
(2 Reviews)
2.2
garykirsten

Hope to present a smile on your face on Project Completion. Quality assured.

$30 USD in 2 days
(1 Review)
1.0
nickdc

Expert here

$30 USD in 1 day
(0 Reviews)
0.0
prashantjain2056

Hi victorpw I can do the work in a short span of time. All them will be very easy to update. You can get this done in 3 hours.

$70 USD in 1 day
(0 Reviews)
0.0
rasowolf

Hello, I am ready for the work that you're offering. I know the good work in Excel and I'm ready to do the job give time 1-2 days. I did something similar a few months ago so i know how much time i need to get it done. More

$30 USD in 2 days
(0 Reviews)
0.0
ujay121

Experience of working on excel

$30 USD in 2 days
(0 Reviews)
0.0
dohko1911

Dear Sir/Madam, I have understood your requirements and put a summary in separate post to you. Please read and communicate with me. Many thanks. Dohko.

$35 USD in 4 days
(0 Reviews)
1.6
KKFA

I am a new freelancer an i am looking for a chance to approve my skills.I am an economist graduate from Athens University of Business and Economics with excellent skills in accounting and excel.I will do my best to do More

$60 USD in 5 days
(0 Reviews)
0.0
stroggo

I have many years of experience in conducting Excel/VBA based work (Financial or pure data entry), preparing Word documents, PowerPoint presentations (English). I can take on assignments of varying difficulty and finis More

$30 USD in 1 day
(0 Reviews)
0.0