...build a fantasy baseball draft worksheet to be used as a tool for draft preparation as well as a live-use tool to help manage the draft. The worksheet will be created with 2019 projection data from public websites such as [login to view URL] and baseballsavant.mlb.com. I have included a template worksheet as well as the worksheet I used in last year's dra...
Hello, I am seeking someone with advanced skills in Microsoft excel who can work on a short term task to better enhance the functionality of my excel workbook to track my investments. Such task include The formula to calculate win % correctly in a worksheet adding a button to reset checkboxes an overview page/ dashboard to calculate win% and gains
VBA code to Protect Excel worksheet where editing is possible , formulas are hidden and unprotecting the sheet is not possible with password breaker VBA code, i don't want the below code to be able to uprotect the sheet : Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer
Hi i'm looking for a graphic designer to create: - an invoice template to be used by creatives; and - a strategy printable worksheet based on the text I will provide. Again, looking to appeal to creatives (designers, influencers, videographers) in it's visual style design.
To write a program to convert .CSV file into Excel Worksheet and vice versa. (1) From .CSV to Excel After the conversion, some of the fields can be hidden, protected and with some calculation inside the cells ( eg. qty * price = subtotal, summary of subtotal to total ) In the sample excel file which is after conversion. Column A,B,C will
for my catering business, I need the data of an Inquiry/Quoting spread sheet transferred to a Booking spread sheet once the client have agreed to have us cater to their event with the click of one button. From the Booking spread sheet, it should generate some reports(in a table format) from any given time frame(example: 17Feb19' - 23Feb19'; one weeks
I need to find empty categories in an Epages Webshop. I provide an Excel Worksheet with the tabs. On tab is a Shop CSV Export. -Category List -Product List -Matching List Products to Categories. At the end i need a Makro for the worksheet, which marks empty categories as invisible, categories with content visible and make a csv file in the right
...it. I need to be able to paste daily sales data into a new sheet (sales) on the spreadsheet and then run a macro that will go through each row and enter the cost price for the part sold from the other sheet (costs). I need the cells to contain actual data and not a formula, that is why I want to use a macro. If the part on the sales sheet cannot be
Search data in one worksheet and display in another. Quickbooks Sheet = Cognito Export A= AJ B= D,E (no spacing; Exact Order) C= AI D= AK E= C (Day/Month/Year Format) F= AL G= F, G, Y, AO, AP, AQ, AR, AS, AT, M, O, Q, S, U, W, Z, AB, H, I, D (Spacing between each; Exact Order;) H= AH I= E,AI (No Spacing; Exact Order) J= AM K=AN *Data needs to be added
Customizable time tables for various classes Mon - fri 5 sessions and one lunch break faculty wise course wise, invigilation duties no of invigilation duties no of teaching hours exam seating allotment room nos, no of students per room roll no, admit card no
I need a macro in excel that logs onto a web site, simple navigation to a page in the website (one click away), enter some information and then press the submit button. The web site has aviation weather information and you can set up an account for free to do your testing. The URL is: [login to view URL] I have
I would like to make origami feathers as a workshop item, so i need a worksheet designed with the instructions step by step to make a feather.
i have control results mentioning a rownumber if there is something wrong with the controls when the rownumber is entered we should automatically go to the input sheet that has been controled and delete the row in that sheet
I need to create simple macro as per rules in the sample file attached. It is very simple and basic work. i will have more than 5000 rows of data, so the macro should be able to handle it efficiently this is very urgent, if you can do this in next 3-4 hours thanks
I want to generate automated outlook mails from available data in excel, I have some images in excel workbook which I want to paste in body of email and also some text which I want to paste in tabular format. I have developed utility for genertaing mails but I am unable to put mutliple images in mail
Please see video and let me know if you understand and are able to get the job done. :) [login to view URL]
Looking for someone to help me find the pointer to an offset in a PC application and code a simple macro using AutoIT or Autohotkey that uses the pointer. Ideal candidate would also give me simple steps to find the same pointer were there to be any updates to the application. (I am familiar with the basics of programming and memory reading although
I need help creating an advanced filter/macro for my Google Sheet. I need to filter for locations that may or may not be on the sheet. Please watch my short video for more information. I look forward to working with you!
Excel macro to establish N number of TCP connections simultaneously using different destination ip address
...given, the following functions have to be added: - End user can only upload picture with specific size and format - End user can upload voucher coupon codes within excel - Excel worksheet is sent to specific Email address after click on button This task is part of a larger project. Looking for an expert with high skills. If the work is done very well
...coding work. You will create a plugin that extends the functionality of another plugin called MyCred. The plugin is meant to do the calculations shown in the attached excel worksheet. Before you accept this project, please tell me if you have your own WP local installation for the development and also can you accept installment payments rather than
...automate the attached excel sheet to do the following 1. Data entered into "daily data" tab must be sent to the correct tab, based on cells C2,D2,E2,F2, data well be entered daily and must be exported based on the date mentioned in the sheet. 2. In tabs DQ-45 to DQ-48 data(captured from "daily data") is to be stored on weekly basis....
...aluminium profile systems for windows, doors and façades, as well as aluminium profiles for the processing industry. Our sound-proof window has an outstanding advantage in comparision with normal sound-proof windows: It reduces noise even when it's open! On our microsite [login to view URL] we already show a couple of videos and have some explaining
The module will create a monthly worksheet (similar to the one attached) with a configurable layout with main fields being the total amount of the orders received, paid or invoiced (to be configurable) and the sequence number of the invoices issued in the day. Amounts put in the worksheet are per VAT defined in Prestashop configuration or in alternative
I need to be able to import excel cells of syllabus “events” and “pqs” completion for students. With these cells I need to be able to update months in syllabus (everyone having separate start dates). It would then need to produce products that will show completion of events/pqs in relation to the allotted syllabus timeline in a graph format (11/18 months
I need webscraping of [login to view URL] site's derviative open interest data with 15 or 30 min refresh interval and to get the same integrated with my existing vba worksheet which is updated with previous end of day data and compare the changes for the same
I am looking for an Excel Spreadsheet that graphically displays the progress on a monthly basis. There are two fields Total Due and Total Complete to determine progress towards a 100% completion. There are three different deadlines after 7 days to be over 30%, after 14 days to be over 60%, and after 21 days to be over 90%. If the individual meets the
...i want replicated in Python 3. The Python code shall: 1: download a few data tables from statistics Sweden (using their REST-like api) and store this data as pandas dataframes in Python. 2: create a few graphs using plotly and summary statistics from these dataframes (the data will be linked and used across the dataframes etc). Plots shall be saved
I wold like to create a macro that I could paste in to PowerPoint v16 for Windows / VBA that would save selected slides in the slide sorter as INDIVIDUAL powerpoint files whose file name corresponds to the slide number in the presentation
I will give you 100 websites you will need to extract the following information and enter it into a csv worksheet template that I will provide Information Required Firm, Website, Email, Phone, Street, Suburb, City, Post Code, First Name, Last Name.
Auto Schedule Excel Workbook with Macros to run in Windows I am currently opening an excel workbook each day and manually clicking the Macros VBA button to run a data scrapping process. I would like to set up an auto schedule to run this work book each day. There a few other steps in the workbook and process which I want to automate the process. Summary