Færdiggjort

Make VBA macros for excel spreadsheet

Video and Instructions below - sample raw file attached

[login to view URL]

1.

Delete columns G to M

2.

Delete column A - Video says delete cells but it leaves the column in Date format, delete column shown a bit furthr in video

***(Alternative 1 if possible - I can easily do the save myself

save as to xlxs ( you can leave this out or put it as first step if possible )

***Note for Step 2.

Ignore the the fill of column A as mentioned before as it is date formatted so I deleted it

3.

Insert new Column A

3a.

Enter 1 2 3 etc to end of data in Column A

4.

Data Sort column H (Fixp) Largest to smallest

4a

Delete all rows with scr in them

5.

***Not shown in Video***

Data Sort Column G (100)

5a

Delete all rows that do not have a value in this column

6.

Back to Video

Data Sort Column A smallest to largest

7.

Insert Column before Columnn D (TN)

7a

Enter Formula =B2&C2 and copy down

8

Insert Column before Column E

8a

Enter Formula =TRIM(D2 and copy down

9

Copy Column E

9a

Paste as Value into Column D

9b

Delete Column E

10

Insert Column before Column F

10a

Enter Formula =D2&E2 and copy down

10b

Copy Column F and Paste as Value into Column F

11

Copy Column D to Column Q

11a

Go to Data and Remove Duplicates

12

Enter 1 into Column R (R2) and copy 1 2 3 etc to end of data

13

Insert Column before Column E

13a

Enter formula =VLOOKUP(D2,R2:S48,2,0)

13b

Insert $ signs into formula =VLOOKUP($D2,$R$2:$S$48,2,0)

13c

Copy this formula down to end of data

14

Copy Column E and Paste as Values

15

Delete Columns R and S

16

Insert 9 columns in front of Column A

17

Copy Column P to Column H

17a

Delete Column P

18

Insert 5 Columns before Column J

Evner: Excel, Visual Basic, Dataindførsel, Databehandling, Visual Basic for Apps

Se mere: useful vba codes for excel, how to create a macro in excel 2010, excel macros for dummies, vba excel examples, how to use macros in excel, macros in excel for beginners, how to create a macro in excel 2016, how to create a macro in excel 2007, writing vba macros excel 2007, vba macros excel issue incremental number, vba macros excel increment number, access vba manipulate excel spreadsheet, vba macros excel, access vba data excel spreadsheet, searching macros excel spreadsheet vbs script, make vba project excel, vba import excel spreadsheet accesss, vba macros excel attach, vba macros excel hot lines count, vba macros excel jobs

Om arbejdsgiveren:
( 19 bedømmelser ) Tugun, Australia

Projekt ID: #22505142

Tildelt til:

il8677

Hello, I have a lot of experience with excel and macros. I'm sure I could do this for you within an hour.

$8 USD / time
(3 bedømmelser)
1.6

5 freelancere byder i gennemsnit $6/time for dette job

usmanhassan123

I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects of: • Excel Automation. • Excel Reports system. • Exce Flere

$8 USD / time
(77 bedømmelser)
6.2
webanis

Hello, I am very interested in your job project. I am really looking for this type of project since a long time as a freelancer because I have a rich experience in this field. I think this project suits me perfectly a Flere

$5 USD / time
(26 bedømmelser)
4.2
ravinderkumar248

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw Flere

$5 USD / time
(6 bedømmelser)
3.0
samssmm

Hello there I will create the macro. if you want to get done your task perfectly then please contact me. Thanks.

$2 USD / time
(0 bedømmelser)
0.0