I need to have a fairly simple script built to populate a Libreoffice Calc spreadsheet with local images. In the example file, the 'image' colum needs to contain a 100x100px picture of the image file located at the 'id' path. So for the first 3 rows of the example, the image path would be relative to the spreadsheet at the directory: images/#/[url removed, login to view]...
I am looking for a guy who can develop the following VBA macro: In an excel file column D, I have some URLs. For those URLs, I need to get the host name of the URLs printed without subdomain, http// and www in column E. This step needs to be repited for all lines in the xls file.
I am looking for someone who can design an excel macro with two list boxes, One for populating the sheet names in the excel file and other for populating the column names from the selected sheet. The second list box should be multi select. The form also has a button to delete the records that are duplicated in the selected columns.
...have. It is related to exporting the comments, insertions and deletions in the document into word and excel. I have attached the following: 1) Current output I get from the document. 2) Existing Code Files (you can import them into Modules in MS Word VBA) Key Requirements are (changes required to the existing code): Document should be
I need a program/macro/script/web app, etc that will auto accept BPO orders for various companies, including RRRreview, Emortgage Logic, Clear Capital, ComputerShare/SAMREO. The order notifications are received via email which has to be monitored in real time via IMAP noop. Upon receipt of an email, you have to do a combination of logging into websites
I have 100s of CSV files in a folder. The name of the folders has the TEST CASE number. You have to write Macro in the Excel [url removed, login to view] to do the followings. 1. Browse all the CSV files. 2. Analyse the CSV Files (Described below) 3. Populate Column D and E (Described below) 4. Do some conditional formatting for Pass/Fail and Yes/no. *******
...Chinese names 1 Word Take first word as Fname 2 Words Take first word as Fname 3 Words Take first 2 word as Fname 4 Words Take first word as Fname 5 Words Take first word as Fname Rules for non chinese name 1 Word Take first word as Fname 2 Words Take first word as Fname 3 Words Take first word as Fname 4 Words...
Build Macro´s for the following functions 1) In column P is an unknown number of values. Search for the cell range between 0 and 0,010448 and copy that to the cell range between 0,0104481 and 0,0208962 (prior value x2), etc. 2) For each cell range, find the average figures within the same range but from column I. Each time calculate 3 averages for
Create a macro. sheet A: here u will copy and past manually the data u want processed. sheet B/c - will do some calculations and a macro to run., sheet d - end result - unique recoreds as per your request
A simple macro required to format an existing table. * Keep unique records * Unique records "Project" & "Grade" column should be based on the latest "Ending Date"- based on the badge id. * Unique records "Starting Date" should be the oldest amongst the duplicated records of the specific badge id. * Unique records "Ending Date" sh...
I need a small data Entry Form created along with the database that will store the data provided in the form. This needs to be finished in less than 2 hours.
Need to get userforms and buttons for excel based Data Base. Create an app in powerapps with data from CRM.
I need a excel macro to read a standard cost sheet file from our PLM system. The data in the file should be read, and then remapped and presented into a new format (sample provided). The user will review, and change some of the details on this cost sheet, and then save it. When it's saved, the file should save the data in both the new file, and the