Excel Forum
- Solved
-
No tool bars or address bar on my browser [Solved/Closed]
Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have...
-
Code for macro that conditionally inserts rows [Solved/Closed]
Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in...
-
excel for mac opens all files on desktop [Solved/Closed]
Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load...
-
Can't open Excel file [Solved/Closed]
Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first...
-
IF statement errors and using multiple IF statements. [Solved/Closed]
Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it....
-
merging more cells into one cell [Solved/Closed]
Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first...
-
how can calculate days between twodates [Solved/Closed]
Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order...
-
Transferring data from one sheet to another [Solved/Closed]
Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data)...
-
Time calculations on a 24-hr clock [Solved/Closed]
Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything...
-
Auto notify or mail when Excel sheet updated. [Solved/Closed]
Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or...
-
Excel 2007 resetting cells to Date format [Solved/Closed]
Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a...
-
conditional Formatting [Solved/Closed]
Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2...
-
Simply cannot find an answer [Solved/Closed]
Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28...
-
VB issue with delete rows with specific values [Solved/Closed]
Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at...
-
Macro Help: Copy Data from a Range of Sheets to a Master Sheet [Solved/Closed]
Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs...
-
Tagalog [Solved/Closed]
Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I...
-
How to convert number into text in Excel [Solved/Closed]
Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"System Configuration: Windows XP...
-
Adding a new entry into a list - Excel 2007 [Solved/Closed]
Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green)....
-
VLOOKUP range question [Solved/Closed]
Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has...
-
adding the same action to every second line [Solved/Closed]
hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to...
-
If, Then formula [Solved/Closed]
Hello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had...
-
convert date into month name [Solved/Closed]
Hello, suppose date has mention 1/1/09 and no month name then how to get the month name
-
copy Excel 07 sheet to other & keep formulas? [Solved/Closed]
Hello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and...
-
excel - Active X Combobox, Selecting Sheets [Solved/Closed]
Hi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a...
-
Many Columns return into fewer columns. [Solved/Closed]
Hello, I have a spreadsheet that was exported from Survey Monkey. So the format cannot be changed. There can be data in any of 100 columns....
-
MSOffice 2010 [Solved/Closed]
Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.
-
Short cut to merge cells [Solved/Closed]
Hello, If there a short cut on the key board to merge cells in excel?
-
Formating Date [Solved/Closed]
Hello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells...
-
Match barcode between 2 sheets [Solved/Closed]
Hello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one...
-
How can I eliminate #VALUE in calculated cells [Solved/Closed]
Hello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like...
-
Help with VBA [Solved/Closed]
Hello, I'm trying to program a macro in Excell 2010. What I need it to do is look in a Range for the NotEmptyCells and change their property...
-
Copy data into next empty cell in new sheet [Solved/Closed]
Hello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell...
-
Auto filter problem [Solved/Closed]
Hello, when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further...
-
Splitting list of names with formula - can you spot what's wrong [Solved/Closed]
Hi everyone, I have a list of 1805 names which are gathered in a single column. These names range in length and "format" (e.g. John Smith,...
-
IF FUNCTION in excel [Solved/Closed]
Hello, my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"") I want in place of...
-
Comparing two excel worksheets [Solved/Closed]
Hello, I am trying to find an easy way to compare and extract data from two excel worksheets. This is the scenario.. I have an excel...
-
Cut/Copy in VBA [Solved/Closed]
Hello, I am fairly new to Macros but I am trying to write vba code in Excel 2003 version that will enable me to cut/copy a table from one...
-
Covnvert numbers to single words [Solved/Closed]
Hello, In excel 2010 i would like to convert numers to words i.e. 123.00 (one two three point zero zero) or 1006235.23 (one zero zero six two...
-
Compare and copy data from one column to another [Solved/Closed]
Hello, I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N...
-
excel formulaes [Solved/Closed]
Hello, If there are two conditions, how to use the IF formulae. Regards
-
Help on generating a number series using a macro [Solved/Closed]
Hello, I would appreciate your help with a macro I am trying to create in Excel 2010 my Data is as below Column1 Column2 Column3 (Name)...
-
dynamic range and named ranges [Solved/Closed]
Hi, I have a list of students in Sheet 1,2,3 where being updated regularly. They are named ranges "Boys" & "Girls" in Column A & B...
-
multiple data in one stacked column [Solved/Closed]
Hello, i am trying to plot a column chart and I want multiple data to appear in one column. example: I am plotting all the submitted...
-
VBA for deleting data in row but not formulas [Solved/Closed]
Hello, I am working on a spreadsheet where I have to copy data over to a new sheet, once the data is copied I want to delete the data in the...
-
Automation of running excel macros [Solved/Closed]
Hello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process...
-
Comparing two cell in different spreadsheets [Solved/Closed]
Hello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...
-
Comparing Two Lists of ID Numbers in Excel [Solved/Closed]
Hello, thanks in advance for reading this. I have a list of student ID numbers which I would like to use as a student check-in. Column A is the...
-
excel i want to sum only numeric values except alphabetic values [Solved/Closed]
Hello, in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for...
-
change cell color based on input in a range of cells [Solved/Closed]
Hello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using...
-
Nested if's [Solved/Closed]
Hello, I would appreciate if somebody could help me in solving this problem. I am trying to make exel decide in an scheduled soccer games which...
