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.
I need to do different operations with databases, for example eliminating duplicate article numbers while adding their quantity to the remaining single item number
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
Read from consolidated source excel and write to individual excel template for each day. total reports to be 90 for 140 financial intruments
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 some work, in an Excel spreadsheet. Looking for VBA into spreadsheet. Want to capture data (back and lay prices)from Bet Angel (Betfair) at chosen optional specific time intervals eg maybe every 5 minutes or 1minute. Therefore eg 1.00pm capture back prices of all horses and put in cells A1-A10 1.05pm now capture back prices of all horses
i need my excel sheet to retrieve data based of a client date of birth and gender from this website [login to view URL] im trying to get their state retirement age.
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
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.
I want to build a standalone software program that incorporate VBA, SQL and SAS code. Possibly Code from R but not imperative. Basically I would need the shell of the program, and I would want to add VBA or SAS code to run models. I want one software program that can compute graphs, charts, stats, export to powerpoint or excel, etc.