Excel Forum
-
Excel: alphanumeric if then statements Closed
Hello, I am setting up a database template for people who are not Excel trained and I am attempting to make the input easy for the users as well as m...
-
comapre excel sheet and generate result Closed
Hello, I have an excel workbook contains students details like name , Roll no, address,phone numbers etc. and another book contains only Name, Roll...
-
Excel If formula sum not blank Closed
Hello, I'm sorry if my question had already been asked before but I can't find any answer in the internet about summing all values that is not blank....
-
Excel automatically requires date, want text Closed
Hello, Halfway down an Excel column the cells start requiring all text in format of a date. Above, I can type text, below it requires 10/30/2009-type...
-
Free browsing Closed
Hello,tell me hw i can configure my laptop with mozila firefox software. With my mtn.my laptop is sahara.
-
Using VBA to get value from 3 variables...... Closed
Hello, I have a table of data layed out as follows: B1 = Product 1, E1 = Product 2, H1 = Product 3, K1 = Product 4 and so on Row 2 all Products spli...
-
replacement for IF STATEMENT IN EXCEL Closed
Hello, sir, I wanted to use more then 10 IF statement condition in my document, but i can not use more then 7 IF . please give me alternate for thi...
-
I NEED A FORMULA IN EXCEL? Solved/Closed
Hello, Hello... I have a cell A1 that show $200.00. now if am type $ 200.00 in B2 automatically A1 cell amount should show as 0 your help much ap...
-
PERCENTAGES IN AN EXCEL FORMULA BAR Closed
Hello, I WISH TO KNOW HOW TO CALCULATE 19.25% OF H44 (H44 REPRESENTS THE AMOUNT IN CELL H44 IN AN EXCEL WORKSHEET) USING THE FORMULA BAR IN AN EXCEL ...
-
Help with excel formula Closed
Hello, I want to change the month of year in a cell depending on a start month for instance I have a field with the start month in, eg. 1 for S...
-
basic macros function example Closed
Hello, i want some of basic macros funcrioning programme for developing my self in excel. pl. give me if any body having the example. thanks all...
-
excel formula Closed
Hello, Pl send me formula or converter for convert amount in fugures convert to rupees in words. surender kumar misra
-
a macro that will enter Closed
Hello, I am looking for a macro that will look at "A:1" and if positive enter "xxx" in "b:1" and color the cell background "yellow" or something fr...
-
Excel Help Please Closed
Hello, I have a problem that I am working on that can probably be solved using VBA code, but I am not proficient enough to do it on my own and I am...
-
Help with Hyperlink Excel Macro Closed
Hello, I have a macro that creates new worksheets in an Excel book, it also names the sheet after the cell you are on. Can someone help me with a mac...
-
excel spreadsheet Closed
Hello, My name is timothy kelly, I would like to know if you could see me a copy of the excel spreadsheet, and a few basic details on how you const...
-
Transpose cells if not empty in Excel Closed
Hello, I have 34 long groups of numbers in one Excel column. Each group is separated by an empty cell. Does someone know how to transpose this c...
-
my browser will not load page Closed
Hello, WOW, I didnt know that everyone had the same problem. I stayed on the phone with the cable company for an hour, we went through everything. Fin...
-
Compare a sheet values with another sheet Closed
Hello, Please help me, how to compare a sheet values with another sheet value using macro? Please.. let me know
-
Cross sheet consolidation Closed
Hello, Right I have a great big table in sheet1, it is a list of projects and the region they're in. I want to create a formula in sheet2 that is ...
-
keeping currentmonth year from sheet to sheet Closed
Hello, i have created a workbook that contains 5 sheets that need to have a month and year,that i use every month. i would like to enter the month ye...
-
Excel function Closed
Hello, In Excel, I have a list of cities and the zip codes used in those cities. For each city I have two columns: the starting zip and the ending z...
-
Can't hear the music using Mozilla browser Closed
Hello, I have a problem to hear the music from web if I am using Mozilla browser. I can hear on Internet Explorer but no on Mozilla. The music file i...
-
VBA QUOTE Closed
Hello, I am wondering if anyone can help me in writing a suitable quote in VBA. I have panel data in sheet 1 (companies in different years) and also...
-
unable to browse net but msn is working fine Closed
Hello, I've been having this problem for a long time, i have a laptop equip with windows vista premium sp2, on intel dual core and 4GB ram the proble...
-
Free browsing Closed
Hello, please send me the free browsing site on zain t9 space. the make of my phone is Nokia 2600C thanks
-
Sending emails from excel Closed
Hello, I wonder if someone could help me. I have an Excel database with dates in one column, then names in the next, tasks in the third column...
-
VBA IF function: when two cells are different Closed
Hello, I've been looking unsuccesfully everywhere for an answer to how to create an IF loop for the following situation: I have an Excel sheet w...
-
Copy and paste Macro Closed
Hello, I want to create a macro in VBA - i am a complete novice. I want copy from Sheet 1 - Row2 (always) upto the last populated row, and then p...
-
Excel macro to copy, compare and fill cells Closed
Hello, I have two sets of data, the first has regular occurrence based on date, sample shown below: Plant# Date Job no. DR15 1-Aug-09 LU00950...
-
excel data Closed
Hello, I basically want to do two things. I am tracking basketball stats for a league using excel. I've done all of the functions to sum up the numbe...
-
Stay on same row when selecting next sheet Solved/Closed
Hello, I would like to know how to stay on the same row when selecting another sheet. My file contains 17 sheets. Sheets 2 and 5 till 16 contain...
-
Excel - Date selection box - Is it possible? Closed
Hello, I would like to have a date selection box appear when cells are selected in a certain column of my Excel spreadsheet. By date selection b...
-
Excel Macro Closed
Hello, I want to write a macro which moves a cell value 'X' number of rows depending on the value entered in the cell on sheet 2 . Thanks
-
generate discount calculation sheet in Excel Closed
Hello, I am looking for help for coding in Excel. I have a customer buying more than 50 books which will receive a discount of 35%. If less than 50...
-
how to browse Closed
Hello, hi,av been trying to browse using my tecno phone,how doi go about it?
-
Too much hope, 4 mi just pay and brows Closed
I ave being in dis system for very long time now, and i mean it' wen i say just load #1000 Rechard 4 Zain and load #2500 4 mtn, i can send u d code dt...
-
Excel 2003 VBA formula for Auto Sorting Closed
Hello, I have a worksheets (1) in which I have data in range A3:A10 that comes from another worksheets. I am trying to auto sort the whole range A3:...
-
Help with Excel Macro Solved/Closed
Hello, I am certainly a macro noob and require some help, please, :( I work at a travel agency and I have a worksheet with all of our reserves. It h...
-
using a named cell in a macro - same workbook Solved/Closed
Hello, seems simple but I'm just not getting it....I'm using excel 2003 and am trying to use a named cell on one sheet in a macro on a different sh...
-
Excel, formula adding point to answers. Closed
Hello, Using excel 2000. I am creating a question which needs to creating points for answer. Cell A187 Example: What colour of car is expensi...
-
IF Function in excell Closed
Hello The cost of insurance is based on the value of the artwork. If value is greater than $500, then the insurance is 25% of the value; otherwise t...
-
Copying different worksheets data & updating Closed
Hello, I am looking for a Macro that can help me with the following: I create several worksheets in the same document everyday. Every worksheet ...
-
Combine Excel Sheets from folder into 1 book Closed
Hi Ya, I have a number of workbooks in a folder which I would like to combine certain cells of them into another spreadsheet. The cells I need fro...
-
Picking up information from one excel sheet t Closed
Hello, I have a excel work sheet with a list of products with code numbers and differenct characteristics of the each product in different columns of...
-
Extracting data from 2 or more excel columns Closed
Hello, I've got a spreadsheet that looks a bit like this (only with loads more data on it): GENDER LANGUAGE LEVEL Male ...
-
Needs help to compare 2 excel Worksheet Closed
Hello, I need some help. I need to compare 2 worsheets. I need a macro that looks (compare) all the values in both sheets and then open a new work...
-
browsing for free on my laptop Closed
Hello, i will like to help me in browsing for free on my laptop without paying any subscription to anybody
-
comapare two columns containing date and time Closed
Hello, I would like to comapare two columns containing date and time data to is if the match. If the don't, i would like to return a value i.e. "1"...
-
Need an excel genius Closed
Howdy. I hope you guys can shed some light on a tricky situation and I shall try to explain best I can. I have an excel document where one of the t...
