Macropekerjaan

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

Sila Dafter atau Log masuk untuk melihat butiran.

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.

Sila Dafter atau Log masuk untuk melihat butiran.

...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.

...format Sport(3 letter code), discipline (3 letters code), title of event, gender(m,f,X), end_date(DD/mm/yyyy), task(text)., Assigned to team(3 letter code), A sample file is attached. Please open it and make sure you understand The Excell file is always work In Progress and spans on 4 year period.. The file can be in the sharedrive ideally or in my pc. I would like to be able periodically to run a macro or import or function and assign reminder tasks in the calendars of the team members that are assigned each entry. As this operation will be done again and again. Each time I want my outlook/Gmail calendar to have only the ammended entries and not to duplicate everything each time. I am open to modify the format of the file. It's a very small automation project. As this is ...

to implement an algorithm that is defined in an excel file

Write a macro or macros, one for each tab (tan and blue) that will copy the Concat derived plan number in the DIY Plan Origin and # L16 to N16 the cell immediately to the right of column L beginning in row 16 for all rows to 277. Be careful because rows 216 to 218 are not involved. You may need a separate macro for rows 219 to 277. Now do the same for the Production Builder Tab for N16 copied to O16 This must be at text cells that udates each time the macro runs

Add code changes in a VB-MACRO

HI NEED MACRO FOR EXCEL FOR MY WORK

HI NEED MACRO FOR EXCEL FOR MY WORK

I need an excel macro thatcopies an Invoice number down a column. When the value in a 2nd column changes, then the Invoice number increments by 1. I currently do this with conditional formatting, but need it automated.

i want the existing macro need to fixed. small job only . aud 15$ is budget

...develop a Excel macro script using VBA. The following criterias are required for the function of the macro: 1. Able to read and extract data files similar to the one attached () 2. Process and output the input data () into a new tab called "Analysis Output_XXX" with XXX being the file name, i.e. Analysis_Output_XJO 3. The "Analysis Output" tab should contain the following data structure: - "Month" Column that only shows each month of each year based on the input data - "Close" Column after "Month" that shows the "Close" data of the last day of the month based on the associated "Month" - "Delta" Column that takes the differences between the "Close" Column data o...

I want to build a Cloud Base CRM that is operational and analytical With specific features : mainly for a credit repair leads and customer data storage. Functions include API capability and Cloud Access SEO Billing API Email API Dialer outbound API Excel upload download function Customer data name address etc ...With specific features : mainly for a credit repair leads and customer data storage. Functions include API capability and Cloud Access SEO Billing API Email API Dialer outbound API Excel upload download function Customer data name address etc Leads fields add delete Status flag labeling Automation of work flow tabs Generate Letters Integrate Credit Bureaus Reports API Letter generator macro Plus much more I’d like to speak with you more to give more...

I need a Programmer to do a macro for me.. Details will be provided in the chat Budget for the Work: $25 * Payment will be done 3 days after the work is complete.

I need someone who knows the current facebook group structure (or are on facebook and can be added to my group as a moderator to learn the button sequence to delete media) to write macro commands so i can run a script to delete all the photos and videos in my facebook group that I own. I already had a free script that I used to delete all the posts but I cant find one to delete all the photos and videos so I need a freelancer to create one.

1.) Update the navigation pages to a. Home b. Daily Heat Map c. Macro Economic Indicators – This should look like the Daily Heat Map once it is completed but it will have different tables. d. Micro Economic Indicators - This should look like the Daily Heat Map once it is completed but it will have different tables. e. Housing Market Indicators - This should look like the Daily Heat Map once it is completed but it will have different tables. f. Stock Ticker Analysis g. ETF 2.) Update the banner page to the attached 3.) Rename Global Indices page to “Daily Heat Map”. a. Add 3 Column headers that will be above 3 sets of tables. The current set of tables is Global Indices, Move the Commodity table logic to the second column of tables and then a 3rd column will be Se...

Se necesita una Macro que luego de Exportar datos en Excel a un Documento Word en específico a través de "combinar correspondencia", realice lo siguiente: -Que divida el documento en múltiples Páginas. -Que pregunte la cantidad de páginas que tendrá cada Documento. -Que pregunte si se desea en Word o PDF los Documentos Separados. -Que pida La ruta donde se guardarán los archivos. (Puede LLamar a Ventana Examinar) -Que en el Guardado de los archivos se guarden con el Campo Combinado "Serie".

I need someone who knows the current facebook group structure to write macro commands so i can run a script to delete all the photos and videos in my facebook group that I own. I already had a free script that I used to delete all the posts but I cant find one to delete all the photos and videos so I need a freelancer to create one. I can make you a moderator in my facebook group so you can have access to the page structure from a moderator standpoint.

1.) Update the navigation pages to a. Home b. Daily Heat Map c. Macro Economic Indicators – This should look like the Daily Heat Map once it is completed but it will have different tables. d. Micro Economic Indicators - This should look like the Daily Heat Map once it is completed but it will have different tables. e. Housing Market Indicators - This should look like the Daily Heat Map once it is completed but it will have different tables. f. Stock Ticker Analysis g. ETF 2.) Update the banner page to the attached 3.) Rename Global Indices page to “Daily Heat Map”. a. Add 3 Column headers that will be above 3 sets of tables. The current set of tables is Global Indices, Move the Commodity table logic to the second column of tables and then a 3rd column will be Se...

i need the excel macro only for multiple jobs. Details will be discussed.

i need the excel macro only for multiple jobs. Details will be discussed.

develop macro on excel develop macro on excel

Need quick macro to delete cells based off criteria on another sheet Filter MD Rankings Field 2 (Market) by the list on "Switchboard" in O2:O5

...Lieferantenlogistik“ VBA export in the source file, exports automatically the content from the source file "Client Confirmation Processing" , tab “Ausgabe AB Home Delivery Export” into the target file "HD Auftragsbestätigung Lieferantenlogistik" Task 1: Create macro command button: - Tab: „Ausgabe AB Home Delivery“ - top left corner in cell A1 on top of Order number - Command button name: „Export“ Task 2: Create a new tab “Config” - In this tab allow us to add manually the path and file name of the target file used by the macro. This will allow us to rename the target file if needed. Task 3: When the export button is pressed, then: - Transfer the whole content (the entire sheet) from tab ...

I am a personal trainer looking to create an online-coaching business wherein clients would check in weekly and as needed via email. I would provide education, custom training programs, diet / macro plans and would be available for Zoom meetings on an as needed basis. I would need a website to serve as a home for the business, and provide and attract potential clients as well as eventually sell clothing and literature. This site need not be complicated: it should be simple and to the point, easy to navigate, and render it easy for interested parties to reach out to me. I am note intending on being an app-based trainer-- I want to be a little more hands on than that at this juncture. Additionally, in an effort to grow the business as quickly as possible, I would like the site op...

Copy and paste track changes and comments from one word document to another word document. The macro needs to work in other files as well. The work is 70% complete, need someone to complete it The macro also needs to build a report of the changes from the old file Max Budget : $20

i want the existing macro need to fixed. small job only . aud 15$ is budget

Sila Dafter atau Log masuk untuk melihat butiran.

Requires transition from excel to gsheets. However, macro style is different. Will require the exact same function from excel in google sheets. Excel file will be provided once job confirmed. Thanks. Lead time is arnd 1 week if possible

For jewelry, prioritizing macro shots with and without model

For jewelry, prioritizing macro shots with and without model

Hi all, I need a vba / formula macro