Macroproiecte

Need someone to build a simple VBA macro that pulls data from the CNN website.

Actually, I have an Excel workbook, which has five queries. What I need is a macro that refreshes only two out of the five queries. I will share the excel file with the freelancer who won the bid. For you information, macro-enabled files are not accepted. Also, the macro will be in a module and run using shortcut key only. My excel version is Pro plus 2016.

I have a report in a list format in Excel (extracted from Salesforce on a monthly basis) with categories that needs to be converted to a 2 dimensional table based on dates - the number of rows varies and needs to be dynamically aggregated by category. Needed urgently. Formatting/Presentation and Robust Coding are equally important on this project.

Hi. I need a macro program that automatically/promptly detects and clicks a box and a button when an event occurs on a website. I will provide more details with images if you are interested. Thanks. P.S. You do not necessarily need to use Python and Selenium if you know any other way to handle this.

...professional data analysis team with talented and passionate members who have work experiences in top-tier consulting firms. Our motto is "Politics First." Our team is just as forward-thinking as our analysis. By providing expertise on how political developments move markets, we help clients anticipate and respond to risks and opportunities. We are now looking for a Researcher to join out Global Macro practice. We hope that you are capable of conducting research, data analysis and trend identification, and you can help to produce reports and analysis to support data-driven decision making for our research team. We prefer that you are students based in the US and enrolled in an undergraduate or graduate degree program in computer science, public management, interna...

I have two Files One is a PDF File that has Forms to Fill Second is an Excel Sheet I want to Run the Macro that shall fill the entry in the Excel. I need to update the Price and the same should always fill in the PDF form.

...wrote a macro that opens each powerpoint files. I found a macro that used within powerpoint VBA removes unused masterslide but doesn't work when I include it in my Excel macro... Also I don't manage to save and close each ppt files. Macro that loops through files : Dim myPresentation As Object Dim PowerPointApp As Object Set myPresentation = CreateObject("") 'Find last row of path files list lastRow = Cells(, "A").End(xlUp).Row 'Looping through files For i = 1 To lastRow 'Defines pwp file to open DestinationPPT = Cells(i, "A") 'opens pwp file DestinationPPT = True 'Then I would like to : remove unused master slide, save, close Next i End Sub M...

Financial macro in vba with automation

Financial macro in VBA with automation

I'm using an application to upload videos to a specific platform with a few clicks I would like to fully automate this process When I click upload you can probably sniff a packet and replicate it continuously using requests Right now I'm working with a macro but I would really like it if someone does this full API using requests This should be a really small job and quick job

I need a macro for Corel Draw. The purpose is to measure lenght of a selected curve or curves, multiply it for a certain factor and show the result. The macro will help determine prices for laser cutting different materials, like Laminated wood or acrylic.

Due date: within 12 hours. Please see original file and sample dashboards attached. I want the dashboard in excel and google drive. I need help creating a colorful/visual dashboard from Excel. Its a simple file that shows...attached. I want the dashboard in excel and google drive. I need help creating a colorful/visual dashboard from Excel. Its a simple file that shows the customer's name and ID, the task number and the status of the ticket (open or closed). This data will be updated daily to show reduction in open tickets so I want to be able to upload a new data file to refresh the dashboard. Create a 'click here' macro that I can click to enable data refresh breaking down the data by task number, customer name, ID, etc. For rows without customer name, 0 will ...

There are two books(book 1, book 2). One has to write a code in excel VBA and create macro in book 2 to send the two books (book 1, book 2) as attachment in outlook mail. And give a subject and body, where body should contain data from book 2, ie. filter in pass/fail column for missing data and get the details to be shared inline in the mail.(please see the book 2 for reference).

What I need is to extract all the team results (goals) from: I need a MACRO that when putting the results web of a team copy and paste them automatically, for example the last 350 matches, and order them in a certain way. Example: If I manually copy and paste (especial paste only text) this data in excel I get what you can see in IMAGE 1. I need those data and goals to be ordered in a certain way: 1. column A, date 2. column B name of the team's rival 3. Final result team's goals 4. Final result opponent's goals 5. First half team's goals 6. First half opponent's goals (SEE IMAGE 2) - I need the results order of a team ALWAYS in the same column, no matter if they play as local

I need guidance to automate some tasks in MS Excel using power query and/or macro. It involves merging of different Excel files and looking up some reference file to develop reports and charts for analysis.

What I need is to extract all the team results (goals) from: I need a MACRO that when putting the results web of a team copy and paste them automatically, for example the last 350 matches, and order them in a certain way. Example: If I manually copy and paste (especial paste only text) this data in excel I get what you can see in IMAGE 1. I need those data and goals to be ordered in a certain way: 1. column A, date 2. column B name of the team's rival 3. Final result team's goals 4. Final result opponent's goals 5. First half team's goals 6. First half opponent's goals (SEE IMAGE 2) - I need the results order of a team ALWAYS in the same column, no matter if they play as local

Identify and analyse the use of different approaches

I need power point presentation of all the four topics. The total slides of each Ppt should be under 10 slides and under 999 kb storage and should be converted to pdf.

I have four columns of data, A-D, I need the data from columns C and D underneath the data next to it, example, C1:D1 need to be under A1:A2, then C2:D2 under A2:B2

I would need a macro vba option that will action a refresh on the power query Folder DB every time that a new folder is added into the Folder DB. I would need this action to be triggered without the need to press any button, only as soon as a new file is added into the Folder DB. Please assist and confirm

...require an excel macro which will compare the values of cells in the rows of one workbook created today (eg: attached "today file") and compare it to the value of the cells in the rows in a workbook created yesterday (attached "yesterday file"). A new version of the today file will be created (attached "file created by Macro") with all the same data but highlighting the cells where the value is different by changing the background of the cell to green and adding a note stating what the value was in "yesterday file". Also if a new row is identified highlight the row in blue and change the text to white. A legend also needs to be added to the bottom of the sheet as seen in c39-41 & D40-41 of "file created by Macro. ...

We have raw data that contains sales information including sales agent ID, time of sale, and what they sold, Each sale needs to be converted into an hourly value for each sale. This needs to be completed weekly. We need to have the macro spit out a PO for each sales representative based on the hourly value of each sale. I’ve included a “raw data” file example.

Student should have good knowledge in macro economics. Its a small project ends in August.

Macro economics expert required. Place bid if you are available tomorrow at 3:30 pm Kuwait time.

...professional data analysis team with talented and passionate members who have work experiences in top-tier consulting firms. Our motto is "Politics First." Our team is just as forward-thinking as our analysis. By providing expertise on how political developments move markets, we help clients anticipate and respond to risks and opportunities. We are now looking for a Researcher to join out Global Macro practice. We hope that you are capable of conducting research, data analysis and trend identification, and you can help to produce reports and analysis to support data-driven decision making for our research team. We prefer that you are students based in the US and enrolled in an undergraduate or graduate degree program in computer science, public management, interna...

simple project... need a macro or Extension or something similar to change a spreadsheets columns and do some easy math. See SS for example SS will stay in the same format

What I need is to extract all the team results (goals) from: I need a MACRO that when putting the results web of a team copy and paste them automatically, for example the last 350 matches, and order them in a certain way. Example: If I manually copy and paste (especial paste only text) this data in excel I get what you can see in IMAGE 1. I need those data and goals to be ordered in a certain way: 1. column A, date 2. column B name of the team's rival 3. Final result team's goals 4. Final result opponent's goals 5. First half team's goals 6. First half opponent's goals (SEE IMAGE 2) - I need the results order of a team ALWAYS in the same column, no matter if they play as local

Need to create macros for my few excel workbooks

...requirements(Just the requirements and not the scope, purpose or other details) from a User requirements document to another word document(supplier form) using a macro. Currently I open the supplier form, press a button to inport the data and this creates a pop up to input the file location of the a User requirements document, the macro then copies over the requirements from the a User requirements document to a table in the supplier form. I have to deal with a lot of different formatted User requirements documents from different companies and this macro is not accepting all the different formats and it is really slow. I need someone to either update the macro I have to accept all formats(i do not have all the formats as i receive new ones every week), speed...

When a user enters a new issue ID number and hits the "Enter" key, a sheet should be created with that ID as its name, it should be pre-populated based on the template provided. Since it is a template, we don’t want users messing with it, you can hide sheets at the bottom. Unhide the sheet in this workbook and use it as the template when creating a new sheet. Google is your friend for this one. Requirements: A sheet should not be created if the ID number is empty The function should only work if the "Enter" key is hit while in the ID column of the table You should be making a copy of the template sheet rather than building it from the ground up in code hint: It only takes ~20 lines of code to make this work, if you have more, you have probably used the wrong fun...

Hi Milan Here is the project as discussed

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

Macro Oil Research Website Investing Market Research Sales Dark, Black, Red, Silver Color palettes.

Book 1: we will have a table with Student name, sub1, sub2, total... total, percentage, pass/fail Book 2: roll no., Student name, it will also have two columns pass/fail and total but that pass/fail and total data we have to get from book1 as the students name in book2 will have some similar name as in book1 also the names in book1 might be in this order (lastname, firstname) but the names in book2 are in order firstname, lastname. This all will be done via a macro present in book2. Also there might be some extra names in book2 which are not present in book1 so for that case in pass/fail column we have to update as missing record. And then we have to send book1, book2 and the missing data table that has to be shared in the mail. Please see the attached pics for the steps and ins...

I will give you a table , has list of names, titles, and hire date. I will also give you another table where it has title , Month range, and hours expected. I want excel sheet to be able to : 1-accept number of month to forecast (Number in Month) 2- Generate forecasting data table 3- Generate Forcasting Data2 and graph example attached

I need the macro coder needed for multiple jobs. Details will be discussed.

End to end Program in python for Live 'option chain data' & 'Future Data' download through ZERODHA KITECONNECT API. Part1: A program for Live Option Chain dat...Stock code, Expiry Date ( to be fetched from an Excel) 2. Program shall be scheduled through Task Scheduler 3. Live Option Chain Data to be downloaded (Data from the live excel sheet) and saved in Download Folder. Download 'file name' to be taken from an excel. 4. Data format to be exactly same as that of the Option Chain data available in the NSE site 5. After data download, It will call an excel Macro for the Next activities For Future Data: 6. Similar to the above, Future data for the next 3 expiries to be saved in an excel file. Data format to be similar to that of the NSE site data. ...

I have a Google Excel sheet with some data .need to create a dashboard with this data using Microsoft Excel macros.

I need help creating an Outlook macro that will add an email to an existing Outlook task.. The program should be able to allow me to select an email from the inbox, then click on the macro button to : 1) create a new outlook task based on that email or 2) add that email to an existing outlook task.. For now actually, I would just like the macro to allow me to add an email to an existing task and then a pop-up window would allow me to choose which outlook task to attach it to. Write OUTLOOK MACRO at the starting of your proposal. Only bid if you can do it. No time wasters.

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

...for x milliseconds (e.g. 300 milliseconds as indicated within the waiting_time variable)and do nothing - Then it will highlight the next chunk of words and remove the highlighting from the previous chunk of words This needs to be programmed in MS VBA and should work on large MS Word files - ebooks. The macro should be able to skip images easily, page numbers, and any text in the header and footer. the purpose is to speed read the titles and text within the document body only. The macro will have a dashboard that is user-friendly so that the user can: - start/stop the speed reading - insert reading speed in WPM words per minute e.g. 600 - insert chunk size (# of words per chunk) e.g. 3 As key variables in the code: - please use the same naming chunk _size: refers to...

Hi Please find attached a new Macro I require If you refer to spreadsheet I have written the rules required for this And how to display returned data Thanks Please see attached file which has info required

i need to save a list of invoices to pdf from my accounting sys. via looping till end of the list from excel using macro recoding program or any program recommend. need to save it in a folder

improve macro script to fetch json from database

I have 2 Excel VBA macro subs (named GetTheData and SaveTheData) to download data and save results after the sheet recalculates. They are both listed below and work OK. I use Excel 365. I wish to accomplish the following: Name the macro "Macro_Timer" 1) start the macro running at 06:35 each morning or when I open the file if after 06:35. I can easily add a button to start the macro. a) If not too difficult, I'd like the time to start be the time in New York City, New York time 09:30 so that no matter where I am globally, it starts with the stock market opening. Time in NYCity is GMT-4 except when switching to/from Daylight Saving Tme. London and New York have different dates for switching to daylight savin...

I have simple Word VBA project. This is simple project. I will share details via chat. I hope to finish today.

I am assuming this is a quick fix for a confident coder. I have a current VBA code that works from another free lancer, however, it does not put photos in the correct order from the folder. The way this macro works is, it places photos in tables on MS word with captions underneath. Currently for some reason it randomly mixes up photos and does not transfer the photos in order as per the folder they sit in.

We have a shared email inbox with a subfolder. We file every email in the single subfolder. I want a macro to forward every email we drag and drop into that subfolder to a set and single address But it needs to go immediately and it needs to be able to work when 8 people or more are accessing the same inbox and subfoler

Tengo una tabla en excel y necesito crear unos documentos a partir de esta tabla. Incluir capacitación.

I have a main excel file which exports a table to a separate sheet and saves it. I need to print labels based on the table data automatically without doing it manually from word. The print file must be saved with the name associated with a cell in the table. The labels are 2 per A4 sheet vertically. I already have a basic template for the labels.