Excel Forum - solved topics
- Solved
-
Import .pdf ...? Solved/Closed
Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
-
Formula Solved/Closed
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
-
Conditional Formatting based on two cell values Solved/Closed
Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...
-
Copying cond. format for entire row based on 1 cell to other row Solved/Closed
I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value
-
Drop down lists Solved/Closed
Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...
-
Removing False Value Solved/Closed
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...
-
Copy rows to other sheets based on value in column Solved/Closed
All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...
-
Trying to create a multi-column formula. Solved/Closed
Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...
-
Excel problem Solved/Closed
Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...
-
Highlight one value in a dropdown menu of three responses Solved/Closed
Hello, 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 Solved/Closed
I'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...
-
Excel formulla Solved/Closed
Hello, I want to split cell of available qty in to multiple cell according to requirement. Input Sheet -1 Material PO qty Req. Qty ...
-
Search a list of names at one time in excel Solved/Closed
Hi, 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) Solved/Closed
I 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 Solved/Closed
Hi 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...
-
conversion of DOB to full words Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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. Solved/Closed
Hi 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 Solved/Closed
Dear 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 Solved/Closed
Hi 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 Solved/Closed
I 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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...
-
Adding number of days in filtered excel sheet Solved/Closed
how to add number of days to columns in a filtered excel sheet
-
complicated auto populate possible or not and if so how. Solved/Closed
Hello, 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...
-
iso 27005 Risk Value Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
I'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 Solved/Closed
Hello, 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 - Solved/Closed
Hello, 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) Solved/Closed
Hello, 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. ...
-
Data in Cells Appearing in other Pages Solved/Closed
Hello, I am having a problem with entering data into a cell on one page (tab) of a spreadsheet, and having that data show up in the same cell(s) on ...
-
Autofill Master sheet Solved/Closed
I 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 Solved/Closed
Hello, 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. Solved/Closed
Column 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) Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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...
-
Excel Sheets automatic updates Solved/Closed
Hello, I am trying to collect budget request from different departments and if all approvals fields are Approved, I want all data to be collected in...
-
Macro for merging data from multiple sheets Solved/Closed
Hello, 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. Solved/Closed
Hello, 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 Solved/Closed
Hello! 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 Solved/Closed
Hello, 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 Solved/Closed
hello, 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 Solved/Closed
Hello, 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...
-
Generate excel workbooks based on excel list Solved/Closed
Hello, 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 Solved/Closed
Im 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...