...you to transform it to VBA code in order to iterate a list of inputs. The formula needs to work in google sheet. I enclose you a case file, in order to understand better. The formula is =$C6*MAX(0,DAYS(MIN($B6,EOMONTH(E$5,0)),MAX($A6,E$5)))/DAYS($B6,$A6) and corresponds to the value of cell E6. Columns A,B,C are the input data. I want the script to
...location. I have already wrote some macros to help my daily reporting but I want help on creating a spreadsheet to analyze sales and transfer the stock to different locations where its selling and do reordering as per the requirement. Plus I have data since 2014 which i want to consolidate to analyze and do add it in my monthly reporting and wherever
I need some graphic design logo letter head fast within an hour duration I will send the logo sample and it has to be remade no cut and past I will need the soft copy and the file formats pleses don't waste my time bid only if you have relevant expertise
This job is for a pe...a King size bed. Flat Packed. It is made in Plastic. I want to convert it into wood, so I need a CAD drawing of the bed that can be read by a CNC milling machine that will cut it in to wood. I have attached 2 files, one shows the part measurments and the other is a photo of the product assembled. Output file is STP and DXF.
I have a Python script that partially works to load in three spreadsheet files and merge them together based on country and save them as a new spreadsheet file. At the moment it displays each country multiple times but what I want it to do is merge all the countries together. For example germany, 1, germany, 7 germany, 2, germany, 5 germany, 3, germany
The link is [login to view URL]!AigUtCwi_FIapWqtQWmB2gfzfCBb You will see there are 2 videos they show in this one which I've...b You will see there are 2 videos they show in this one which I've included in the file (I thinks theres only 2) the presenter messes about a bit to get it playing, you can cut this as you think best. Any questions please ask
...inventory through approved suppliers - Setup supplier database - Negotiate with suppliers on purchases - Update inventory purchases online - Maintain and update master product data sheets in excel - Communicate with delivery company - Printing of inventory labels - Monthly purchasing summaries (cost, quantities) - Source potential new suppliers Requirements:
...customer ID, name, phone number, ... and I need: 1. I want write macro, AGI script to change from customer's ID to customer's phone number. So when user call to customer they don't need to know customer's phone number, user call to customer by dial customer's ID. 2. I want write macro, AGI, ... when customer call back to trunk, It's replace customer...
I need you to fix a complex macro to execute it flawlessly as stated in the project info file enclosed. The code and other files with project info files are uploaded here [login to view URL] Bid only if you are very confident to do this in 12-15 hours from now Can give $25 max. Bid confidently
I have a list of records on PDF that I’d like entered into an excel spreadsheet. The info to be added to the spreadsheet are the Address, Beds, Baths, Property, And other stuff. There are approximately 150 total records to be entered.
Hi, I have excel files in 1 location, I need to open all these files one by one and get the relevant data and copy into the master file. I need to run it every day in a scheduled time. ( whatever required data cells, I already coded in the VBA code, so what you need to do is code to open files one by one and add to the master sheet) will send you
1. If you bid and then ask what I need. I will flag you and never respond. 2. Primarily I am looking for a person to give ...instead of hello write "olleh". This way I know you actually are a detail oriented person and not just a FL scraper. [login to view URL] only bid if you are really good at formulas and VBA, I don't have time to explain every single detail.
I need you to fill in a spreadsheet with data.
Please take a LOOK at contest at: https://www.freelancer.com/contest/Windows-SHORT-OneLiner-Script-CONTEST-can-use-native-versions-of-gawk-sed-cut-etc-andor-perl-or-dos-batch-etc-Systems-Admin-SysAdmin-contest-1490799 The WINNER of that contest may be hired for additional work :)
SIMPLE and FUN SysAdmin Scripting CONTEST! Why should contests be only for graphics!? Download the DETAILS form the file linked below and feel free to ask questions :) [login to view URL] Hash of Linked file: MD5: 81017B638EB83B8DD8EFBD94C2E25EEA SHA1: 5377CCD3001CE3EACA6819C4706461FFDF1DE4F3 SHA256: 211E4A58E20FF31796E8AE835C57F43544D7DE0874E1D9103668297322DC1294
...requiring a English-proficient worker. I need this spreadsheet document checked against the original set of documents. There are 102 Pages in the spreadsheet. I'll pay you $1 per page. ($102) All you have to do is check the sheet, make any adjustments, then move to the next sheet. 90-95% of data has already been entered on the sheet. Please only
I am looking convert a .dat file into an excel spreadsheet. I am not sure what all I need out of the file because I cannot open it in any other format except a TextEdit. Also I can not upload the file below because it is too large. Is there a way I can split up the file?
I have a list of leads, I need somebody to go to the website and find the contact name for each lead. Simple, straightforward task. Let me know if you have any questions. Thank You! I'm open to an hourly or fixed price. Each list of leads is about 300 contacts. I will provide an excel sheet with the answers to all of these. It's simple to follow and enters. Each time through takes 20-...
Children book series. One series with three different books. Each book needs to have 12 pictures with one die cut layer which ready to print. My budget is not much..... The attached files is the details of one book for reference. Please contact me if you are interesting.
We have a Google sheet with 4200 names and web addresses for contacts. We need someone to go to each contact's website and grab the contact info for the individual, or if that individual isn't on that website, find their new one and grab the contact info from there. Accuracy and attention to detail is paramount. If you are confident that you are super efficient and can use systems to mo...
...add one data point each month on each worksheet. I would like to be able to put all the new monthly data in a separate worksheet and for the rest of the file, the graphs and tables to be updated. I would also like the tables and graphs to be saved as a picture so they can easily be inputed into presentations. If we take the CTA spreadsheet as an example
...Would like a simple summary of what is in each region that could cost anything. For example this command shows a list of regions aws ec2 describe-regions --output text | cut -f3 For each region; would like a “short summary” report of all items including the following. Lambda AMI's running Volumes, Secuirty groups, Running Instances Dedicated
Hi, Looking for someone to create a VBL / Macro in Excel to download and concatenate all the images from excel hyperlinks to specific folders. Collumn A : Folder Number Collumn B : 1st Picture Link (if only one picture) Collumn C : 1st Picture Link (if 2 pictures) Collumn D : 2nd Picture Link (if 2 pictures) this up to 4 pictures possible Images
Hello! I'm just a guy trying to make it with va...more to follow. I'd like to find someone I can develop a working relationship with. To begin, I already have a couple awesome marketing videos I have shot and edited in Final Cut Pro. I need someone to help me create better transitions, add voiceover or subtitles in a good looking professional fashion.
Need to fetch multiple worksheets and correlate reports in Excel using VBA
I am looking for someone with experience with Microsoft Excel. This is a data entry/spreadsheet job available. There's multiple ones that need doing. I do not mind hiring multiple people if there's too much data to process. Please let me know if you're available to discuss the project. Thank you
I ...change the logo on the back and some text and a few new ones creating. I would supply the images, logos and text. I would need them saving as an InDesign file AND a PDF with cut marks for printers. There are two different sizes 150x150mm and 7x5" I'd send a list of which number is which I've attached an example They'll be maybe 80-100 to do Paula
Hi, I must create a cardboard people. I already have the file but I'm looking for someone who can add the vector path created with Illustrator that indicates the cut.
I need the names and emails of the founder or CEO of 100 companies. The easiest way I've found to do thi...lbalp Also see screenshots attached on how to use it. Finally, here is the list of companies: [login to view URL] I have also attached a spreadsheet to complete. Let me know if you have any questions! Thanks, Liz