En cours

VBA Macro Project

As per the Macro Project word doc attached in reference to the spreadsheet attached also with the 3 tab sheets

Aim: 2 part Macro to be programmed in excel VBA

Part 1: There’s 2 parts to this macro, on the main page has 2 macro buttons, when the Macro Part 1 button is clicked the macro looks for the value on column 1 in the tab “Vlookup Values” and looks for the value in the first column in the tab “ Data File” when each value from the Vlookup tab is found in the Data file tab the corresponding matching row (i.e. the whole row) is copied from the Tab “Data File” and pasted into a new sheet with the exact same columns header as in the “Data File” Tab.
Part 2: The Macro Part 2 is the second part of the macro which works on the new sheet created with the pasted rows from the macro part 1 above where once this macro is clicked the new Tab sheet which the data was pasted into is arranged so that the macro looks up the columns with the header “J”, “X”, “K” and “V” and keeps those columns and deletes the remaining columns. Please note that the column order can be in random order so it’s important for the macro to scan the column headers for the actual title ie “J” or “V” etc and keep those columns and delete the other columns.

**Important considerations when programming the macro the format of each column can be anything so the lookup values and different columns could be dates, names, numbers, or a combination of numbers and text etc. so it’s important for the macro to be able to recognise what the different format is in the lookup column and work with it without having an error.
**Also it’s important for the macro to work even with null values throughout the spreadsheet as there will be blank rows or cells empty values etc. so the macro has to function even with null data values it just has to ignore the null values and go to the next value.

Compétences : Excel, MySQL, SQL, Visual Basic, Visual Basic pour les apps

Voir plus : excel macro to word, small project macro vba, macro project allocation vba, vba save excel sheet text word doc, import msp project data excel macro vba, excel add reference ms word vba, automatic reference macro vba, vba open close excel workbook word macro, excel macro vba find word, macro vba file text word, project 2007 html export macro vba

Concernant l'employeur :
( 7 commentaires ) sydney, Australia

N° du projet : #8504718

Décerné à :

rengrish

I have understood the job. I can provide you solution within 30 mins . I have 10+ years of experience in Excel & VBA. Please check my past reviews. I understood the requirement thoroughly. I can code instantly. Kindly Plus

45 $ AUD en 1 jour
(81 Commentaires)
5.2

6 freelance ont fait une offre moyenne de 58 $ pour ce travail

twalker2678

I would be interested in discussing this more with you. I reviewed your sample sheet, but not sure what you want the macro to do. Please view my profile and PM me if interested. Thanks!

55 $ AUD en 3 jours
(13 Commentaires)
3.8
surekash7096

I have the expertise in writing scripts and macros using VBA in Excel and can do this task quickly and accurately

77 $ AUD en 2 jours
(15 Commentaires)
3.8
jnekam

A proposal has not yet been provided

55 $ AUD en 1 jour
(5 Commentaires)
3.6
citijayamala

expert in excel macros VBA vlookup concepts and experienced MBA finance

66 $ AUD en 3 jours
(15 Commentaires)
3.9
go4mugam01

We are a Team of Well experienced Engineers, Researchers and MBAs. We offer the following services to you. Academic Writing : HND Assignments , GCSE/GCE O+ and A+ e-Portfolios and Technical Reports , All Windows/Li Plus

147 $ AUD en 3 jours
(1 Commentaire)
1.8
pharaolancers

I work on macros for 2 different companies. I master almost all types of basic calculations in addition to macros for miscellaneous applications. I have seen the attached spreadsheet and I can work on it in 2 days.

50 $ AUD en 2 jours
(0 Commentaires)
0.0