I need someone to build a excel workbookεργασίες
I have attached a workbook with data in one worksheet and email address in the other. Here is what I'm trying to automate using VB: 1. Filter column C by supplier (CA National Serice Pty Ltd) 2. Filter column V for "Ordering" 3. Copy Data from Column F and G 4. Email to the supplier address in "Email Address' tab Then repeat this proc...
...document path to be entered into the Configuration Options. The same applies to the filename and path for the document that is saved as a result of the operation of the add-in. I require the Customise the existing ExcelToWord Add-In to be customised to allow an option for the Word Template document path and filename to be referenced from a<...
I need someone to add either a formula or a vba (that I can edit later) which will take information from sheet 1 and automatically transfer it to various other sheets. I need it to do this based on the zip code in the address. Example would be 60 different zip codes around me - however, only 13 will go to sheet 1, ...
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when ru...
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
I have a workbook that I need OpenPyXL to work with. I have had the library running fine previously but I can't remember what steps I had to take to get it running. The error in my code pointed to the first few lines, when I attempted to copy the original workbook. If I run the bel...
I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organ...
...the project below I have, I am a good colleague and will work with you. I need this done soon so please reach out if interested. Thank you-------- -----------------PROJECT DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy mu...
We are a small business we offer marketing solutions to our clients.
...Chandrasekhar G., I noticed your profile and would like to offer you my project. We can discuss any details over chat. Hi, Okay, so I'd like to create something very basic that will allow me to run the macro and create a summary of my daily sales reports. I realize there are ways to do this in other programs, but all I'm able to...
We have a simple existing Excel workbook used to create daily delivery sheets so drivers can load then deliver items. Our service operates on a 12 week cycle where the daily run is set, on a repeating basis every 12 weeks. We require the Excel workbook to be converted to a database and additional functionality added to...
...is prompted to select the Ordermentum Payments File Macro will then: - Match up OMO numbers between Files. - When a match is found, compare the dollar amounts - If the dollar amounts match, highlight the row in specific Green - If the dollar amounts do NOT match, highlight the row in specific red - Insert the "Batch" number in Column G to the right of
need to create a file to link some data dump from a trust system to another set of variables. this needs to be done in such a way that data dump in future could be extracted in similar way. More details will be provided to selected freelancer.
I have a data analysis task. I need some one to write me FINANCIAL REPORT for New project, this financial report will be part of Feasibility Study, the TABLE OF CONTENT of FINANCIAL REPORT as following: Executive Summary Means of Finance Costs & Operating Assumptions Projected financial statements Ratio Analysis Break-even Analysis Sensitivity
I need some one to write me FINANCIAL REPORT for New project, this financial report will be part of Feasibility Study, the TABLE OF CONTENT of FINANCIAL REPORT as following: Executive Summary Means of Finance Costs & Operating Assumptions Projected financial statements Ratio Analysis Break-even Analysis Sensitivity Analysis Conclusion It
daily i download a .xlm workbook with speed ratings for the days racing..i would like to be able to analyse the performance of these ratings undwr certain conditions ie course distance certain trainers at a course etc also you need to source the results file to assign the results to database i belive its avaialble ...
I will be entering raw data which will include Date, Time, Call or SMS, Phone number. Once I've put all this into a Excel spreadsheet or workbook I want Excel to automatically assign the phone number with the contact name and if the contact name is not in my list just have unknown.
Modification of Existing Excel Workbook related to Financial projection. I have existing Excel workbook for Financial Projection for New Manufacturing Project, needs to add More sheets to it, adding more Ratios, do Graphs, etc...
I'm using Excel 2010 and saving my worksheet in Workbook Excel-Macro Enabled Workbook or Excel Workbook. Numbers with decimals will add/subtract,multiply and divide. However, formulas using Min/Max, IF, And, Median etc; do not return correct results, in this case "Y","N". Numbers with decimals default to "N". All...
...place in ArcGIS software the analysis and interpretation has to be technically correct. I need you to precise about this and leave me with sufficient conviction that whatever you presented is feasible or plausible. Please. Substance. Is the analysis and interpretation sufficiently substantial? I am looking for work that demonstrates some original thinking
I have two Excel list with our paper cutters (see attached). I created a workbook for calculating quotations and I need to select an appropriate cutter by selecting criteria from three related dropdown lists ('label size across' , 'labels size back' and 'Geometry'). Once the appropriate cutter is selected, 5 diff...
Hello (PLEASE READ CAREFULLY BEFORE BIDDING) I need an excellent account/financial analyst or business appraiser to value a public company based in Jordan. Tasks to be performed (ALL IN AN EXCEL WORKBOOK, NO REPORT NEEDED) -Perform Financial Analysis of the Business -Calculate the Adjusted EBITDA (Removing unrealized profit or loss and any irregul...
I have a protected (workbook paswd protected) xlsx office 365 file. But i forgot the paswd, need someone to help me open the file. File should be recovered in full without any loss to the data.
...specification, I'm looking for an Excel workbook with the data for each of the leagues below on a separate sheet. The data should be for the 2017/18 season (last season). Each match will be on separate a row and the columns will have: total goals, time of goal 1, time of goal 2, time of goal 3, etc. The leagues I would like to look at initially ar...
Need a MS excel & VBA expert who can guide me & troubleshoot wherever I fail in any task or work MS excel 2013 & above versions. For eg - Right now I need help in some tasks of creating a billing & Inventory workbook with many automations making it kind of a mini software. I can pay on hourly or per task b...
I'm seeking an illustrator to draw, design and layout graphic elements and illustrations for a workbook for teenagers about the U.S. college admissions process.
Need help with a Tableau workbook to find how each visual mas made and formulas used. The job is simple and each session that is needed it will be done via Teamviewer. Looking for the lowest bid.
I want a excel workbook done of the case for I-M
I need an Excel genius to build a set of formulas, ranges, and lookups in a data workbook. What is required is building lookups from one data field and matching them to indexes of rows of data. I need someone who is very adept at using Index, Aggregate and Lookup functions, as well as embedding named ranges, and wo...
Hi all, I need to have a template done in excel where I can plot in data to have an overview of different markets and of the clients belonging to those markets. It needs to be done from blank workbook, have three big left side categories showing the different markets, and some tabs for information on region, country, company, ...
Spreadsheet Number 1. I have the sheet set up but I my OFFSET formula is not working correctly. The spreadsheet has a master sheet that collects data into one sheet that is easily analyzed. The bulk of the data is pulled straight from the one worksheet but I need to be able to pull in every other row for one data set - then I need <...
I have an existing workbook and dashboard incorporating 3 sheets and a dashboard with no interactivity. I need to either add functionality to the dashboard or create another one entirely that incorporates user interaction of clicking and hovering to update the fields when certain filters are clicked.
...BIDDING) I need an excellent account/financial analyst or business appraiser to value a company based in Jordan. Tasks to be performed (ALL IN AN EXCEL WORKBOOK, NO REPORT NEEDED) -Perform Financial Analysis of the Business -Calculate the Adjusted EBITDA (Removing unrealized profit or loss and any irregular and non-recurring items). -Construct ...
i have a java code that needs to be improved Little and fix some few bugs. I want the code to read/copy and excel sheet from a template Workbook and past/update the sheet/ into several Worksheets that are already existing. Let me know
Create a workbook with pages similar to what I uploaded, for equestrians to outline their goals for the year/month/week, pages to take notes and record observations etc...
I am using an old Excel Spreadsheet that has been modified with many Macros to automate a "Risk Management Tool". At the click of a button, I can choose the severity and likelihood factors for risk ranking work tasks on a construction site. There is an "Add-Ins" tab that allows the user to insert rows, delete rows, rank ri...
...Tableau workbook around data types and desirable contents Freelancer sought: Expert Tableau builder with understanding of statistics (will need some statistics calculations in report) Specific needs: 1) to create a type of "psychometric" view in Tableau. Sample data can be provided. Basically, each individual in the data needs to A) have ...
I have an old workbook - xlsx format - that I forgot the password and need to unlock. Since its newer than Excel 2007 its encrypted and the old style VBA password buster wont work. To confirm you have unlocked the workbook show me "Period 1" sheet
Microsoft excel project. In this project you will complete a vehicle shopping workbook to compare the purchase of several vehicles. After completing the project, you can make a copy of the file and use it to compare vehicle purchases you are considering for yourself.
i have a google sheet file/scripts that are currently quite buggy. i want to create a modification that should eliminate all bugs by changing the way the user interacts with the script notes: 1. currently there is a script called goLockloop that is triggered whenever the submit button at the bottom of the page is edited to a "yes". ...
Search all excel sheets in a directory. Create new excel workbook containing all line items that match pre-set criteria User will modify new excel workbook Program will append user added data to new work book into the original source files from which the new workbook was created. The append will be on a line by line, file by file basis...
I have an exsting Excel Workbook that needs to be expanded wiht new financial data
...some sales data in a flat file that is structured like this at a transactional level: Product Date Quantity ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new sheet. 2.
...are a legal document preparation service company. Our website describes our services but it is currently built on GoDaddy Webbuilder. We need our website audited and updated / revamped in terms of looks, contents and how contents are displayed in order to maximize SEO, search engine visibility, and website viewing speed and mobile friendly. Need to provide
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
I have an Excel spreadsheet that uses the worksheet_calculate function within VBA to monitor changes to a cell on Sheet1, which in turn triggers a timer whenever a change is made to that cell; worksheet_calculate is used instead of worksheet_calculate because the cell contains a lookup formula that references a table on another ...
I have a different way to calculate food costing and managing recipes than this attached example. But I am not an expert in Excel and need the formula / coding behind this worksheet (which is locked). Can you help!
Hi, I'm looking for an expert in print for an immediate turnaround on the re-formatting of a training workbook. Thanks.
We want to develop a mobile application (ios and android) to display a information workbook of roughly 300 Pages. The user should not be able to download, screenshot, copy or print the workbook. Login can be via social media and based on the language selected, the said workbook should be displayed on the application
I need a Google Script that will allow me to clear the area below the header row of Sheet2 without adversely affecting Sheet1 This video also describes what I am looking to do and shows the workbook we are referencing. [κάνε είσοδο για να δεις ...
