Create a tool (eg. Webapp or Excel-macro) that can load a list of URLs and return number of hits on 5-10 Keywords pr site. Purpose: The tool should help qualify which websites are communicating about a specific topic. Eg. Return hits on the keywords "Events, Conferences, Seminars, Expos, Calendar" on the loaded list of keywords. Design: Not important
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 on sales.
...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 just the data needed that was started that doesn't work. I need an Excel macro expert to get this working. The attached .zip file has the sample data - a couple of the
Macro: ORDERMENTUM_IMPORT Purpose: To open a file exported from the ordering website and populate the the excel order spreadsheet with quantities matched to the product codes for matching customers. Pre-processing: Prior to populating the spreadsheet, a number of checks should be performed on the exported data. Any negative results of the checks should
Hi there, I would like to build a web based drag and drop solution. The website must allow you to create cards and define the calculation logic. The cards can be in different tiers on a timeline, So if Card A has 4 cards under it (AA, AB, AC, AD) the total calculated amount of each card must generate a total in Card A. If one of the cards are removed
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.
Hello there, I want a JS function to change the parameters values of a URL, the URL has multiple parameters. Some will be changed when a drop down item selected, radio options, checkbox and bootstrap switch on/off. <a id="buy-link" class="btn btn2 grad-btn order_configured_vps" href="/[log ind for at se URL]
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.
...management, freelancing, video-on-demand e-learning platforms across many industries: fashion, toys, travel, electronics e-commerce. Slide 1 – Tool Set Box Menu (from menu drop down bar) – include icons: tasklist, scrum task board, mind map, journey map builder, calendar, Gantt chart, layout, swim lane diagram, flow diagram). Menu dropdown bar to include
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)
I need a professional resume Writer. if any One please call me or drop me a message on my no. [Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions]
I am developing a few reports in excel that requires mid to advanced level of expertise in Excel and Macros. I have mid-level ex... However, I need someone to guide through the report building process. The work will be on an ad-hoc hourly basis. I am looking for advanced level expertise in excel and macro development. Power BI expertise is a plus.
Animated intro Video.
Write a VBA/Macro Using Excel for analysis a huge number of property information, including all particular, Historical and Current rental status, Rate of Return, Historical and Current Market Value, Profits or Loss and Banking Facilities Information for each of the property.... Steps 1. Design "Master Data Sheets" to contains all information 2. Design