The discussions
Conditional formating
I have a spread sheet with 2 columns; In column 1(one) I am tracking Employees. in column 2 (two), I track the employees position. When a position i...
Vlookup won't work
SolvedI am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...
Adding one day to a date
Hello, I have a spreadsheet that i use for planning truck maintenace, I am trying to work out how to have 2 buttons that i can assign 2 macrows too,...
With the help of name we can get the data one sheet to another
Hello, with the help of name we can get the data one sheet to another sheet in excel in pdf Configuration: Windows XP / Firefox 12.0
Please help, counta and countif same formula
Hello, Please help me, I am trying to accomplish is this: I would like to count the text in Range (B1:b5) excluding duplicates, however only i...
Autogenerate worksheets from a list of names... adding names?
Hi, I'm trying to auto-generate worksheet from a list of names. Reading other questions in the forum I found the solution for this questions. But I ...
Not showing save as dialogue box.
I am an office assistant. Every time I have to spell the numbers in words. I got a solution from net that a function can be added to the function libr...
Set cell value
SolvedHello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...
Vba copy sheet to new excel file + automated manual data entry
SolvedConfiguration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...
Excel formula
Solvedhello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...
I need a macro that can extract data
Hello, I need help with creating a macro that can automatically copy data from different worksheets and put it into a master worksheet for a repor...
Code visual basic
SolvedHello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...
Compare range of cells and get the result of a third cell
Hello, i have a file with 3 columns, i need to compare each cell of the first 2 columns and of it match print the data that in the third column th...
Copying a conditional format to other cells...
Hello, I have set a formula to calculate how many days between two dates i.e. Date in A5 - date in A4 +1 = number of days in A6. Pretty simple ok....
Excel formula display in cell
SolvedHello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...
Day of week and date in same cell, autofill rest of month?
Hello, Is it possible to put day of week and date in the same cell in Excel 2004, and then autofill down for the rest of the month? I have tried ...
Macro code to copy and past in new sheet last row of data
Hello, I'm trying to write a simple macro to copy in one sheet a selected amount of column data (which varies by size each time) and then paste the...
Convert to mm/dd/yy to dd/mm/yyy
Hello, Pls help how to change mm/dd/yyy to dd/mm/yy in excel. Configuration: Windows / Chrome 41.0.2272.101
Day of week and date in the same cell, then autofill rest of mon
Hello, I would like to know how to put the weekday and date into one cell, as in: Wednesday, 4/1. Then I want autofill to fill the rest of ...
Find and replace a specific number
Hi All, I am new to this, so I hope somebody can help. I have a code CF|0612|1-12 in cell A1. That code is the code for an apartment block we...
Macro for extracting data
I need helping writing a macro to extract data from column A and input into column B. Example data = 13A:123456789:V1 and what I need is the data betw...
Cell color
Hello, I have a worksheet with various dollar values in it. I want to write a formula to add all the cells that are a certain color (green or yel...
Some cell date could not change
SolvedHello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0
Comparing data in 3 columns on a microsoft excel spreadsheet
SolvedWould be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...
Formula which calculates the percentage of these cells
I was wondering if anyone could help me with a formula for some work I am currently doing. I have a set of data (numbers ranging from -0.8 to + 0.7) w...
Excel 2013 formula - maybe if formula?
SolvedI have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...
Copying data based on number from one sheet to another
Hello, I would really like a VBA CODE which would help me to copy Data based on number from one sheet to another: So I have 5 projects(sheet1,s...
Call equation according to choice
Hello, When choosing from a data validation list, i want some cells to import specified equations according to the choice selected from the list ...
Compare sheet 1 and 2 and copy to sheet 3
Hi, I got this code which compare sheet 1 and 2 and copy to sheet 3 data with similar data from 1 and 2. Now what i need is to cell from sheet 2 t...
Date formulas
I am wanting to know how to make a copy of the same spreadsheet many times and when I do I want the date on the spreadsheet to change automatically ea...
Wordnum help needed
SolvedHello, I hope somebody can help. I use WordNum to spell the result of a formula and it gives me 4 digits (spelled) after the point. I need just ...
Comparing 2 cells to get an answer
Hello, I am a primary school teacher and I really really need helps on this matter. Excel is something new to me and my boss asked me to help him ...
Cell format
SolvedHi Guys, I'm new here, I have a very limited knowledge about excel. My superior has asked me to do some sort of Advanced Cell Formatting in our per...
Filter on multiple rows - two rows or four?
Hello, How can I apply filter on multiple rows? The first row got different detailed header, the second one and the third one. rgds, Mbime. ...
Formula or macro to combine data
I have data in two columns that I am trying to combine, but keep in separate columns. So I have: A 1 B 2 C 3 And I need this: A 1 A 2 A 3...
Text-to-text equals number
SolvedHi.. I'm looking for a solution for a dilemma I'm in.. On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell. On sheet 2 I have the...
Formula, blank cell
SolvedSorry in advance if this has been asked but I can't see anything. Excel 2010 I have a cell that will contain a date then the next adjacent cell the...
Convert date into words(english) in excel 2003, 2007 or 2010
SolvedHello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twenty Second April T...
Conditional formating is applied based on date in two cells
SolvedHi everyone I'm using Excel 2010 and applying conditional formating on dates in Column E. I don't want the formatting to be applied if there is the f...
Vba copying and pasting loop with if then
Hi forum, I am really new to VBA for Excel. I wanted to create a macro far beyond my skill and hit a brick wall. I really wish I can attach a sa...
Inventory set-up
Dear all, I have been struggling with setting up my inventory process in excel. So I have a live stock with my total actual unprinted t-shirts...
Excel macro experts out there?
Hello all, I am very new to writing macros and was looking for some guidance in writing one for patient blood volume. What I am looking to do is...
Need to automatically copy data from one sheet to another
Hello, I have a worksheet titled "Pipeline Data". There is a header row and data from A-R. In column K there are dates of the contract solicitati...
Invoice numbers
Hello, Would you be able to tell me if the second code has to be in it's own box or can I put it right under the top code to increment the next genera...
Excel - help please! drop down and data filling
SolvedGood morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one that li...
Auto copy-paste from one spreadsheet to another
Hello. First of all thank you that you are willing to help. This is much appreciated! I am new to Excel (but I know how to apply macros) so ple...
Trying to have the current date go into one cell (a1)
SolvedHello, I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to aut...
A strange range question ...
SolvedHi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...
To identify repeated values
Hello, Please help with this issue. I have a list of players in column 1 and column 2. I would like to know, for instance how many times "Allan"(pl...
Is there a percentage formula!
Hello, Is there a percentage formula!!? e.g. If you enter a100 in a cell and that amount to appear 30% in one cell and 70% in another !! Thank y...
