...one solution. Initial: I want to have a solution to launch my new book, advertise my past published book, sell bulk copies, and sell specialty-related products, like a workbook. I need an Author Page, two Book Pages, and my Business Page is linked – I’ve paid a year on my Business Site, so not moving it yet. I need the ability to manage the site
I have a program that returns JS to a site, but the JS is returned upon calling a PHP script. Google Tag Manager doesn't like the fact that the script scr is a PHP file and is throwing many errors. So I need to somehow have an externam script src file that will refer to a PHP script to process and then return the JS to the requesting site. This is for a pop up program called xzy_script. T...
edit the current workbook (approximately 10 pages daily) for spelling, grammar, consistency (same tense, same use of language, etc - attention to detail is very important), but also provide feedback and advice on sections to expand, how to expand them, what details may be superfluous in the current version, etc. The workbook is in English, intended
I need to convert a small excel workbook into a python dictionary (json format). You can first convert the worksheet into a csv and then use csv module python. Or you can use openpyexcel diractly ( i dont mind unless i get the required format. Its just half an hour job. I will share the files on chat.
the project is to collect data from the internet, search or directories. We are interested in medium and large 'Electricians', 'Plumbers' and 'Builders' businesses (no one-man-only). I like them in all States/ Territories. Divide the MS EXCEL workbook up in tabs, such as "WA Electrician" or "QLD Plumbers' or"NSW Builder...
I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [login to view URL](LookupValue, LookupRange
I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are
The idea is creating a list of companies and the primary key is the registration number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces
Need existing workbook sheet edited to count more than one column on another sheet. There are two sheets, one called Weld Log, and the other called Cont log. Each welder is assigned a letter to use. Currently the sheet only has one column for "Welder Stencil" and when added to that weld, it will count two types of welds to that stencil, but sometimes
I have an excel workbook with detailed information including depreciation, loans, capital raise, forecasted operating statement and need to have a Cash Flow Worksheet model added to the projection workbook. Project must be completed by Tuesday December 11 midnight Pacific Time.
Here is everything you need to understand in the video: [login to view URL] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [login to view URL] Let me know if you have questions, Thanks, Jai
I need someone to organize an Excel worksheet of over 100,000 Contacts and remove duplicates. Lots of them are duplicates.
...utilizing my company logo. This cover sheet is for a workbook for salespeople. A standard page size of 8.5 x 11". The salespeople are primarily of the RV, Marine (boats) and motorcycle industries. I would like to have a lifestyle image if possible to really give some life to this cover. The name of the workbook training program is (C.O.S.T.) Customer oriented
All, I am searching for a VBA expert programmer who can build an advanced excel workbook that will track maintenance on a group of equipment. Please only contact me if you have advanced skills and and a critical problem solver. This will be a challenging project and I will be working along with you to complete this project. Thank you
I'd like a workbook composed of 5 tabs including a price list, sales order form, quote form and completed orders form. I will need "dropdown" options to be included. I've attached the word documents and PDF I am currently using which I have to manually upload every time.
Project Brief – Excel formulas/linking of workbooks Please note: Project to be completed by 13th December Please look over the project brief and attached workbooks prior to bidding. - Circular formula needs to be added to create date/time stamp. When data is entered in C2 cell, C27 needs to be date/time stamped (on case note worksheet) - support coordination
Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.
There is a re-writing of one motivational workbook. Which comprises of 30 Chapters. To start with Chapter 1. It is of 2750 Words. This is going to be a first job for testing the language tone. If first chapter looks ok, then can consider for other chapters too.
...programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month file to
I have attached a workbook with data in one worksheet and email address in the other. Here is what I'm trying to automate using VB: 1. Filter column C by supplier (CA National Serice Pty Ltd) 2. Filter column V for "Ordering" 3. Copy Data from Column F and G 4. Email to the supplier address in "Email Address' tab Then repeat this process for the
...the Word Template document path and filename to be referenced from a Cell within the Excel 2016 spreadsheet. Also an option for the resulting Word document that is generated from the ExcelToWord operation to be saved with a filename and path that is referenced from a Cell within the Excel 2016 spreadsheet. The current Configurations Options will need
##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been
I need someone to add either a formula or a vba (that I can edit later) which will take information from sheet 1 and automatically transfer it to various other sheets. I need it to do this based on the zip code in the address. Example would be 60 different zip codes around me - however, only 13 will go to sheet 1, 27 will go to sheet two 10 will go
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
...looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-...
I have a workbook that I need OpenPyXL to work with. I have had the library running fine previously but I can't remember what steps I had to take to get it running. The error in my code pointed to the first few lines, when I attempted to copy the original workbook. If I run the below code, the new workbook is completely blank. I need someone to explain
...on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followed by the contents of cell A1 and the time now in hour and minute format" From a second
I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "...
Need Magento Pro Only to repair or reinstall with same db, activate extensions, backup, move to another domain
I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.