Needs to hire 2 Freelancers
I have a set of data.
Column A has some values (Parent ID's) for a company (values in column C)
For each Parent ID I have a set of children, which must be added to the table.
In Column G for each children, I need the parent ID and in C I need the company # of the parent ID.
Then for a certain Special Parent ID I need to replace the value in Column G for a fixed value.
And for each of these special parent ID's in the database, I need a new row with a fixed set of values.
This can be achieved in 3 steps with Formulas such as VLOOKUP... or ideally with a macro which I can reuse. I can provide you the data columns in Sheet 1, where the macro gets the data from to create the database in sheet 2.
54 freelancers are bidding on average $367 for this job
Hello, As an experienced VBA developer, i am very much interested to create the required excel macro to do this task. Please send me the example file. Thanks
I have a experience in asp.net, MVC, web API, c#, SQL, entity framework,linq, razor view (Cshtl), html, bootstrap,Angular JS, Jquery, Json,XML, reports (PDF,xls, crystal, rdlc,ssrs).
Hello, I can help you with the macro to complete the missing columns of the database, but please send me a message with more details and I can start working on it inmediately
hi I have more than 10 years of professional experience in sql development and optimisation and worked in more than 300 projects in different database like Oracle,mysql/db2/ [login to view URL] discuss your requirements
I can do this. I have good command over Ms excel especially pivot table, charts, advance formulas, formatting etc. Please inbox me for detail. Thanks Abdul Haleem