The freelancer will receive an Excel list with prices to 31 stocks over a period of 3 years. You are asked to create an application, that performs analysis, using Excel and VBA. The number of analysis methods used should be dynamically selectable. The uploaded image shows an example for the GUI. The application should include the methods of technical
when a (certain) email is received, combine the attached pdfs (two or more) into a single pdf, save and name the new pdf based on the original e...(two or more) into a single pdf, save and name the new pdf based on the original email and save & send the new pdf as an email attachment. Email program is Outlook, looking for rule based and vba solution.
i have a multiple vendors files in excel with huge date. i want to club all sheets into my own data sheet and and select my requirement in dashboard and report would generate as per my selection . Example ; Product 1 is there in three different vendor list and it should generate report with Product1 details of all vendor and highlight the lower price from the vendor details.
Got a VBA macro that's pulling duplicates into excel. There are no duplicates on the original website. Some problem is causing it to repeat some data. Need you to fix this behavior so that the macro only gets the data as is.
Auto-install in restricted environment Window 7 without administrator rights Build a new function from an existing code. The reason is I want one installer. And this installer skips the administrator UAC and able to install. The new function is in document below.
I am looking for someone smart, who can write Excel vba code, starting immediately. Details will be shared with selected candidates.
I have an item spreadsheet that has : Item, Color, Size, Qty on Tab 1 (the data on this tab has multiple repeating records) SKU, ,Item, Color, Size on Tab 2 (the data on this tab is a lookup table) I need a macro to run and do the following : 1. Do a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating records in a new spreadsheet by SKU # an...
I have an Excel VBA software program that was developed by a freelancer in 2012 (it is a business strategy training simulation) and now need to update and improve the programming. The previous programmer is not available so seeking another resource.