I’ll try to explain this the best I can. I want to setup 3 loops to pull data for college basketball games. I'm experienced in VBA but I'm having trouble creating a loop that does not error out after 15 games or so. There is some kind of security on the ncaa's site that prevents this type of data scraping I'm told. The workaround which has been mostly
I have a pdf on an excel sheet that shows the required data sets to be applied to the related data sets to produce the needed summarize answer. I need the sheet created and the formulas properly placed the sheet functions to provide the proper numeric answers. I do not need the "Gateway Engineering" heading on the sheet. But I need everything else
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
...(2+2+2+1) required on 5973, 5974, 5986, 6393. So, if there're 7 QTYRQRD while 5 FONHAND, we're short by 2. I want you to write a custom Macro or a custom excel function which does that for me. What I want Excel to do is, sort the QTYREQRD by DATE, and allocate them by First Come First Serve. For example that we have here, Job Number 5986 required
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
Dear Sir/Madam: I need a logo for business card and branding design for a box packaging for A4 Copy Paper. The same design is also used for the wrapping sheet to wrap the reams. The box fits 5 reams, each ream contains 500 sheets. Company Name = Xidigta It translates to Star, so it should have a star graphics in the logo. The name could be
...see file timesheet report_2018-0805_thru... That file is that copied on to file Construction Tsheets-CRM Transformation and we press CTRL->L for a built in macro to transform into file After Macro Construction Tsheets-CRM Transformation. We need to have the original file timesheet report first mentioned..... have a daily over 8 hours overtime calculation
...i'm wanting to build a budget based app that helps me track my practise,the information and produce built must remain Intellectual Property (IP) Agreement ,i have built a excel macro as a prototype their are a number of macros ,but would like some help CC+ Software or program into a live app ,or iPhone, Mobile App Development, iPad, Objective C, Android
...into Google Sheet from Solidworks. I'm using SolidWorks to make technical documentation to be used in a tool shop. There are some data in SolidWorks which I would like to share with tool shop including technical documentation. I would like to upload files to Google Drive, add data to Google Sheet and add links to documentation. Part of macro in Solidworks
...variations that have pricing that need to be updated. In total less that 1500 part numbers. This should be a simple task, to match numbers and replace with what is on our excel sheet. Our website uses WordPress and WooCommerce. Here is a link to the catagory: [login to view URL]
hi i need few persons that will collect data from a graph and enter it into excel sheet with 100% accuracy. Please only bid if you are ready to start now. Further details and username of the graph will be shared through PMB. happy bidding
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical. Out of this only the patents file needs to be downloaded for each compound. Please bid only after you ...
I'm looking to have a powershell script created that collects some data from the user, collects some information from the Azure subscription then searches Azure to see what services are enabled and configures logging. The logging should output to a new resource group and storage container. When finished it packages up collected data into a JSON and POSTs it to a URL.
...information from a data set provided by the TTB entered into an excel spreadsheet and formatted to my specifications. Attached is the data set i need copied. I need the temperatures in the top row, the Proof in the first column, and the rest of the data continued on in the format from the sheet but not staggered by pages, so that it is one contiguous set
Hello, I simply wanted to extend date range on my existing excel sheet. When you open this excel sheet, it have provision to enter data untill 7th Aug 2018. I want this extension for 2 more years with same vendor list. I am attaching excel file.. I want its extension so that i can enter further and do calculations with filter in excelsheet...i can pay
We utilize quickbooks for our accounting software for delivery sales and vending machine sales(Cash business). Due to the fact that our vending sales are not tracked in inventory with quickbooks we currently do not have correct inventory causing our balance sheets to be a mess. I am needing help with explanations on how to rectify this and some guidance in other areas of quickbooks in order to f...
The purpose of the project is to get a better visualization of the linked report in order to have a better overview and to more easily find the most important deviations. The report today shows the deviations week over week with conditional formatting for the metrics sessions and conversion rate. We look for deviations in the following dimensions; *Campaign *Country *Source *Browser *Devic...
In total nearly 40.000 records need to be cleaned. A test file of 500 will be delivered.
Transfer the two documents data to excel spreadsheet and list them in 3 columns. Product Name Total Kit Price (Part A + Part B + Part C if it has part c) Price Per Litre
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
Writing code looking through code or debugging it. Fixing code. Block of code description. Understanding all concepts or c programming. Deal with pointers and various variables and output selectors. arrow notation and stars that deal with structures. Ampersand pointer to a memory address what is it array to pointer. The variable scanf and %d ampersand there character array %s and null pointers s o...
Hi, We need a clear and visual membership contract for gym membership. Our sale process is a 3 steps process : 1)trial membership of 1, 2, or 3 months, then if not cancelled before deadline, 2)automatic renewal for the rest of the year ( so 11, 10, or 9 month) . At the end of this membership (if not cancelled prior deadline) 3)automatic renewal to specified memberships. This is a bit complicate...
I need to loop through each row and for any cells that meet the "if" condition, then the cell value 6 columns to the left is displayed....to the left is displayed. I already have the entire code written that can email me the cell values, just needs small modification. Should only take 5 minutes for experienced VBA programmer. Need this done in 1 hour.
...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 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
We use Wordpress and have posts. We would like each post to have an address, and these posts could be plotted on a page with a map. We would also like each registered user on the site the ability to select posts and plot them on a map, unique to them, that can then be shared on Social Media and other channels. Please read in detail the attached document which outlines everything.
I would like an excel worksheet which can track my stocks and options. It has to auto update data from google or yahoo finance. It needs to have stock tracker listing my position when I bought and sold it, fees, total cost, gross gain and finally net gain after all the fees. Most importantly I want to have option tracker which would cover naked puts
We are searching for a experienced developer who has knowledge in both MS Access VBA and one other language such as Python/Rails/PHP. The goal of this process is to achieve the same functionality as before. Please don´t write a long list of accomplishments in your application but rather give me a short explanation how you would handle that problemset