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 email and save & sen...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
I have a spreadsheet that needs to have the address and direction moved from street column to address# column. I have a sample JPG showing the first 12 entries completed. You will continue in the same fashion. Some addresses have a North, South, East or West or N,S,E or W some do not have any. Total of 830 rows in file. Thanks
Hi , looking for a "To Do list in excel that sends emails with tasks to perform " to contractor and client teams.
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.
I have a excel sheet of companies data. It has columns like Company Activity Word. Now I have such 4,12,718 rows but the data is repetitive. I wanted to extract only unique activity words out of them, For example: 1) AGRI AND DAIRY FARM 2) AGRI AND DAIRY FARMS 3) AGRI AND DAIRY PRODUCTS
I am looking for someone smart, who can write Excel vba code, starting immediately. Details will be shared with selected candidates.
...measurements(3 measurements with a total of 9 values), BP apparatus manufacturer name. Objective type questions will be provided with drop-down menu in excel sheet itself. Data of each sheet has to filled in a column of excel sheets which already have the survey questions in 31-34 rows. One can try and check their speed and comfort of entering the data to spreadshe...
i have an access form/switchboar...pushed. if the form is already open and i hit another button, it doesn't refresh the report using the new query. i guess it sees it's already open so it doesn't continue. vba code to open report is: [login to view URL] "rptProject", acPreview is there a way to have a report refresh/update itself if it's already open?
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...