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
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
...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
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 softw...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.
Hi Ravi C., I 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.
...engineer. I need to get an Excel Macro developed for a large Excel sheet with a block of unique information consisting of 23 rows repeated 2100 times making the total number of rows to be about 48300. I need to add 3 rows of unique information to each block of 23 rows making it a total of 26 rows making the total number of rows 28x2100=54600. I need s...
Hi. I need someone to build an Excel VB Macro that, when run: 1. takes residential property query field data from Excel provided by the user (e.g. postcode, number of bedrooms etc) 2. runs a search in "[login to view URL]" based on that query and 3. copies the results from that web query back into the Excel sheet. For example, the query contain...
1) Windows 10 pro, Excel 2016 2) User should be able to identify target folder for process to run on all excel sheets in the folder as a batch. 3) Source data is Excel sheet (no more than 4 columns, and max. 100 rows) 4) Output is csv (12 columns, and no more than 100 rows) 5) Some columns in source will be split into many columns in output
Create a Macro in EXCEL: 1. Count the number of spelling mistakes in a cell eg: "The lanb is a world beest" Count = 2 2. List the all the spelling mistakes in a cell eg: "The lanb is a world beest" Mistakes= lanb,beest 3. Exclude the spelling mistakes based on the word count. eg: if we say letter count as 4 then if word "cat " is misspelled then it