Project macrotrabajos

I would like to have an Excel specialist in order to convert fields into a xml format automatically, See the format below.

Need to make a macro that can run on the attached sheet (data source) and add a column with the value based on rules. The data source layout will always be the same. That is it will have the same number of columns and start on row 10. add column AC. The title for AC on row 9 will be “Status”. For each of the rows of data (starting on row 10), AC is to be set as follows based on the values in T, W, X, Z and AB. - If T, W, X, Z and AB are all populated. AC = Delivered - If only T, W, X and Z are populated (AB not populated AC = Arrived - If T, W & X are populated (Z & AB not populated) AC = Shipped - If T and W are populated (X, Z & AB not populated) AC = Booked - If only T is populated (W, X, Z & AB not populated) AC = Placed

Hi Rashed, I have a new project for you. This should be somewhat simpler than the previous. I would like a macro that can run on the attached sheet (data source) and add a column with the value based on rules.

Hi Rashed, I have a new project for you. This should be somewhat simpler than the previous. I would like a macro that can run on the attached sheet (data source) and add a column with the value based on rules. The data source layout will always be the same. That is it will have the same number of columns and start on row 10. I would like the macro to add column AC. The title for AC on row 9 will be “Status”. For each of the rows of data (starting on row 10), AC is to be set as follows based on the values in T, W, X, Z and AB. - If T, W, X, Z and AB are all populated. AC = Delivered - If only T, W, X and Z are populated (AB not populated AC = Arrived - If T, W & X are populated (Z & AB not populated) AC = Shipped - If T and W are popul...

Looking for an excel pro to setu pa macro that takes seperate excel file reports and consolidates all sheets in different xls fils into a single file with a specific format. Must be quick and easy also on a tight budget.

I need a google chrome extension thats very simple it just has to be able to follow people... that's it, nothing crazy its just a macro that could work in the background

The initial situation of the project is the following: Currently there is 39 sheets in the attached Excel file Each sheet is using some of the data from the previous sheets to make analysis, but not all of the data is used, some is unnecessary. I know that after the 16th sheets all the data is correct. So the first 16 sheets are the one to modified; you only need to removed the cases that are in the first 16 sheets and not used in the following 23. So you need to Create an R markdown script (or VBA script using Excel macro) that will scan and simplify the Excel document so that the unnecessary and unused data are removed from the Excel file. The Output is an R database with a markdown script and an Excel file. Please contact me directly if you can do it as I receive a lot...

Hello, i need to create a system to transform a CSV with 12 columns, to a 3 columns CSV. Take some data and merge in one field, y change some names in the columns. Is a bank statement transformation to get my accounting system accept that file. If you are interested place the word macroman in your proposal. The budget for this task is u$20, with 5-star rating. I need this asap.

I need to automize a simple request with macro and VB code i'v a database and i nee to extract data from it (extern excel)

I need to get data from a website to excel. please bid if you can really do this. I want to finish this ASAP

I need the excel expert for multiple jobs. Details will be discussed.

...Stats: ***** All except: -weight used for calculations Activity level would be based on their answer to "How many days are you currently doing cardio" Program Type = Do you have an idea of the nutrition style you're interested in? (Google Form) Keto = Ketogenic Nutrition Intermittent fasting = Intermittent fasting Custom/other = Intermittent fasting with ketogenic nutrition OR Balanced macro nutrition with evenly spaced meals throughout the day Trans IF Keto = IF "Are you transitioning genders?" = "Yes - male to female" THEN select this option BUT if they have selected one of the other options above for nutrition style, then please override this with their nutrition style selection. ***** Diet and food ***** Allergy informatio...

I have a database of recipe names (which I add to weekly) I have the total amounts of calories, protein, carbs & fats for each recipe. With each of my clients I adjust their calories and macro intake every couple of weeks so I need to give them different recipes. I would like to have a separate sheet where I can add in the meals I plan to give them and it adds up the calories etc as I go so I can make sure it adds up to their targets. I would like it to be super easy to add in new recipe names weekly too (not have to update formulas each time as I have no idea!)

Por favor, regístrate o inicia sesión para ver los detalles.

Transform the raw data (csv) to excel specific format

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

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

Macro coder needed. small job. Details will be discussed.

Macro coder needed. small job. Details will be discussed.

Macro coder needed. small job. Details will be discussed.

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

excel macro coder needed for multiple jobs. Details will be discussed.

Macro coder needed. small job. Details will be discussed.

Macro coder needed. small job. Details will be discussed.

...expert in doing full feasibility study including the high & best use for a potential project of m2 1.26 million. The initial plan is to divide the project into 4 phases, the first phase will be dedicated for used goods (including Furnitures, utensils, electronic & etc) while the rest will be allocated for other sectors based on high & best use recommended by freelancer. Main Deliverable - Feasibility Study including Highest and Best Use Study From our understanding, our main deliverable will be Feasibility study for the land which will include the following activities 1. Site Assessment - Highest and Best Use Study I. Site Analysis II. SWOT analysis 2. Market Assessment - Highest and Best Use Study I. Macro and Socio-Economic Assessment II. Real Est...

create macros to work with a huge amount of data and for Excel reports & automate repetitive tasks responsible for creating these macros and ensuring they work as intended developing new features or improving existing ones Maintains current and newly developed macro programs per user requirements. Develop VBA Programs to perform task Optimization of processes using Excel Establishment of cross program work flows Reviewing code to ensure best practices are in place TECHNICAL KNOWLEDGE: Strong working knowledge of: o Macro (VBA) on MS Office/MS 365.

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

I want use mouse move function like "mouse_move(int x, int y)" for macro in video game. But game blocking this because of they thinking i want use this function for another things. But i want use it for only macro, not for another bad things. I found an app and it's working in game. You should reverse this app and get mouse_move(int x, int y) function. So i can use it in my c++ project.

Retrieve data from 2 source files and generate a third file

I have a google spreadsheet with a list of symbols/stocks (NASDAQ, AMEX, NYSE, etc) with their prices. I have a created a column ''Next Earnings Date''. I would like someone to create a macro to automate the process of always displaying the next earnings date when I enter a new symbol. I know we can access the list of historical and future earnings, for instance TSLA, here: It might be useful.

We are building a new social media application based on Birthday, Gifting, Birthday reminder, and Charity donation. We are looking for expert people/companies who can suggest the best name for our new company/application. Here is something m...a .com domain available or if the name is way too good and if it is having less competition then we will consider the .app domain as well. 3. Name MUST be UNIQUE. There must not be any app existing with that name in the market. 4. It should be easy to pronounce and have very simple spelling. Ex: Google, Twitter 5. Name must be a one-word only 6. Here is the list of a name we like: Onviqa Google Macro Veeva Slack Twilio Stripe Elastic Zoom Intercom Gusto Druva Odoo Looking forward to seeing some great entries from innovative naming creators. ...

I need a macro coded so that I can update 20 powerpoint text fields with data I input into excel and so that it saves a new version of the file and a separate new pdf version. Should be a quick file for someone that knows VBA.

Hi Rashed, I hope you are well. I have a new project for a simple macro. Our users will generate a report as per attached containing sheet “Loose, LCL and Other Deliveries” This report is run either weekly or monthly. Th emacro needs to do the following. Starting at row 7 Delete all rows where Q is not ROHLIGAKL Delete all rows where G is not AEDXB, AUSYD or AUMEL With remaining rows, - Column R is an address with line breaks. We require the 3rd line and can remove the rest of the data. This will leave a suburb of Auckland and it should be converted to uppercase. Eg: WELLINGTON, MANGERE, AUCKLAND, etc - Insert new column S which will be determined by the value in column R. o AUCKLAND = 1 o WELLINGTON = 2 o CHRISTCHURCH = 3 o Everything else = 4 - Inser...

Hi, I need a power point macro programmed so it automatically updates a powerpoint presentation from an excel sheet. Should be a quick task and will provide full instructions. Please confirm you are strong in powerpoint vba. Many thanks, Benedict

Hello, I have several excel sheets in the same excel doc, each sheet has it's own vba macro and they all has the same code, anyway i need them to automatically run every certain time, i have done my search for that topic but none of the simple code i found is working. Could you please help me with that. Thank you, ----------------------------------------- vba code sample. ----------------------------------------- Private Sub Worksheet_SelectionChange(ByVal CountrySize As Range) If <> "$O$5" Then Exit Sub = False Dim ws As Worksheet: Set ws = (7) Dim r, r2 As Range . . . . . . . Call otherMacro End Sub Private Sub otherMacro() = False Dim ws As Worksheet: Set ws = (7) Dim r

Hi, I am looking macro/script for below needs. I have inventory system which export products and we call it raw data. we looking to stock take time to time and upload back xls in inventory to adjust qty for products. to make this process seamless we need below process. we have excel sheet preapred with vlookup fromula where we scan barcode and pull the product information. raw data = export products from inventory stock count = our file where we scan and count products we determine suppliers from products based on sku code formate 1. There will be two excel files, 1 - raw data , 2 - stock count 2. run the macro, ask supplier code 3. from the raw data file keep all data from selected supplier and remove all other products that belongs to other supplier + make column #AA ...

Hi, I am looking macro/script for below needs. I have inventory system which export products and we call it raw data. we looking to stock take time to time and upload back xls in inventory to adjust qty for products. to make this process seamless we need below process. we have excel sheet preapred with vlookup fromula where we scan barcode and pull the product information. raw data = export products from inventory stock count = our file where we scan and count products we determine suppliers from products based on sku code formate 1. There will be two excel files, 1 - raw data , 2 - stock count 2. run the macro, ask supplier code 3. from the raw data file keep all data from selected supplier and remove all other products that belongs to other supplier + make column #AA ...

Find specific data from raw data sheet and input correct data into another spreadsheet

I have a large MS Word mail merge document where I'm having trouble pulling dynamic values from MS Excel and keeping the hyperlinks inside IF Statements and nested IF statements. I'm also having the same issue with the FILLIN option. Finally, I'm just generally having issues with dynamic hyperlinks and mail merge in this document, even when it's not inside an IF statement. I need to create a macro that will resolve these issues and create a new Word document that is editable, so that we can make any final changes. I'm looking for an expert with MS Word with skills for Mail Merge and custom macros.

I need the Macro coder with api knowledge , details will be discussed.

I need the Macro coder with api knowledge , details will be discussed.

Olá, se você conhece e tem contato direto com grandes influenciadores brasileiros e sabe quais os influenciadores que estão em alta isso é pra você Com a sua ajuda vamos contratar os influenciadores para divulgar a nossa marca e você vai ser a ponte até esses influenciadores Diferencial: - Já ter fechado parcerias com influenciadores antes - Tenha resultados com parcerias com micro e macro influenciadores

I want to look up a value in a column ( multiple values exist) and look up to match (another series of values) in another column and then add up all the values in another column that matches the first two cretirion

need a macro button solution to automatically make an image that is dragged to a Word page Go to Back, Behind Text and Fill the Entire Page (one page in a multi page document only)

SIAMO UNO STUDIO DI TRATTAMENTI E UN'ACCADEMIA DI FORMAZIONE CIGLIA E SOPRACCIGLIA. ABBIAMO UN E-COMMERCE DEDICATO CHE VENDE PRODOTTI CIGLIA E SOPRACCIGLIA. Abbiamo bisogno di realizzare 4 icone per le 4 macro aree della nostra Azienda: CORSI (deve essere un cappellino da laureato) PRODOTTI COSMETICI (può essere un flaconcino piccolo o piccola bottiglietta vetro con liquido) TRATTAMENTI CIGLIA (deve essere un occhio con lunghe ciglia e un bel sopracciglio) SHOP ONLINE (nessuna indicazione.. lo stile deve essere coordinato con le precedenti icone) LE ICONE DEVONO ESSERE IN FORMATO VETTORIALE sono graditi disegni 3D

I'm looking for someone to add the following functionalities to the Visio Data Visualizer in excel, either trough a macro or other solution: - x,y coordinates to ensure control over the flowchart output - Shape fill color (ability to control the internal color of shapes) - Shape outline color (ability to control the Shape Outline)

There is a excel sheet in which around 15 Columns . The details are in small one pdf file. I want that you make a excel macro for this

Need to create macro for MS word. I have report that need to populate via macro.

Need to create macro for MS word. I have report that need to populate via macro.

excel macro coder needed for multiple jobs. Details will be discussed.