The discussions
Excel 2007: reading data from sheet to sheet
SolvedI am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting ...
Excel formulas
I need a formula that will allow me too add the number of red cells. Can anyone help please Configuration: Mac OS X / Safari 525.13
Excel
I am working on a balance sheet i want a macro that can adjust the difference between assets and liabilities by increasing long term debt and i want i...
Web sheet design
Can I build a spread sheet in excel with several columns of information and import that to a web page? I have no experience building web pages but I k...
Excel formula
Hello, I am a total beginner at Excel and I (really) need a formula... If you could (please) give me the formula for this, I could alter it myself to...
Import web data into excel
Hello, I'm currently importing stock data into a spread sheet, and it works pretty well. What I would like the "update All" button to do is automatica...
Excel vlookup macro
SolvedHello, I am working on a project to create a simple VLOOKUP. I have created the macro and it works well, but now I am looking for some advise on ...
Concatenate multiple rows into one row excel
Please need help in macro, I have thousands of data from .txt to .xls. Example of data value Description gem-967869 C...
Excel '03 data filter puzzle
I'm using Excel '03 and I have two columns with data, A & B. Column A holds the name of a letter and Column B stores the body of the letter. When ...
Internet connected but not able to browse
Hello, Windows XP Desktop is showing that its connected to the internet, but when I try to open internet explorer it says. Cannot Find Server. Page ca...
Can connect internet but not to browse
Hello, Windows XP Desktop is showing that its connected to the internet, but when I try to open internet explorer it says. Cannot Find Server. Page ca...
Interesting question for excel champions
SolvedHello, Interesting Question Guys: Suppose Sheet 1 Is "Data" Sheet And There Are Too Many Rows... Like A3 Is S.No B3 Is Supplier Name C3 I...
Coping rank for whole dataset in excel
SolvedHi i want to work out the ranks for my whole data set, if i type in the formula for the first line then drag it for the rest instead of working out ...
Automation of running excel macros
SolvedHello, I have a macro in excel which needs to be run once a day and i dont even want to open the excel sheet. How can i make this process automatic...
Macro: group cola with colb results
Im trying to build a macro to produce the expected results below. I have duplicate tests in ColA with associated data in ColB: I need to merge the...
Browser not connecting
My computer connects to the internet and Windows update works. Only firefox & IE8 cannot connect to a website. I turned off the firewall but that did ...
Drop down boxes in excel 07
Dear All, I have two columns A & B which i wish to turn into two drop down boxes, the first drop down box i wish to search column B for 1 of 4 allo...
Copy data to excel below existing data
Hi, I want to copy the data from some other source to the excel. The copied data should get pasted few rows below the existing data. Configurati...
How to copy a row to another worksheet
In am maintaining a file in Excel 2007 in which I would like to copy rows containing specific data in a particular column from a master worksheet to a...
How to align all common list in excel?
Solvedi have 4 columns. the first two (A & B) columns are list of cheques i issued. then the other two (C & D) columns are list of cheques encashed from Ban...
Macro to find/replace in notepad
I am in need of editing a text file in notepad that was created via a macro in excel. I have created the code to open the file in notepad but was won...
Create lists of columns containing a value
I have a need to populate a column in one sheet with column headings from another sheet that contain a given value. I will illustrate better below. ...
Browser not loading pages
I don't know if my Firewall is totally misconfigured or if the antivirus program that I have on my PC (Win 7) is keeping me from loading webpages. If ...
Coping cells with a loop
SolvedHello, I am stumped on what should be a very simple macro. I am running a macro that is using a look-up table to compare the values in column G. ...
Freebrowsing on mtn zain both gsm and laptop
pls guys get me free browsing on dis network mtn and zain both on phone and laptop send it here email kwada90@yahoo.com
Lookup a header in a table - excel 2003
So HLOOKUP doesn't seem to work as well as I hoped on this one, I would like to return the text on the top of a table column by first finding some...
Comebiine multiple cells displays formula
Configuration: Windows XP / Firefox 3.0.18 In Excel 2007 Very basic formula but I think it is a bug. A1 has first name; B1 has last name; C1 has ...
Excel copy not working
Hey, I got a code from this site and made changes to copy from a different excel file and paste to another file. I'm copying from a file Source.xls...
Using excel macro to insert jpeg from dir
Hello, Please help. I have written a macro to pickup jpeg file from the directory and insert it into excel. I have issue with picking up jpeg ...
Ms excel issues :/
I need to replace a range of 7 cells with a choice of another several ranges, based on the valueof (yet) another cell. For example: Range a1:a7 val...
Copying of data from one excel file to other
Hello, I have a excel file which is having the list of filenames (eg- MEF_collection) in B column. Now i wanna open another excel file which ...
Lost my huawei driver mini cd and the browsi
I have lost my Driver CD for the modem supplied along with modem so please download the same for installin once again on my laptop after formating it,...
Help on excel formula
SolvedI need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...
Excel file not open in spice qt66
I have Spice QT66 model. i try to open xls. file in phone but not support phone. can tell how i can view this file. Configuration: Windows Vist...
I need to consolidate multiple columns- macro
I am trying to write a macro so that I can combine data from several worksheets, the data is contained in different columns in each worksheet but eac...
Comparing text lists in excel
I need to compare a text list in Excel in Column A in Sheet #1 to a text list in Column C in Sheet #2 and then print the resulting text it found in Co...
Excel data copy
I am looking for a formula that does the following: Looks at cell values in a particular column If the cells have data it then copies that data to a...
Create macro to copy data from rawdata file b
Hi experts... Need a help from you to create an macro to copy the data from rawdata file by condition and paste it into another summary excell file. ...
Critical macro to copy from rawdata to summar
dear all, I need your kind help to create an critical macro in which i have 2 files, 1. rawdata in which i need to filter for certain conditions ...
Help cant brows microsft webpage
hi i run 2003 server and for sum resone i cant acces microsoft webpage but i can brows all other webpages on the net can annyone help me Configura...
Excel function as a quoted cell number
Hi, I want to have a formula for the number of the row I am quoting, i.e. B[=4+4*A7], but it does not work Thank you! Elena
Excel
Hello, I have a 3 columns say A, B and C.. Column A has say 140 names and Column B and C have 256 names as B and C are dependent on each other. ...
Vba code to send a mail
Hello, guys, im looking for a VBA code to write that so when i click upon a command button it will populate a pre ready email with a fixed list of...
No browser opening,internet connection presen
Hi, I m not able to open IE or mozilla to connect internet, though I have internet connection, bcz the messengers are working fine. Please Help....
Identify two or more are same or not in excel
SolvedHi Everyone, I have an excel formula question that someone might can help me with. A B 1
I need a macro created for the example help!!
Hello, I have a two columns A and B as listed below: A B C Location Phone CHENNAI 4458720241 CHENNAI...
Copy a range of cells to another worksheet
Hi, I have a workbook containing multiple worksheets. I enter data manually in all the worksheets except one say worksheet "X". My requirement is to p...
Excel: convert rows to columns and sort by id
Hi, I have an Excel sheet with the data in this order: A B C D date1 / text1 / amount1 / ID1 date2 / text2 / am...
Moving data from one worksheet to another
I am using a userform in excel 2003 to enter budget data onto a spreadsheet (sheet1). That data includes a cost code, date, value, order no. I want t...
Excel lookup question
Im very basic excel user, Im trying to Search a Database of 6500+ entrys, Its a basic search that i cant seem to work correctly. Basically Each ro...
