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
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.
• Excel financial models.
• Excel dashboard designing.
• Excel Solver.
• Microsoft Access.
• Excel calculators.
• Excel vba.
• Excel Tracker.
• Excel macro's.
• Visualizations, Chart's, Table's.
• word macro's.
I have ability to do your project within your deadline, I need some discussion to make the things clear.
Thanks.
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 and I'm sure I can give you good results.
If you reward me for your project, you will get good results.
look forward to working with you.
cordially.