Code Optimization: The Complete Guide
Enhance your code to let the wired (and wireless) community make the most out of technology. Read this article for tips to keep in mind while coding.
I need someone to help me learn the basics of excel including formulas, macros and vlookup. I have three days to learn this and really need help.
Excel sheets need to be Interpreted into diagram
Excel sheets need to be Interpreted
Excel sheets need to be Interpreted
Excel sheets need to be Interpreted into diagram and graphs.
We need to make automation of some tasks using RPA, it involves: 1- OCR 2- External APIs 3- macros please only bid if you are capable
I want to build a excel tool to execute bulk trading orders with Angel broking. I need a tool to be built which can push order through the Angel API's Excel Macros API integration
I have an Excel Spreadsheet. I have a video with a lot of manual processes to update the spreadsheet. I would like you to write Excel VBA Macros to automate this process. There is a part of the process that pulls in data from Adobe Analytics via an Excel plugin. Don't worry about that part because the Adobe Analytics plugin pulls in the data. I simply require you to write the Excel VBA Macros to manipulate the data. The data is in the attached Excel file. The manual steps are in the video below. Please fast forward to 13:45 in the video.
Hello, I need help with a sheet I am creating, it is in Zoho, but it seems to be almost identical to Excel and Google sheets. Basically I am creating a template to be used for a PEO type company. We hire employees on behalf of our end clients in Countries they do not have a presence in. This means we have, many clients, with differing Countries, currencies, products, and employees. Our "products" are therefore fees rather than specific goods. I would like a template to be created (or the existing one adjusted) which functions all the time, whether I add an employee, country, product, or if I adjust or remove any of the above. I have made one such spreadsheet (one sheet per client), but the moment I change anything it will cease to be useful. So I would like help with this. ...
I need a macro that will show, in real time, the "Open Price" of securities from yahoo finance. Col A should be where the handle/ticker/ name of security will be inputted. Col B should show the current price of the security. This should apply to all sheets in a workbook. I only need the macro/script text.
excel using macros and formulas to show sheets Interpreted into diagram
excel using macros and formulas to show sheets Interpreted into diagram
Hello, I'm a marketing executive, and my company manages Amazon accounts. I'm not necessarily interested in automation which is why I'm here. I'd prefer to upload into a calculator based app that organizes the data into multiple graphs. I'd like to build a reporting dashboard, with custom reports like a bubble Clock Chart, to give a picture...accounts. I'm not necessarily interested in automation which is why I'm here. I'd prefer to upload into a calculator based app that organizes the data into multiple graphs. I'd like to build a reporting dashboard, with custom reports like a bubble Clock Chart, to give a picture of the hour with the most sales in a given time period. There are a dozen reports, each with their own process that can use mac...
Hi I am looking to work with someone who is expert in Excel & Macros for 2 projects. For more details, kindly quote.
We are creating a MS Excel based predictive model to assess market metrics and predict other marketing metrics nationwide. We are looking for a VBA Macros expert to automate the model. The model where entire metrics is to be calculated and predictive for a city chosen in dropdown is ready for use. Now, we want to create another sheet which is a summary of all the cities where marketing metrics are calculated and predicted. The model is run for all the cities and a summary is created with a refined view.
Need freelancer for on going project. Need to develop macros for data input to Webpages from excel sheet. (Pivot, slicer, vlookups ,Match, index functions are mandatory) It is good to have experience on SAP data , JIRA ticket tool data
Looking for someone who is expert in writing scripts with macros or vba for automating documents in MS -word
Se necesita una macro para descargar listas de precios de empresas. - Formulario para ingresar datos del producto : Nombre de la Empresa, Fecha, Nombre del Producto, Detalle, Precio 1, Precio 2, Precio 3 . - Consulta con los siguientes filtros : Fecha, Por producto , Empresa. Por ejemplo selecciono un producto y puedo seleccionar varias empresas. - Al realizar las consulta también debe de salir un grafico de líneas para saber el movimiento de los precios que ha tenido el producto.
Hi Chandrasekhar G., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hello, I am looking for someone to write a style guide document for My Access database. Some key items to consider are: Considerations for creating tables Considerations for creating Macros Considerations for creating My Access Forms Specifying default values Choosing data types Naming convention (tables, queries, columns/attributes,) Capitalization (like SQL constants need to be capitalized) Indentation Line spacing Adding Comment
Hi, I need you to design and implement a database using Access. It should include conceptual design (database model), creating a database, queries, forms, macros/modules, and reports using Microsoft Access. Please bid if you are an expert. I have provided an example also.
...bright colours to grab people’s attention but mostly just writing. I would prefer the writing to not be altered but you can enlarge writing or do what you feel is best to grab attention! Wouldn’t be opposed to bullet points for the paragraphs!! 1st must say- PROMO- Weight cutting package! Get FULL access to the app including goal setting, nutritional breakdown in a meal plan including calories and macros, weekly check ins, grocery list, supplement breakdowns and much more! For a limited time offer of $250 /4 weeks 2nd must say- PROMO- Follow up ACCOUNTABILITY package! Discuss goals, strategies, nutritional ideas and recipes and have 1x15 minute accountability check in per week. Limited time offer of $50/4 weeks. 3rd must say- PROMO- Nutritional Planning Package...
I have several text expansions that I use with text expander, I'd like to have these put into keyboard maestro macros. You must have experience with keyboard maestro.
I handle project management for a firm and it requires me to follow up with people on a weekly basis on the tasks assigned to them. I have an excel with tasks, deadlines, Handlers, and their email addresses. Need someone who can use VBA and Macros to automate the mails. All the tasks assigned to a single person should be clubbed in a single mail.
Excel professional is needed for my ongoing project.
These are my error messages. I have 11006 data lines in the database **The visual basic for applications project in the database is corrupt** **The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.** **"Id" is not an index in this table **
Necesito un experto en macros para crear una en base a mi data. Más detalles via chat.
Hi Ranganathan V., I noticed your profile and would like to offer you my project (For a Pricing tool which might require Macros/VBA). We can discuss any details over chat.
Hello, I want to do amendments and updates to an excel sheet that carries functions and macros. The additions are not complicated, but I want to keep the functions and results working as they are. Enhancing excel is welcomes but not changing the formats I am working on. If you are an expert in excel macro and VB codes, you are welcome to discuss the work.
About us: Our company is expert in financial modeling consulting and training. We prepare financial mode...how we want you to prepare the model but you will need: - Expert knowledge of excel - Hability to prepare flexible, clearly presented models that follow best modeling practices - Experience in preparing different types of models (e.g. business plan, valuation, LBO, Project Finance) - Hability to prepare models with different Timescales (monthly, quarterly, etc.), familiar with the use of flags, macros, dashboards - Detailed knowledge of Finance, Accounting and tax concepts In your proposal, please provide a short description of your modeling experience and why we should consider you. An example of an excel model (business plan preferably) that you have prepared recently would ...
Hello! I am looking for someone that is experienced in MicroSoft Excel programing, Macros or VBA. We are currently taking a MicroSoft excel worksheet and turning it into a Pivot table to better visually display the data. We have created examples of the report and have a document that outlines that 15 - 20 steps need to take the raw data and turn it into an attractive looking pivot table report. I am looking for help from someone who specializes in Excel automation and can help us create a program or Macro that will run these reports for us with a click of a button, instead of having to go through the normal 15 steps to create it. I can provide you with the excel document raw data, what the finalized report/ pivot table needs to look like and instructions document that outlines the s...
Tengo un programa compuesto de 8 formulas cada una manejada con unas macros de Excel las cuales solo funcionan en pc, ahora lo que requiero es que estas macros funcionen desde un celular ya sea por medio de una app o por medio de Excel con macros de celular
Necesito un "Punto de venta" para registrar el alquiler de libros de texto en un instituto así como la venta de libros nuevos. Tengo algunas bases de lo que deseo y solo necesito ayuda para las macros finales
We’re a small meal service plan service providers in Vietnam. We want customers to be able log in into their account and see an overview of the weekly plan, where they can choose some of or all the days. And for every separate day, they can view the meals on that day and choose which meals they want. We also want clients to be able to customize our fixed weekly meals and see the macros and total price change according to their customization. ABOUT US: we’re students with a medical degree thus we have a background on nutrition. We have our philosophy and vision. We’re looking for a minimalist/dark colored/green accent/vegan theme
We’re a small meal service plan service providers in Vietnam. We want customers to be able log in into their account and see an overview of the weekly plan, where they can choose some of or all the days. And for every separate day, they can view the meals on that day and choose which meals they want. We also want clients to be able to customize our fixed weekly meals and see the macros and total price change according to their customization. ABOUT US: we’re students with a medical degree thus we have a background on nutrition. We have our philosophy and vision. We’re looking for a minimalist/dark colored/green accent/vegan theme
I have a Excel Spreadsheet that can contain up to 100-hundred rows data. I'd like to move specific rows from Tab 1 to Tabs 2, 3 and 4 if the data has a calculated value of "1"in the corresponding column. There should be no blank rows in Tabs 2, 3 and 4. All manipulation should be done with Excel functions and no macros. If not possible to do with macros let me know.
An excel workbook with a lot of macros and codes need to be modified and replicate some formulas and sheets
I have a database which is in Microsoft Excel. Some of those fields include Date, Product, Description, Username, and a few more fields. I w...advanced Mail Merge type of situation.) ***I am also open to discuss if there is a better way to store customer records. From there I can send or save as PDF and send to the customer. Notes – The Excel data is in a standard table and there is nothing complex about it. I am not sure what a fair asking price is, but I do know that this job is rather straight forward for someone who knows VBA and Macros. I would really like to find someone that I can work with as there will be ongoing work for the right person. Also, if you are able to walk me through how the Macro is setup I would really appreciate it. I look forward to reading you...
Application is to fetch data from Cosmos DB and generate excel report - User will select Code and press DOWNLOAD button on the webpage - An excel worksheet is to be populated with latest data from Cosmos DB - One excel sheet is used as a template then use the template to create a new excel. All macros, formulae of the template need to be copied over to report sheet -- Develop application in JavaScript based technology and deployment in Azure - Use Azure Functions or docker container for development
... Alternatively, we could build the layouts, contents, merge fields, conditional logic, etc. within our own code and attorney dashboard, generate the entire output in ooxml or some other format, and then insert all of this into the document (without ever using a word add-in). My thought is that using microsoft word macros and/or VBA will be easiest, but I'm open to different approaches. I am looking for someone who has the following experience: 1. Developing word add-ins, macros, VBA. 2. Architecting document automation 3. Architecting document and content management 4. Developing document automaton 5. A strong understanding of the current best practices for document automation that existing businesses are doing. To apply please answer what experience you have in th...
Sheets Simplest Method excel using macros previously carried
Hi, I have an MS Access table with simple fields (primary key, first, last, address, date, amount, etc) I have an Excel spreadsheet that matches all those fields exactly. I need to update some of the fields for some of the MS Access table records using the Excel spreadsheet. I need a process that shows me how to do this using a Linked Table Manager and/or Macros or something. Thank you. Eric
Need to work on macros as data in in large format
I would like a personal fitness app where people can contact me for training programs, healthy meals, macros
My business is geared towards custom meal plans, exercise plans, and gym accessories. Currently, there is not a business to my knowledge that has software that can create custom meal plans based on age, weight, height, calories, macros, number of meals, etc. It is my hopes to have someone assist in building software that is integratabtle into my already built website.
I need an automated SAS SQL & Macros script to merge together three data sources (attached) to create an aggregate report. I will then need additional script to query the aggregate data to provide insights - details attached.
I would like to make a Microsoft Word Macro which takes a small amount of text and manipulates it so I can have a daily worksheet. It is mostly copying text and applying different formatting to it. I'd also like to amend a second macro so that it only is executed between two delimiters. The project is fully detailed in the attached Word Document. Please review it! Also, there are some macros already written which are at least a start to the new project (VisualBasic for ).
I explain below how to record an Excel macro using the recorder.
Looking for someone who is very good and fast in MS Excel. SKills include 1. VLOOKUP 2. INDEX MATCH 3. Advanced conditional formatting 4. Pivot tables and reporting 5. Macros and VBA 6. Data simulations
Enhance your code to let the wired (and wireless) community make the most out of technology. Read this article for tips to keep in mind while coding.
All About Human Resources and Organizational Development