On my spreadsheet I have the following formulas on a date; Ex.J6+30=K6(Due Date), then Today()-K6=L6 (Days to implemetation). Now, when I have no dat...
Hello, I need to run a macro on the cell directly to the right of the button I clicked to run it I will be running that macro on around 100 butto...
Hello, I do not know much about excel I'm afraid and have been given a task at work but unfortunately am struggling big time - tried to google it ...
Hello, i have cells contain formula say ( $e$10 = $e$8+$e$7) i need to clear e10 if e7 = 10 but formula still found when auto fil...
Hello, I would appreciate if someone can help me with this problem solving question. I would like to know how to calculate my Service Expense as % ...
Hello, I have data in three columns containing dates that have two formats; some display as dd/mm/yy and others display as dd/mm/yyyy. I need the ...
Hello, I have an amount of $153,803 for Service Expense and $1,094,328 for Monitoring and Service Revenue. Problem to solve: Service Expense as % o...
Hello I am wondering how I am able to grab data from a report that I have to run monthly but the cell number is not always the same. Is there a way to...
Hello, I'm trying to create an excel spreadsheet to manage a property but I'm having difficulties in creating rules. Here's the schedule I'm m...
Ok i have names in Columns D and Columns I. I want to compare those two and if they match i want to copy the data adjacent to column I (J and K) to ...
Hello, I am curious if anyone knows if there is a way to have excel change a formula when a certain word is used, and only change the formula in t...
I started using macro in excel and I would like to inquire how to generate sheets by just giving the starting and ending dates. For example, I have th...
Hello Everyone, Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed". Dim feat...
Background: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I need to...
Hi all, I have a set of data where I need to create a row for every month through December 2016 based on a start date. For example, below is how the d...
I am currently graphing a lot of data that I look at on a scatter plot. I have a column that is named "Step name " that has about 30 different steps d...
Hello, I'm trying to keep a date in a recognisable format and precede it with a character. e.g. I want "D" and 27 July 2015 to appear as D 27 J...
Hello, I have a template which contains all the templates that needs to separated. Is there a macro that will separate all these templates and sav...
Hi guys, I am in an urgent need for a command or code to insert an image from any directory in my computer to a particular cell in Excel using V...
Hello, Basically I'm looking for a formula that would let me do something like this: If cell d1 contains ANY part of Apple (ie apple pie, apple ca...
Hello guys, I have defined WS as a woksheet and i want take an input from the user to select the worksheet using an input box. But I do not under...
If i try to convert date format to custom format again it went back and showing as date in tab. For example i have a date format like 26-10-2016 and i...
Please I need help with the following, how to merge cells if certain criteria is met. when prefixes in column A match, cells in column B will merge ...
Hello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it and re...
How could I create a macro to toggle the period "." key between a period and a comma ","? When typing numbers it would be nice to be able to use the ...
Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...
Hello, I Want to change date format DD"MM"YYYY (1/2/2016) TO 1/FEB/2016 MS Excel 2003 Please solve my problem urgently Shatrughna unquote
I do not get the above function in my Excel 2016
Hello, Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. ...
Hello, I'm trying to rearrange historic data into a new coding structure. I have an excel spreadsheet, showing nominal codes analysing rows of...
Hello, I am not an expert in Excel and I would say that I am a beginner on this program. I am working on an enrolment spreadsheet. On Shee...
Requested help on changing default action when entering info in Excel - response was "open excel and press the orb button". I can't find anything tha...
Hello, I'm working on an excel file and need to copy several values from different cell in the same row to another sheet based on unique number/ident...
Hello, I am looking for the formula to show the date if. Ex: I have been provided with the start date (10/4/2016) and i need to add 28 day's (=...
Hi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a diffe...
Hello, I want and If function to have 2 criteria. Where one segment takes priority, I dont know how to do that. Currently I have =IF($R145="...
I'm relatively new to Excel and I was wondering how exactly to do the following: A1=BALL A2=CAT How do I make it so that when B1=A1, then B1 is...
I'm trying to calculate my wages by entering the hrs worked each day, after 8hrs it is T.5 and DT after 10hrs. If I end up with a total of 3.2 or .2 ...
Hi, I have lots of sheets that I need to copy specific cells and copy them to a summary sheet. I currently have this macro: Private Sub Command...
Hi Everyone, I am relatively new to Excel. I am in the process of comparing two columns of data to determine whether the data in each column relate...
Hello, I have a purchase order document in excel that can have from 30 sheets to 500. In cell B14 on each sheet there is a code, if it is equal t...
Hello, Consider the attached image. I have data like this for about 15 columns. I want to copy paste each column for 2 to 3 times in a different o...
Would be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in excel, ...
If Intersect(Target, Columns("H:H")) Is Nothing Then Exit Sub Range(Range("E" & Target.Row), Range("R" & Target.Row)).Copy _ Sheets(Target.Value).Ra...
Hello, Trying to copy a row of data from a roster on a sheet into a new sheet when a cell states Line 1 ie When i type Line 1 etc i want excel to...
Hello, I have a csv file which imported to excel gives me dates in 2 different formats. I need to have one single format so that we can analys...
Hi, I'm trying to conditional format cells based on text in another cell and it's own cell. In Column A, the cells would contain either "hit" ...
Hello, I am self-employed and currently doing my taxes. I'm trying to set up my spreadsheet to make it as efficient as possible and am wondering if...
Hello, I have a unique situation here. I have got a sheet of data and in column F, there are duplicates values containing letter & Numbers like "O...
Hello, I want to create a simple entry sheet/report master sheet where records would would be typed into a single row (entry sheet) and the data w...
DON'T MISS