The discussions
Highlight one value in a dropdown menu of three responses
SolvedHello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...
Code to move rows into another sheet based on certain values
SolvedI'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...
Search a list of names at one time in excel
SolvedHi, I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is i...
If a cell contains any text then add a value (with dates)
SolvedI am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday...
Macro to increase a cell reference by 11
SolvedHi everyone I want a macro that on open will increase the cell reference in a cell by 11 each time the book is opened i.e. Cell C18 has =Sheet2!H2. T...
How do i change a word doc into pdf or similar file format
SolvedWant to send off a resume and they do not accept my covering letter in Word format, how do I change it to PDF or similar please
Conversion of dob to full words
SolvedHello, Configuration: iPhone / Safari 4.0 I want to to convert dob to word like 5/6/2014 to fifth June two thousand fourteen please tell me...
Data auto change on multiple status in one column
SolvedHello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...
Question on vba code
SolvedHello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...
Formula help - if cell contains a number, +1.
SolvedHi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...
Covert date of birth
SolvedDear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...
Need help with macro to generate monthly overview
SolvedHi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...
Conditional formatting
SolvedI am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...
Transfer data from one sheet to another
SolvedHello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...
Date formats
SolvedHello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...
Complicated auto populate possible or not and if so how.
SolvedHello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...
Copy row by x times where value x is cell value of the range
SolvedI need to scan each value in a column A and use the value in that column to copy the current row x times to another sheet. The second sheet is to be u...
Iso 27005 risk value
SolvedHi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...
Copy a row from one worksheet to another, based on criteria
SolvedHello, I'm trying to copy rows from my "master" worksheet to another sheet based on criteria in column A. Can I do this? Please help, thanks...
I want to send 120 e-mail with 120 attachments
SolvedHello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want ...
Totaling hours by code
SolvedI'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...
Change data status in one same column
SolvedHello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...
If statement -
SolvedHello, I'm attempting to create an IF statement. IF a type = 1 then add the total of a corresponding cell to the total amount. =SUM(IF(B24:B51="1...
Lookup across whole workbook (muliple sheets)
SolvedHello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. ...
Autofill master sheet
SolvedI am trying to automatically fill in a table (with whole rows from A-N) on a master sheet (sheet 1) based on whether the data in column H of the table...
If cell contains a certain text, add the numbers of another cell
SolvedHello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...
Need formula for comparing differences of two columns.
SolvedColumn A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...
Copy activechart properties to cell (from graphics)
SolvedHello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...
Copying conditional formatting with formulas accross rows
SolvedHello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...
Multiple if formula in one cell, date comparison
SolvedHello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
Convert number to assigned names and joined with another names
SolvedHello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...
Macro for merging data from multiple sheets
SolvedHello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...
How to convert date into text.
SolvedHello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...
Function button: unhide cells between values and hide all other
SolvedHello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...
Automatically transfer data from one sheet to another
SolvedHello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...
Range of numbers
Solvedhello, I would appreciate help on the following problem :- If cell R1equals any number in the range 12 to 31 then I wish cell b1 to equal 2. Is ther...
Add incremental number based on conditions in excel
SolvedHello, I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column bas...
Outlook can receive but not send with certain wifi networks
SolvedHello, I moved my PC to a new home and found that my Outlook can receive but not send when connected to the home's wifi. When I set up a hotspot on...
Generate excel workbooks based on excel list
SolvedHello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...
If then
SolvedIm trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...
Email with multiple attachments through vba
SolvedDear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column B Ro...
If and is text or is not blank
SolvedHello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...
Conditional formatting range of date cells based on another cell
SolvedHi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...
Search for a keyword. add value from another cell.
SolvedI'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...
A if(istext) formula that needs a trimming, please help?
SolvedHello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...
Worksheets into workbook
SolvedDear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...
Text from two different cells to give value shown in certain cel
SolvedHello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...
Conditional formatting for word and date
SolvedHello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...
Auto copy and paste cell range to a separate sheet
SolvedHello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...
Need to create multiple tabs based on data in table
SolvedGood Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...
