...creating a VBA macro to search on 40-50 websites (fill search field, click search) and import results in my excel file. my macro is working for one website but i would like to work in 1 click for all websites My goals is to put a partnumber in a search field in my excel then click on a button and all data to be shown in another page. the data to impo...
Hello, I have a table in sheet 1 a...should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe via VBA or Macro. So that always when the sheet 1 1 is being replaced by a new report I click on a button in sheet 2 and it gives me what I want to see.
Necesito un programa (o macro) que actue en local, para ir a buscar 6 ficheros de GoogleSheets de un Drive (ubicación fija) y los descargue a excel. En excel se consolidan en una macro que ya está hecha. Después de consolidados y revisados, necesito otro programa que desglose por una variable (nombre del equipo) y copie las lineas de cada equipo d...
I have a column of 500 screenshots on a Google Sheet and need someone to retake the screenshots using Lightshots and reorder it on a second column. It's very easy but need it done asap, today would be awesome. Will have more work if it's done fast and well.
...the servers, once the test is completed, it will upload into one common repository folder, like [login to view URL], server2.log...etc server 1500, ...Now I have to save this logs in data base and i want to filter and also monitor the server like if server is stuck means it has to report and in log files we have to filter by error , by date , by name these strings
...1796 rows of data, each line all in one cell, like this: 06/12 JIFFY LUBE #1764 ENCINITAS CA 158.20 I need someone to go through and manually add a semicolon (;) between the date and payee, and then the payee and amount. So it looks like this: 06/12; JIFFY LUBE #1764 ENCINITAS CA ;158.20 Then to use the Date > Split text to columns function in Google
...operations will be performed with Excel. I would like to make a market price comparison for my e-commerce site. Please read the following notes carefully. Examine the sample file in the attached file. Important note, I will use this excel file for thousands of products 1. I will enter the product name in the product name in Excel. 2. I will enter our price
Program will do: 1-Unzip all the files in one folder 2-Merge all the txt files, make one excel file 3-Provide one excel file separated on the base of | symbol. Kindly check Example of the zip file need to unzip and a solution required at the end.
Need smart , experienced , Excel VBA coder , to START by writing a simple if then else macro . If last 9 to 18 rows is rising for x percent , then keep the U Verdict else Neutralise it with N . If selected will work at 50 dollars an hour for hedge funds and Binance Platforms . Primary Experience in VBA excel macro Essential . Secondary Experience
A small job. Need someone to make a excel-macro (or any other way it can be done) to do a series of calculations on a sheet of excel workbook. It's a small job. Details will be discussed.
I need a macro that can extract data from a PDF invoice to a Excel file.
i have an IOS app source code, i don't have much experience in Xcode, and App stor...an IOS app source code, i don't have much experience in Xcode, and App store, i need someone to add and generate firebase code and add it to the app (there is a tutorial) and sort the app and publish it in our store, the work can be done in our computer via TeamViewer
Want to scrap the gaming site - ONLY Macro expert bid -Want to scrap from VBA only . Please bid. Details will be shared with winning bidder.
I have ongoing work related to our previous project 'I need an Excel expert to help me find a solution to this problem via a formula or macro'
Quick description: I need an excel macro that compare key words in a matrix and if found an X in the matrix it should write this down. The script needs to run under excel 2010 Take a look at the attached excel test file detailed step by step: (Input) copy Range A to G -> (Output) A to G CounterOutputRow = 1 Loop (until (Output) Cell A of row <CounterOutputRo...
Extract data from a website with pagination. Need to get the data to Excel file. Not a complex data extract, but since it has pagination I am not able to get it using available tools. Developer with Excel VBA knowledge & web extracts should be able to do it easily.
Make me a Macro / VBA / Program To be able to Nest objects in corel draw into a given size area, and be able to dictate what gap to have between the objects, and also dictate the gap between the given area and the objects So in short I want to be able to for example: create an oblong box in corel draw, I have objects on the page that I want to nest
For an excel which can have 10-5.000 sheets there are values in each sheet (these values are always in the same cells). I want to add values to each sheet based on formulas I already have. These formulas should just be copy-pasted on every sheet After that, I want to add a 11 extra sheets with summaries of these existing sheets. Within each of
System sends email to 2 parties: Employer & Applicant I need you to create the email content. For example, include details like Full Name, position applied for, highest education level, work experience, contact number, email, etc. I know the exact table and column where you can find the info from. I need someone to help me code them in so that it shows up on the email. also the employer...
We need to create a Macro that Copy Pastes a Certain Value to Line 1 , then Copy Pastes a result from another sheet to the result sheet Under Line 2. ( We have this Macro in place Already. ) The important thing is to do this activity For "X" number of lines but each has to be run One after another otherwise the result cells will show wrong result.
I have to make a roster with 3 shift timings for about 10 employees. I need a macro created so that it automatically changes the shift timings of the employees along with week off's. I should also be allowed to make amendments to the sheet manually as the rostered timings/week off's of the employees may require to be changed. What I have written here
I need to copy data from one excel worksheet to several others. 1) All the Data to be copied from (Source) is on the "Copy From This Sheet" tab - Need to copy based on the part number column. - the only data from each row that needs copied is part number, description, list price, qty, Desc(%) - Note that these column locations likely will NOT change
I need to get a Excel macro developed that can match two Excel files and find matching lines based on amount. The macro should then take all rows that it finds matching and list them under each other. and the ones it did not match it should line up in another column.
I need a small application that will do the following on Mac and Windows: 1) Accept pasting a mid sized body of text into it (up to 500 words) 2) Remove punctuation and symbols 3) Remove stop words 4) Remove numbers 5) Count how many times each unique word occurs 6) Find all unique words 7) Output an alphabetised list of all unique words separated by commas. 8) Output a list of words organised by...
MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB error on innodb table witk mysql 5,6 version.. error. they say there is a bug in this version.. i have 230 rows in table, and wont let me add any new varchar row.. its vps server. mysql can be configured.. i cant add new
I have a program I am running and would like to record my finger gestures and be able to replay them with exact precis...running and would like to record my finger gestures and be able to replay them with exact precision. I am using a Dell Precision M3800 w/Touch Screen. I would need to record multiple macros that I can play back with exact precision.
I want an experinenced with artcam 3d designer to make 3d stl files, preferably with artcam program.
I have 500 fonts, I want to sort this fonts in excel sheet according to viability to use in commercial designs. You can search google font Please download the file and place bid only if you can do it File: [login to view URL] I will negotiate in price
..."completed information". In the Examples: Let null represent "not required" and 1 represent Required In Example 1 ideally I am looking for a Scenario that matches the required data points in this case: Required( marked by "1"): First Name, Address, Province,Postal Code, Phone Number Scenario 2: Does not satisfy this example; Address,Province, Postal