Are you ready to be an Excel Pro? Here are 13 tips that will help you master it.
I am in construction and have a ton of work that needs to be compiled into an excel document. If you successfully complete this project look forward to long term employment with me as I have many tasks that need to be completed I have written the results of my research on a piece of paper similar to the pdf below. I will scan my hand written copy
Extract data from an excel file and display it in different format also in excel table. The data we want to manipulate consists of a big table as part of a bigger set of data. The table has "product code" & "product name" on the left columns and "Fabric name", "Season", "colour" on the top rows. In the table, each cell con...
Create a simple Excel macro to ask the user which currency to convert AUD to (USD or EURO), then convert all AUD $ values in the current worksheet based on the correct currency conversion value in another worksheet (Both in the same workbook). Very simple calculation. Macro needs to first check that the cell format is a currency (eg. $, Euro, USD)
I need a website computer and mobile website of 5 to 10 pages front end. and need following functionallity: [url removed, login to view] can book and cancel appointment online. and has ability to choose if he wants the service onsite or in shop. 2. customer can sign up to his account to see his order history and all. 3. agent can sign into his agent portal and make appointment from its porta...
Hi! I basically need a script that somehow does exactly the same as the VBA-code in the excel-sheet attached, except I need this as an app script for a google sheet that looks alike (the form controls are replaced with formulas that changes the values in cell A1 and A2 in the google sheet). The VBA-code is written by me (super amateur) so maybe
CAN YOU PUT A FORMULA IN THE SHEET SUCH A WAY THAT THE EXCEL SEARCH AND FIND DUPLICATES ONLY STORE NAME THE STORE NAME IS AFTER "ssn=" and end before "&" so want the excel sheet to only after and before the above characters and not the entire cell because some the other url changes and cant determine the duplicate
I need to convert a text string value in Excel in Two Columns and a 3rd&4th column to subtract one from another: Cell A1: 21 hours ago (Wed. Jan 4 2:42pm) Cell B1: 11 days ago (Tue. May 2 6:41am) Cell C1: What is the difference in Minutes (B1-A1) Cell D1: What is the difference in Minutes (B1-A1) Note: Must provide all the workings to allow me
I have a file with about 1000 rows. One of the cells has mixed data with empty spaces and one email address. I need a function, vb macro or anything similar to only have the email address as a result on the column next to it. I attach example file with 2 records showing before and after. I can not send the complete file because it has sensitive data (email addresses). You need to send me wal...
I have appox. 1500 contacts i need help to find correct email and phone numbers. I wil...appox. 1500 contacts i need help to find correct email and phone numbers. I will provide the contacts in an excel sheet in the form of Names and Property Address. I need you to get me *verified* emails address and best phone numbers. Cell numbers will be great.
Looking for an Excel expert to create a quick macro that will do the following: 1) it will check the column "first name" for empty cells and will delete the entire row 2) same as 1) but for the column "last name" 3) same as 1) and 2) if it encounters only one letter for example a first name cell that just says A or a last name cell that says J 4)
...project for LITE version Need an Excel script/function that will do the following: 1: Copy a property address within the existing excel sheet 2: Open up a URL like [url removed, login to view] and paste the address in 3: Pull the property value back into a specified Excell cell 4: Pull the Parcel Number back into a specified cell 5. Pull the County and link t...
I need a python script that reads top 3lines from docx, doc, odt and pdf and makes excel files. In a detail, each files has one row, and each line is one cell. This script should work on win10. This is very simple script. Fixed price: 20$
I need a python script that reads top 3lines from docx, doc, odt and pdf and makes excel files. In a detail, each files has one row, and each line is one cell. This script should work on win10. This is very simple script.
...EASY 5 STAR REVIEW*** Attached is a sample BEFORE & AFTER spreadsheet. Here is a link to explain how to do it: [url removed, login to view] In spreadsheet 'BEFORE' you will see column A has names and column B has numbers. The numbers in column be represents the number of times the
The project is to enter data from attached photos into an excel spreadsheet. There are 209 pages labelled 1-002 to 1-209, in order. I include the first three here. I have done the data entry for the first page. Your job is to fill in the rest of the spreadsheet and to do it accurately, quickly, and at low cost. Most of it is straightforward
I need a program that goes to the last line of an excel file, copy the contents of one cell to another in the same excel file and then save the file with a name equal to a cell in the same file. Now I will have two files, one with the original name and another with the new name. The program jumps to the next line and repeats the process thousands of