Excel Forum
- Solved
-
Transferring information from previous spreadsheet [Solved/Closed]
Hi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we...
-
Single Quote - Excel 2007 [Solved/Closed]
Hi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does...
-
Conditional Formatting based on expiration dates [Solved/Closed]
Hello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range...
-
Two criteria to check if a date in Excel [Solved/Closed]
Despite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or...
-
Formula to add big number of day to date in excel sheet [Solved/Closed]
Dear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180...
-
Using the last few characters on a different sheet [Solved/Closed]
Hi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script...
-
VBA cod [Solved/Closed]
how i send data to you for solve the vba cod create in my excel file.
-
vlookup won't work [Solved/Closed]
I 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...
-
set cell value [Solved/Closed]
Hello, 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...
-
VBA Copy sheet to new Excel File + automated manual data entry [Solved/Closed]
Configuration: 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...
-
excel formula [Solved/Closed]
hello, 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...
-
Code Visual Basic [Solved/Closed]
Hello, 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...
-
Excel Formula Display in Cell [Solved/Closed]
Hello, 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...
-
Some cell Date Could not change [Solved/Closed]
Hello, 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 [Solved/Closed]
Would 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...
-
Excel 2013 Formula - maybe IF formula? [Solved/Closed]
I 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...
-
WordNum help needed [Solved/Closed]
Hello, 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...
-
Cell format [Solved/Closed]
Hi 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...
-
Text-to-text equals number [Solved/Closed]
Hi.. 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...
-
Formula, Blank Cell [Solved/Closed]
Sorry 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...
-
convert date into words(english) in excel 2003, 2007 or 2010 [Solved/Closed]
Hello 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...
-
Conditional formating is applied based on date in two cells [Solved/Closed]
Hi 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...
-
Excel - Help Please! Drop Down and Data Filling [Solved/Closed]
Good morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one...
-
trying to have the current date go into one cell (A1) [Solved/Closed]
Hello, 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...
-
A strange Range question ... [Solved/Closed]
Hi 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...
-
adding a loop to macro to insert pictures [Solved/Closed]
Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures...
-
Change calculated to a hard date [Solved/Closed]
I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank...
-
Transferring numbers to new worksheet automatically [Solved/Closed]
Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to...
-
Macro to create tabs and populate from other worksheets [Solved/Closed]
I already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current...
-
How to transfer lines of txt from one sheet to another sheet? [Solved/Closed]
Hello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there...
-
Repair Excel Files. [Solved/Closed]
Hello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder...
-
how to remove image with VB? [Solved/Closed]
Hello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using...
-
Conditional formatting based on another cell; apply to rows [Solved/Closed]
Hello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg,...
-
Need help with date and if statement newbie [Solved/Closed]
Hello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is...
-
How to replace * with / in all formulas in an excel sheet [Solved/Closed]
hi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could...
-
time calculation (TimeXnumber) [Solved/Closed]
Hello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3...
-
Conditional formatting with range [Solved/Closed]
Hello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it...
-
IF/OR Formula [Solved/Closed]
Help please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...
-
How to repeat a row 4 times, while increasing sequence [Solved/Closed]
Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column...
-
Converting rows of data in notepad to columns [Solved/Closed]
Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains...
-
conditionally copy columns [Solved/Closed]
Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I...
-
Change a range dynamically - VBA script. [Solved/Closed]
Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: ...
-
removing false in excel [Solved/Closed]
=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!
-
Increment a cell value - conditions applied [Solved/Closed]
Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the...
-
Rating from Parameter Lookup [Solved/Closed]
Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is...
-
Nesting if() functions? [Solved/Closed]
Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are...
-
1 time data entry [Solved/Closed]
Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i...
-
DUE DATE REMINDER IN EXCEL TO NEW SHEET? [Solved/Closed]
Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE...
-
Regarding Pivot [Solved/Closed]
Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag...
-
Find the first available (empty) cell on a worksheet. [Solved/Closed]
As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a...
