Käynnissä

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.

Taidot: kirjanpito, Excel

Näytä lisää: vba excel copy paste, excel copy vba macro, copy paste macro vba, vba excel copy, vba copy paste worksheet, macro excel report format, worksheet accounting, vba unlock sheet, unlock vba, unlock protected excel, spreadsheet accounting, simple accounting spreadsheet, ms lookup, excel vba ledger accounts, excel vba paste worksheet, me vba, excel 2013 vba, ledger accounting, vba excel macro, vba excel, spreadsheet excel accounting, simple macro, sales excel, macro vba, ledger

About the Employer:
( 3 reviews ) Singapore, Singapore

Projektin tunnus: #4264150

Myönnetty käyttäjälle:

mrbrave

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

60 $ USD 1 päivässä
(61 arvostelua)
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 2 päivässä
(1 arvostelu)
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 Lisää

60 $ USD 1 päivässä
(38 arvostelua)
5.3

33 freelanceria on tarjonnut keskimäärin 48 $ tähän työhön

binaryromel

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

45 $ USD 1 päivässä
(34 arvostelua)
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 1 päivässä
(24 arvostelua)
4.8
slavisatosic

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

50 $ USD 1 päivässä
(32 arvostelua)
4.7
samitXI

Please check your inbox. Thanks

70 $ USD 0 päivässä
(15 arvostelua)
4.2
jal540

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

75 $ USD 5 päivässä
(8 arvostelua)
4.1
madiy

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

80 $ USD 2 päivässä
(7 arvostelua)
3.8
cosconeaionut

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

50 $ USD 1 päivässä
(6 arvostelua)
3.6
vikashgadia

we have more than 13 years of experience in excel vba

45 $ USD 0 päivässä
(13 arvostelua)
3.5
jaylancer43

Please check your PM..!!

40 $ USD 1 päivässä
(6 arvostelua)
2.9
excel4engineers

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

40 $ USD 1 päivässä
(7 arvostelua)
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 Lisää

60 $ USD 1 päivässä
(5 arvostelua)
2.7
epdailo

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

30 $ USD 7 päivässä
(2 arvostelua)
2.2
garykirsten

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

30 $ USD 2 päivässä
(1 arvostelu)
1.0
nickdc

Expert here

30 $ USD 1 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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. Lisää

30 $ USD 2 päivässä
(0 arvostelua)
0.0
ujay121

Experience of working on excel

30 $ USD 2 päivässä
(0 arvostelua)
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 4 päivässä
(0 arvostelua)
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 Lisää

60 $ USD 5 päivässä
(0 arvostelua)
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 Lisää

30 $ USD 1 päivässä
(0 arvostelua)
0.0