The discussions
Creating if statement to filter and add.
SolvedHI, i am trying to create an IF statement to filter a row and then add the numbers in another row on those filters. so for example AA ...
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 ...
Browsers prompting user name and password
When I am signed in with my yahoo or Msn messenger. there is a option to to click and go to your inbox Directly. no need to open and browser type yaho...
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...
Outlook sending problem
Configuration: Windows XP / Internet Explorer 6.0 i m getting the error:- Server Error: 530, Error Number: 0x800CCC78 white sending mail from my out...
Unable to view pdf
I using mimx q5 mobile. but i cant view the pdf, and word, excel sheets through email system.
Adobe reader 8 installer information
Dear all, When I open PDF file then some error occurred. Like....... "Error 1406.Could not write value Content Type to key \.rmj. Verify that you ...
Copy filtered data and paste values
SolvedHi, I found this code in this forum. It selects data based on the filtered rows of data and then it pastes it in another sheet based under the name o...
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...
Auto filling color to a cell when included in
Configuration: Windows XP / Internet Explorer 6.0 I am adding the contents of a row of cells using a formula on another page in the spread sheet. HOw...
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. ...
How can i change the files from 2007 to 2003
Recently i just update my windows 2007, now the problem i used to scan in windows 2007 but the problem when i send this report to another person which...
Unwanted password
i turned on my computer and there is a black screen with a blue box and in the blue box it says ENTER PASSWORD. I did not put this on there. how do I ...
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 ...
If + and + lookup
I have a huge database with ranges (between numbers) Example a1 = 0 and b1 = 50 a2 = 51 and b2 = 100 etc etc In column c i have the return value ...
Copy cell data if give cell above is y
Configuration: Windows XP / Firefox 3.6.3 Can someone help me with this? E1, I1, M1, Q1 = Y and U4 = not filled in E4, I4, M4, Q4, U4 etc. ...
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. ...
How2recover outlook2003 emails(no bckup)
I formatted and reinstalled my computer and after puting windows xp on I installed outlook 2003 but now I lost all my old emails and I didnt backup m...
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
Auto filter issues
Hello, I am having issues with the auto filter in 2007 Excel. When I choose only certain information several other lines tend to hang on even though ...
Outlook express wont send outbound mail
I can get incoming mail in outlook express from hotmail and ATT but my out going does not work and my configurations are all correct as well as pass w...
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...
If a number in one column appears in another
Hello, I have column B with a series of invoice numbers. I need to know if that number appears in column A. In column C I tried =if(B3=A3:A11...
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 ...
Help with outlook express
To make a long story short I use outlook express. I changed email addresses so quit using this particualr email address I had for about 5 years. So wh...
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...
Changing a value using a look-up table
SolvedHello, I am looking for help on writing a macro that will perform a VLOOKUP formula that will compare the value in G2 on Sheet1, to the value in A...
Copying % formula
SolvedHi, I regularly calculate a series of number as a percentage of a sum that remains constant (expense item as a percentage of total expenses, for eg.) ...
Password
Configuration: Windows 7 / Internet Explorer 8.0 i for got my password of xp user how can i loggon
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 ...
Only count if column next to it contains
Configuration: Windows XP / Internet Explorer 8.0 I'm trying to figure out what formula will fill an if-then. I want to get the total number of YES'...
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...
Problem sending and receiving hotmail emails
Using Windows 7, I cannot send or receive emails in my Hotmail account Configuration: Windows XP / Firefox 3.0.18
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...
Insert day, date and month in words
Hello, I want my column to say eg Mon 4 Jan - don't need the year. I've got it to say Mon/04/01, which is ok, but I'd rather have the month in words...
Lookup in more than one table
Hello, I have a worksheet that contains 3 tables Each table consists of 2 columns A B Name Code AAA 300 BBB 301 CCC 302 ...
Pulling values from a list
I have an open-ended Excel SS that I need to do a few things that I can't quite figure out. Due to the uses of it, I can't post it here, but I'll att...
Text lookup within a string of data
I have a very challenging excel task at hand. I have basically two sets of data (names of employees). One set it a master list of all employees, while...
Pate values
Hi, I like this code and I am using it and it works great but I would only like to paste values. How do I do that? I have tried everything and I kee...
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 column values
SolvedI am trying to compare two columns to see if they carry the same values - column A has 556 values (starling at line 3), and column B has 69 values (st...
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...
How can i make cal from net to mobile at free of c
Hello, I LIKE TO KNOW WHETHER ANY websites providing free calls from net to mobile . . .any good answer reply to mobile no 9944246248
