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 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?
... 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
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.
I am a telecom 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
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 contains information
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
This is for a residential design firm We require bathroom vanity elevations, built-in details prope...sketch form, layout currently in Revit Would like the work returned in CAD and PDF format with appropriate scale/location/company/date ***Must have experience drawing built-ins*** Work required immediately (with possible edits over the next month)
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
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