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
...is specific to LoaderID=3. The "LoaderField" tells you which column in the TXT to use. As an example take "+447542702658" You will see 3 rules. 1. Remove " 2. Replace +44 or 44 with 0 at start of field 3. Replace all instances of Rule value 1 with value 2 This will convert the field to... 07542702658 After applying all the rules, it will then insert
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 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. :) [login to view URL]
I require a freelancer to create a php script that will run on a webserver and perform the following: 1: Unzip a file ([login to view URL]) 2: parse file ([login to view URL]) 3: convert to JSON format 4: display the JSON on screen. Note: the URL will need to be a variable so the script can be used on multiple sources.
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 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!
...takes the hyperlink of a text document as input and outputs it as a txt or csv file. Details We have written a small web application in PHP which outputs hyperlinks to text documents. These text documents are located either: (1) on our server (in which case their format is .pdf, word, excel, ppt format); or (2) on the Internet as webpages (in which case
Excel macro to establish N number of TCP connections simultaneously using different destination ip address
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
I need a logo designed
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
...file and save as a .txt file The textfile needs to be named using the filename specified in the .csv file. The textfile should contain the following elements using the format below. Class [SPACE] YoloXCentre [SPACE[ YoloYCentre [SPACE] YoloWidth [SPACE] YoloHeight e.g. 0 0.233913 0.408021 0.307826 0.200000 For some, e.g. 3.txt, there may be multiple
Take a multipage pdf, save to TIFF to remove rendered data lock, OCR then point data into specific columns in a spreadsheet template. The data in the pdf that needs to be converted is not in a tabular format so this is not a copy/paste job. I will provide the spreadsheet template with column headers.
Hi Guys, I'm after a solution to read a text file on the internet which has multiple lines for example: [login to view URL] is the file name and inside it has the below Microsoft Windows 7 Microsoft Windows 10 Microsoft Office 2016 The above information then needs to be added to a combo box on a VB6 form. Ideally i dont want the file to be saved just read from and then added to the combo ...
Need someone familiar with photoshop for a very easy job changing a few things on an image. On first image, change "AT Luxury Cars" to "Luxury Cars 4 Less" (new name of my business). And on map image, change orange background to red background and increase all shipping prices by $100. Also change logo on bottom right.
Re design an excel log, must be proficient in Excel Dashboard, Macro, VBA. Fluent in English, with a strong statistics back ground.
I need a software are to read PDF files and convert into EXCEL tables. The files consist of several fields that need to be converted into a table. The PDF files will contain a set of invoices that need to be converted onto an excel sheet. Each file may have more than one invoice and each invoice may have more than one page. The customer, supplier and
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
I need a software are to read PDF files and convert into EXCEL tables. The files consist of several fields that need to be converted into a table. Deverão files imported should populate the same Excel(add Linea). There Will be a set of fields repeated in the table while others will have specific data that should be the real data.
Create a macro in the attached spread sheet that creates a combined Bill of Material that lists all the common parts, description, quantity, manufacturer, vendor, and price. The Macro should create a new sheet that is a composite of all the sheets and their parts. You will need to match all the common part numbers on the sheets (column B) and provide
I would like someone to build me a macro in VBA that I can upload into Excel as default and use for formatting models. So when I open Excel each time, this macro will be running. The functions of this macro are purely for changing colours and formats so it should be very easy for someone who can pull together macros. I have attached a list of
Take import from xls, listing: Client Name Date Paid Debtor Name Client Ref Amount Paid Connect to a Xero account Match the Client name in the xls to the client name in Xero (1. [login to view URL]), if the client name does not match, I should be able to match it to one and save this for future imports Allow me
...to assist us with claims we receive from one of our suppliers. Unfortunately they dont support CSV or TXT files. You get the info on a HTML Page and you have to capture the info manually into our system. We would like to import the info from a txt file instead of having to capture everything manually. Please see Below: Good day, I need a scraping
...I need an Excel expert to help build a complex financial forecasting / budgeting / sensitivity analysis model. It will require some macro automation, easy data input, dashboard , styling etc. You must know Excel back to front, VBA and formulas such as Lookup, Index & Match etc Don't apply for this project if you only know bits of Excel and you think
I want to have a Macro for word which performs the following action: Example: This is the normal text. And here is the text with a Definition text. What the Macro should do: If I put the cursor somewhere within the word Definition, I want that a macro runs which (i) Selects (marks) the whole word Definition, (ii) Puts some quotes (" ") at the
Create excel macro or phython script (if exel macro doe snot work) that converts a potentially large 20000 row xls spreadsheet to a prn file with the exactly specified format. The prn file is larger than 240 characters per row. example excel sheet and desired output prn file are given pleas reply with code from instruction pdf to be considered for
Upload website template change and add txt, add payment-opencart,notifications email and text. Set up two Gmail accounts with domain. [login to view URL]