need a macro that selects only cells with number format (including cells that display as text but actually have a number format e.g. cells with "n.p" ) and copies all number format cells from the input tab to the output tab. Have tried using the goto special function but it won't select the "n.p" cells or cell with a minus figure. plus goto special
I want build a scraper in python to extract list of companies with details details of each company. Details I need are: Company Name, Website, Address, Phone, Revenue Range, Revenue, Industry and SIC Codes. Max budget is INR 4000
...currently this Java retrieves elements from a .json file. These elements create a photo gallery developed with JQuery. Requiments: Tomcat 9 and Java 8, PostgreSQL 10 1) EXTRACT FROM POSTGRESQL ***************************************** I want Java to query PostgreSQL and get the elements to create the gallery directly from PostgreSQL. The PostgreSQL
I want to extract list of companies with details details of each company. Details I need are: Company Name, Website, Address, Phone, Revenue Range, Revenue, Industry and SIC Codes. My budget is Rs. 4000
I need to modify my python script which is of 100 lines. This script extract data from json file and creating a csv file. We have to modify it and Have to Add some logic
I have a mysql DB which I want to use to create a mailchimp database. Before importing it I want to clean it up a bit and create a new column based on a simple calculation quantity x 12 = Standard quantity x 26 = Expert Need this done right away, should only take a few minutes if have the skills and the tools! Lets chat via DM
Combining several files with certain layout (the data will keep adding every month until 1 full year ) do data processing by macro , presenting summary using pivot and chart
Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based
...some data has been exported to a .SIM file from an Energy Modeling program. I need to have the .SIM file parsed and *some* of that data exported in a format that can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull
I received 2 videos in Facebook Messenger. Each is under 1 minute in length. I'm not able to download them. I need you to download both videos and send them to me in .mov or .mp4 format. I need this done in the next 20 minutes. I will forward you the video messages in Facebook Messenger (you will need a Facebook Messenger account to do this work). Please put the word NOW in your bid if you ca...
Hello, I have a bunch of logs and I would like to extract information from it: EXAMPLE 1: mdm-tlv=device-platform=win, mdm-tlv=device-mac=d4-25-8b-db-aa-bb, mdm-tlv=device-type=LENOVO 20JVS04J00, mdm-tlv=device-platform-version=10.0.16299 , mdm-tlv=device-uid=28A903C8C190CE102E1A29DFC2A231921911ED16D377E31CD235648A6BC2A41B, audit-session-id=0acd0164050200004b6359c5
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system. Issues to be resolved: 1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable) 2) avoid memory leaks 3) ensure that data imported from source CSV's is fully loaded before
Needing a quick macro developed that will use one source of data and compare it to an Excel workbook with multiple sheets. It will identify matches within these sheets and change the matching text in GREEN and the non-matching text in RED. Must be able to accept uploaded information, not cut and paste.
...Wikipedia links. These links refer to lists of people e.g. 'Famous people from Cuba' For these pages, I just require the list of names on the page to be copied and pasted into a Excel spreadsheet next to the search/hyperlink used to find them e.g. Desi Arnaz I Famous People From Cuba Fidel Castro I Famous People From Cuba For some of the pages
...a report in Excel with 4 different Graphs p/sheet and those graphs are taking the information from the same file with all the data by day included in the same sheet. I need to have a button that says "Weekly" and move all the information of the graphs from Daily to Weekly, of curse summarizing and combining the daily data into weekly data. another button
Hello, budget is 5$!!!!!!!! I want you to extract all emails from 1 site with your bot, software what else..
I need to get the contact information in an excel file for the above retail outlets in the format: Business Name; Phone Number; Email address; Website; address
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
...of websites for a given date range. Expected capability of the module to extract data with input as different website names. The output is the generation of an excel file with which has the link of the article, text data, and corresponding figures and charts along with the data and time stamp of the post of article and author name. This module is part
I am after a program that can extract 4 fields from each PDF put into a directory. I am not after a data entry person I am after someone to write a Utility which reads all pdf's in a directory and extracts 4 fields from each and adds it to an excel spreadsheet. The four fields are Date of Invoice, Invoice No, PO Number and Total Sample PDF Provided
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
I would like to take the information off of this page (weekly) event info + picture of event -- [login to view URL] and place it on a new wordpress site. So when you visit tht page and hit the picture the infpo for the event will appear in the next screen. Example: [login to view URL] (the pic and most of that info) Everything should be done automatically
click each link and indicate in column 'i' with an 'x' if link is leads to photo. If error occurs and link cannot be followed then leave column 'i' blank. Link is in column 'h' EXAMPLE in file: row numbers 228,645 & 228,644
create a simple excel macro that looks up a stock ticker online and place a current price value in an adjacent cell. to have a refresh button on the excel sheet that allows for multiple refresh of multiple cells with one click.
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)
...and returned - HTTP 401 Unauthorized There are ways to get hold of these json data files because mobile apps in Play store (e.g. Live Singapore Football) is able to update match odds through some means. Requirement You will need a local VPS (Singapore IP) to extract data from sgpools because website blocked by IP region. Attached is a sample of all
I need to build a bot or software that can help me automatically extract active members from any telegram group and automatically Add them to any telegram group or telegram channel ... Extracting and adding up to 20000 members per day
For this project we want someone to extract data from betfair basic historical data packages into csv files. Only soccer packages will be used. The files are packed as TAR files. The files with the data are in JSON format. Since the packed files may contains 1000 of files itself we would like to have a user friendly method for handling these TAR files
This website here has 4 directories i would like all the files of, i cant seem to download the php files within because it shows empty when i download. I want the files because the company used a template and i want to use there layouts, and see how they have changed the template, etc. Below are the links i want to download. [login to view URL] [login to view URL] [login to view URL] [login to ...
I am looking for a simple bash script that can parse a csv file, extract specific files use these fields to populate a mysql dB via the bash script. One field will be a date timestamp. One a time timestamp and then 2 other fields.
We use the following macro for gathering information from invoices on spreadsheets and compiling them into a larger database type spreadsheet. The Macro has been working fine for years but has stopped working in our last update (running office 365). Macro gets stuck on this Err5 With Application ChDrive (Left([login to view URL], 1)) Hopefully
Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #). I need a blank spreadsheet where the user can input the following: Input: Base #, Sensor # (or all sensors connected to that base), Date (single date).
Hi I need to build an API to extract all products with all attributes from Shopzilla sites Is there anyone who could help for this API Please send me your best offer Thanks Adil
I need to extract data from a website and store it on a table using PHP/MySQL. the list represents a list of races, we need to load the page serverside extract the data, format it and push it to the DB. I have explained the requirements here: [login to view URL]