Excel Forum
-
index and matching 2 different spreadsheets Closed
Hello, i am trying to index and match two diffrent excel spreadsheets. one has the same info on it as the other except for one column. i'm trying t...
-
Can VBA Code the Blank Spaces in a Column Closed
Hello, What I have is a single column of text data with blank cells intermittantly throughout the column. I need to perform the same user designed ...
-
can not open FireFox browser Closed
Hello, i have downloaded the fire fox explorer, and was installed successfully, but i can't open the browser. Thanks
-
Macro: copy and paste Closed
Hello, Can anyone help me, please? I want an excel macro that will copy and paste some data. I have a column of data from A1 to A31. I would like a ...
-
writing a macro in excel using vba Closed
Hello, This is homework, I am so lost. Here is the problem: 1. Write a macro, Q_1, which will ask the user for the division of an employee and t...
-
ms excel problem Closed
Hello, how to select the date of births lying between 2 given date of births
-
macro help...copying and pasteing Solved/Closed
Hello, I'm trying to write a macro to copy a row of cells to where the cursor is. The info is constant and the pasteing changes. I've used the "reco...
-
getting last value in Excel workb and copy Closed
Hello, wondering if some1 can help me. I have 2 worksheets CertNo.xls and UncertB.xls. In UncertB.xls i have a button. When i click this button i ...
-
Macro in Excel (VB) Closed
Hello, Basically i'm not much of a programmer, but can do the basics on Excel. I've just been writing a nice little programme on Excel, but need so...
-
EXCEL VALIDATION Closed
Hello, If I am having A1 is fixed value and E1= B1+C1+D1 & BUT E1 SHOULD NOT BE MORE THAN A1, IN HOW I CAN VALIDATE E1 WITH A1
-
Browswer only works with IP Address Closed
Hello, I am using Acer Extensa. I tried to connect with Ethernet cable at home and today wirelessly to my work network and it works ok. The only pro...
-
Converting Web page to Excel format Closed
Hello, I want to ask that if i want to convert just dial web page data in to excel format so how can i do that so that it can come in excel format
-
Excel Conditional Cell Formatting Closed
Hello, I need an MS Office Excel 2007 formula. I want to fill multiple cells in a row with color IF one particular cell in the row is divisible by ...
-
Excel 2007 Sum Formula Closed
Hello, How do I add a range of cells and locate the sum in a chosen cell?
-
EXCEL SHEET FORMULA Closed
Hello, how can i change the name in colone A automaticly if i changed from colone R ? exemple: if i put ROULA in colone A and go and put NANA i...
-
Excel Formula Closed
Hello, Looking for formula assistance. Have a series of columns, A-C, containing dollar values. I have column D set up to find the minimum value. ...
-
2007 Excel Closed
Hello, I have a question about 2007 Excel with files that are saved . When I try to open a box pops open that says Windows cannot find 'C :USERS/Da...
-
Running macros without Closed
Hello, when I run a macro and afterwards close the Excel spreadsheet I am working on, the little screen with the message "do you want to save chang...
-
find text and copy into new column (excelvba) Closed
Hello, Please help me, can anyone of you tell me how to find a text in excel for example "channel1" then find "channel2" and then "channel3".all the ...
-
remove rows in excel if not in list Closed
Hello, I have an excel spreadsheet with chart number and data, many chartnumbers are there multiple times (which is correct). 36K rows. I want to...
-
Change cell reference mutliple sheets formula Closed
Hello, I have 7 spreadsheets that I am currently using the IF formula for. These spreadsheets all have the same format so currently the formulas s...
-
configuration on pc opera browser to enable cheap/ Closed
Hello,pls tell me what to configure on my opera pc browser to make browsing very cheap;if free,better.i luv u! My e-mail is nattytozum@yahoo.com OR p...
-
Count the matches in two excel columns Closed
Hello, I am trying to compare the numbers in e82:i83 to numbers in e109:n110 and count the number of matches with the total to show in another cell, ...
-
excel formula help Closed
Hello, could you please provide me with the list of formulas and what it does please.
-
best browser Closed
Hello, what's better to use google chrome or mozilla firefox. Could you help me to choose what to download. i t will be very helpful.
-
Copying cell content from one spreadsheet to Closed
Hello, Sometimes when I select a range of cells to copy to another spreadsheet, the result on the new spreadsheet is blank. And then if I save that ...
-
Excel Macro Help Closed
Hello, I'm trying to create a macro that will search a column for cells containing certain words (i.e. student) and then delete the rows containing t...
-
Open a folder in excel Closed
Hello, What is the vba code to open a folder in excel, i have tried assigning a hyperlink to a command button, but this opens the folder from the r...
-
word/excel passoword lost Closed
Hello, I have loss my word/excel password both are my personal files, can u pls help me. Sudheer
-
Macro Closed
Hello, I wanted to create an application. I have a sheet "sheet1".there are 3 columns namely name, author and date. A B C 1 Name Author Date 2 ...
-
Help on freedom browser Closed
Hello, have been using freedom software on my laptop. When i connect it to my phone am using Mtn but is no more working i want you to help of out.
-
change excel formula Closed
Hello, Below is the current formula in the Tax column of my spreadsheet. =ROUND(IF(D5
-
Spreadsheet date Closed
Hello, Urban legend around my office says that you can put a formula into Excel that will change the date in a cell within the spreadsheet if you ...
-
Importing a file in excel Closed
Hello, How do i get excel to open up a notepad file and make it look exactly the same as if i was opening the .txt in notepad. I have been using...
-
excel formulas Closed
Hello, I have a spreadsheet that I am using to calculate all my staffs wages and taxes etc. Column :- D is Gross Wage E is Tax (amount to take o...
-
Outputting numbers 1 to 100 in rows of 10 Closed
Hello, Could someone give me help with Excel: how to output the numbers 1 to 100 (10 rows with 10 columns) using a For loop. so far i have the foll...
-
Excel problem Closed
Hi Sir, I am having trouble using excel to make spreadsheets, where can I obtain an Ebook on how to use MS Excel.
-
Excel Help Closed
Hello, I have an excel sheet (sheet 1) with following columns and values filled in . ID Status Name Original Date % Complete Forecast Date Act...
-
Excel Formula needed Closed
Hello, I have a spreadsheet (Sheet1) with 45000 identifiers. I need search another sheet (database) for the identifiers and return a text value from ...
-
Excel Macro Help Closed
Hello, I am looking for a way to password protect certain worksheets from viewing. I have sales totals in one sheet and sales commissions in ano...
-
cant use arrows to move anymore Closed
Hello, I used to be able to use my arrow keys to move from cell to cell. now it moves the entire spreadsheet page left right or up and down. I made s...
-
counting cells with diferent data in them Closed
Hello, Is it posible to make formula for counting cells with only diferent entries(text or numbers) in them? Anyone can help on this? thx
-
compare and extrate related datas from excel Closed
Hello, I have two spreadsheets that I need to compare and merge. Here's what I'm looking to do: Sheet 1 Customer Number Customer Name ...
-
how to get sub total in excel Closed
Hello, plz help me in getting sub total, for following example Reg exp ab01 11 ab01 10 ab01 9 sub total=30 ab02 8 ab02 ...
-
Excel Help Closed
Hello, I have two worksheets. In the first worksheet I have 1 column (column a1) with numbers in them, on the second worksheet I have 2 columns wit...
-
which Excel function shall I use Closed
Hello, I need you a great help. I want to input every updated data in cell A1 in sheet 1 every day, for example, but I want all old data were input ...
-
Compare one column to multiple columns Closed
Hello, I have a list of values in one column (A) that appear within 5 other columns (B,C,D,E,F). I would like Excel to highlight whenever a value f...
-
compare two sheets and paste in new sheet Closed
Hello, I need some help for my work. Sheet1 contains some numbers in column A2:A500 Sheet 2 contains some numbers in A2 : AXXX ...
-
excel Closed
Hello,I have a problem with ms excel I want to write a formula contain 20 fields but after pressing ENTER it say *Value* Thanks
-
2 xcell worksheet link Closed
Hello, Dear Team i have a quary, tht i want to copy one xcell worksheet data to another xcell worksheet data, and moreover when i changes/modify 1s...
