...spreadsheet and then run a macro that will go through each row and enter the cost price for the part sold from the other sheet (costs). I need the cells to contain actual data and not a formula, that is why I want to use a macro. If the part on the sales sheet cannot be found in the costs sheet then the price should be set to 999. The macro needs to have the
Search data in one worksheet and display in another. Quickbooks Sheet = Cognito Export A= AJ B= D,E (no spacing; Exact Order) C= AI D= AK E= C (Day/Month/Year Format) F= AL G= F, G, Y, AO, AP, AQ, AR, AS, AT, M, O, Q, S, U, W, Z, AB, H, I, D (Spacing between each; Exact Order;) H= AH I= E,AI (No Spacing; Exact Order) J= AM K=AN *Data needs to be added to row in one fluid motion *Both sheets will ...
I need a macro in excel that logs onto a web site, simple navigation to a page in the website (one click away), enter some information and then press the submit button. The web site has aviation weather information and you can set up an account for free to do your testing. The URL is: [logg inn for å se URL] I have
Necessito...di un programmatore con esperienza di: excel 2010 visual basic API Macro Ho un file excel con macro e linguaggio visual basic che é collegato a un sito che fornisce API di dati in tempo reale. Argomento trattato statistiche match calcio live. Vorrei modificare tale codice e aggiungere colonne al file excel. Maggiori info in chat
Hi, I need someone to create a formula that will fetch values from the table and the result would be written in words like on the table. Take a look at the example in the image provided. First you enter your bodyweight, then you enter your lift number. After the formula needs to look up and see what the level it is and write it in level to the
Simple Excel Question. I just need to do a VLookup or whatever method formula created to take on set of data, listing my quantity and part number. And check it against another set of data - where part number is listed with my cost. Return my cost to the numbers that I stock. So in the example attached with a sample of numbers: In column D I want
I need a simple macro for make these things in a Csv. . Replace " with nothing [logg inn for å se URL] . Replace t_ with nothing [logg inn for å se URL] . Clone what is stored in Z to H and what is stored in AB to I [logg inn for å se URL]
i have control results mentioning a rownumber if there is something wrong with the controls when the rownumber is entered we should automatically go to the input sheet that has been controled and delete the row in that sheet
I need to create simple macro as per rules in the sample file attached. It is very simple and basic work. i will have more than 5000 rows of data, so the macro should be able to handle it efficiently this is very urgent, if you can do this in next 3-4 hours thanks
I need one formula per store to calculate a value in Table 1 using data from Table 2, I give tha answer in the sheet "long answer" but it use a long way to calculated it (many steps). So i need that someone create this calculation in just one cell with one formula.
The idea is to create a one cell formula for each store (Cells B5, B5, B7) in sheet “Problem” that make a calculation over the “table 2: data” to calculate a critical value for each store. I provide the answer of this critical value per store in a separate sheet using a conbination of different formulas, but the idea is to create just one for each
I want to generate automated outlook mails from available data in excel, I have some images in excel workbook which I want to paste in body of email and also some text which I want to paste in tabular format. I have developed utility for genertaing mails but I am unable to put mutliple images in mail
Please see video and let me know if you understand and are able to get the job done. :) [logg inn for å se URL]
Looking for someone to help me find the pointer to an offset in a PC application and code a simple macro using AutoIT or Autohotkey that uses the pointer. Ideal candidate would also give me simple steps to find the same pointer were there to be any updates to the application. (I am familiar with the basics of programming and memory reading although
I need an excel formula that i can use to calculate the areas of multiple arches for buildings in a construction project. I will always have the radius and some dimensions. But I will never have the degrees if the arch. see attached sketch for the dimensions I will have: A. top width B. bottom width may only have one of the dimensions as the angle of
I need help creating an advanced filter/macro for my Google Sheet. I need to filter for locations that may or may not be on the sheet. Please watch my short video for more information. I look forward to working with you!
Excel macro to establish N number of TCP connections simultaneously using different destination ip address
I have a excel sheet file from Bloomberg that we need to extract the formula from and apply this formula to build charts in Python/Django project. You will use Highcharts to draw charts from the daily prices of assets fetched from Bloomberg into Django backend DB after applying the formula from the excel file using Pandas library. I will give more
I would like to automate the attached excel sheet to do the following 1. Data entered into "daily data" tab must be sent to the correct tab, based on cells C2,D2,E2,F2, data well be entered daily and must be exported based on the date mentioned in the sheet. 2. In tabs DQ-45 to DQ-48 data(captured from "daily data") is to be stored on weekly basis
We need a small project completing.... i believe it involves "VLOOKUP" and will simply copy data from one spreadsheet in to another. Spreadsheet 1 will reference a customer code. We need to look up the customer code on Spreadsheet 2 and copy certain columns (address/client name etc) from Spreadsheet 2 and put in to Spreadsheet 1.
Arrange highlighted non-contiguous data into a table. In attached file, in "Matrix" tab take highlighted cells and arrange into table (Zip Code Tabl...non-contiguous data into a table. In attached file, in "Matrix" tab take highlighted cells and arrange into table (Zip Code Table tab has examples columns D-F). Assume a macro can pull this together.
I wold like to create a macro that I could paste in to PowerPoint v16 for Windows / VBA that would save selected slides in the slide sorter as INDIVIDUAL powerpoint files whose file name corresponds to the slide number in the presentation
need a vba script where depending on brand name in column can match to email of company
Re design an excel log, must be proficient in Excel Dashboard, Macro, VBA. Fluent in English, with a strong statistics back ground.
What the Macro should do: If I put the cursor somewhere in the text of a document, I want that a macro runs which (i) Inserts the word "Exhibit", (ii) Inserts the current cross-reference of the paragraph where the text cursor is set (numbered item, reference to Heading Number (full context) after the word Exhibit, (iii) Formats the whole item into