Indusoft macroemplois
The project starts from a pre-filled Excel which must be further formatted. Then, the data must be copied to a Word template. I have a very detailed set of instructions. Importantly, the Excel document may have a varying number of rows. The data of each row must then be copied to a table in a Word document. Word report must be construed from a template, where the data in each paragraph corresponds to a row in the Excel document.
I would like the collection of a dataset, through a combination of instagram, scrapping on the internet for micro and macro influencers.
I need the macro expert for multiple jobs. Details will be discussed.
See attachment for the process. There are 2 excel files. File 1: data sheet, columns with data and a cell where you can input an ID. In this example there are 40 IDs. Based on the ID numbers the according data is being fetched. So for each ID this sheet 3 columns of data is changing. File 2: general template where you have one excel sheet where this data for each ID should be pasted and the excel file should be saved as the ID name. So copy three columns for each ID from file 1 to this template excel file, every time on a fixed position. Save the excel file and repeat again the process till the last ID in this case 40 ID's.
need to apply macro for the currency converter. when click USD all numbers need to change to USD value. let me know then I can send you the file.
...with 2 complete and 10 in progress, I want to be able to filter the pie chart or histogram to show that information per owner. 2. Macros: I want a separate datasheet where I can update daily data that will reflect in the dashboard. 3. 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 populate in those tabs. 4. I need something colorful and executive level quality that's compatible with google sheets. I attached a simple file that shows the customer's name and ID, the task number and the status of the t...
...spreadsheet (see attachment) - also would like a way to add/update a sepearate rlist - so I don't see certain "Payees" and can remove lines with "keywords" - perhaps save a text file in the folder. Want to have deposits for each month as a sub total and expenses as a subtotal - so add a lines at the bottom and be sure that tall totals are correct and recalculated if needed This should be a macro - so that if I get a new copy of this csv then it will be updated, as described above. Any information that would help me would be helpful; ask me. let me know your thoughts and any questions While this is hourly; there is a max of $15 that I can pay, as being a cancer patient is tuff and been out of work. Hourly will give you more $ as there is less mo...
I need the macro expert for multiple jobs. Details will be discussed.
I need help in selecting and scripting a macro so I can complete redundant tasks on my desktop. I've tested a few hotkey apps such as those listed below but I cannot get my macros to run. I need help in selecting the best app and as well as scripting 3 simple macro tasks. The app we use needs to be hidden in the system tray and auto-start when the PC boots so I am able to use the hotkeys without opening the app. In addition, I need you to instruct me on how to password protect the folder the application is located in or password protect the app to prevent snooping eyes. THIS PROJECT IS MARKED URGENT! ShortKeys AutoHotkey HotKeyBind HotkeyP
Minor change existing Macro in excel
Hi All, I would need an Excel macro able to gather market closing stock prices from Yahoo Finance from a list of ISINs/tickers both from historical and current period. The macro should write directly on excel sheets without previously download historical data Any questions, please let me know
...given area such as restaurants/bars, grocery stores, convenient stores etc..(this one will be similar to Walk Score’s heatmap) Second map: All organized events such as concerts, conferences, sporting events, expo’s, citywide events etc.. in a given area. Third map: The vibrancy of a given area(this will track the average volume of people in an area (picture Google’s popular times on a macro level)) Fourth map: Average median income map Combined map: Layering these maps on top of each other to see where they overlap depending on specific criteria. Technical Features: Location Lookup A toggle view for each map Opacity option slider Hover data point feature Step two: The ability to go back over a specified amount of ...
I need help in selecting and scripting a macro so I can complete redundant tasks on my desktop. I've tested a few hotkey apps such as those listed below but I cannot get my macros to run. I need help in selecting the best app and as well as scripting 3 simple macro tasks. The app we use needs to be hidden in the system tray and auto-start when the PC boots so I am able to use the hotkeys without opening the app. In addition, I need you to instruct me on how to password protect the folder the application is located to prevent snooping eyes. THIS PROJECT IS MARKED URGENT! ShortKeys AutoHotkey HotKeyBind HotkeyP
Hi zoltan, it's also blocked on the other account and only with you, in both of them I can send messages to other freelancers, so it seems that the problem cames from hour profile, i'm trying my best to give you the milestone for the last project
Hi Amr E., Please accept this request. Thanks.
Hello i need the Macro coder needed.. for multiple jobs. Details will be discussed.
..."patient banner" or "patient ribbon". (Actually the "charts" toolbar or banner is above it which shows open charts) Below that will be the "note banner" which displays information about the note to be built Lastly, there's the problem list toolbar which does the following: Problem list toolbar (the new concept as discussed). Toggle button to show all vs show active Search field to add problems Macro icon to add multiple problems + sign to add new problem Toggle to show all problems brief vs comprehensive The latter has yet to be designed. It would be nice to send them the entire page but this is a start. I can send more information to those who may be interested. Again I want a functional prototype but for the final develo...
Hello i need the Macro coder needed.. for multiple jobs. Details will be discussed.
Web are planning to export some data from another Excel so I need expert in macro and accounting fracture
I need a macro for Corel Draw! Basically the user selects a group of curves and the macro calculates the he total lenght of the curves and miultiplies this by a certain factor. I will use the macro to calculate the cost of cutting material with a laser cutter. This description covers the basic function. It needs some other minor factors included for full functionality. It is mandatory that you have worked with Corel Draw and are familiar with the measure curves command, the eavesdrop tool and other basic commands.
...below, although as mentioned I would like to make this dynamic). The final bit is when I have created the data set using Proc SQL how I insert the month end date into the final data set name so that I have (in this case) 87 data sets with different names reflecting the different month end dates The next thing is that I am posting this at 9am UK time July 28th and need turnaround in hours %macro get_data(start=, months=87); /* Convert start/end values into SAS dates */ %let start_dt = %sysfunc(inputn(&start., date9.)); %do i = 0 %to &months.; /* Calculate the start and end months for the month of data in the loop */ %let month_e = %sysfunc(intnx(month, &start_dt., &i., E) ); %put %cmpres( %sysfunc(putn(&month_e., date9.))); /***********...
I need someone to help me create a macro for Excel that will cycle through the table and print the contents of the town on a single sheet
I'm Looking for a macro expert who can help me with my excel project. Just need to automate with the help of macro. For more details please DM
I am looking for either a web designer or PowerPoint macro expert to put PowerPoint slides on web. I have slides ( 30) and first page there is a button to press and then a random slide comes up displays a message for 10 second. Before returning to the first page again Possible to have music in background
...maximum one as the state value. One thing you need to pay attention, is there are three special squares or states: wall (1, 1), diamond (1, 3), and pitfall (2, 3). For these three states, you don’t need to update their state values or q_values. Some other information: There are several important variables you need to use when you implement the above two functions. These variables are defined in the macro (on the top) of the “MDP.h” file. (1) “TRANSITION_SUCCEED” - the conditional probability of successfully reaching the next state as expected. For example, when you take the action north, you have 80% probability arrives at the north. (2) “TRANSITION_FAIL” - as the opposite part of “TRANSITION_SUCCEED”, you have 20% of probab...
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...
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. ...
