Sheet 1 : declaring the values like %EMP_ID1% - 100 , %EMP_ID2% - 101 , Sheet 2...the values like %EMP_ID1% - 100 , %EMP_ID2% - 101 , Sheet 2: Lot of datas Work: VBA Macro should search %EMP_ID1% in sheet 2 and replace with 100 Note: If we change %EMP_ID1% to 700 from 100 in sheet 1 it should automatically change in all sheet when we run VBA.
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 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.
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 ...the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating records in a new spreadsheet by SKU # and put output on Tab 3 3. Transform the data for consumable format.
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.
Hi Ravi C., I noticed your profile and would like to offer you my project. We can...noticed your profile and would like to offer you my project. We can discuss any details over chat. I have a long list in Excel of contacts that needs to be cleaned based on a VBA script that runs through and formats the lists by aligning up the name and email address.
Looking for someone savvy with VBA (Excel) - essentially good with macros, and linking this to Word. In need of a workbook that can serve as: 1. an upload tool (for a list of questions) 2. a db sheet Q&A format, for the search tool to search for matching answers to the input questions 3. a functionality that will take the matching questions
The original excel file has one sheet and output should have 3 additional sheets than the original: 1) extra sheet1 (just a select...columns from original) - date filter 2) extra sheet2 (some pivots should be created in this sheet) 3) extra sheet3 (a new selection of column from original) - date filter 4) vba code should have comments and be explained