The discussions
Conditional formatting help - colour and days
Hi Hoping for some help! Currently cell A1 has the day of the week in it (not automated) I want cell J8 to be white if the day in A1 says Wed...
Excel macro deleting unwanted info
Hello, I am trying to use macro to sort through a lot of data, choose a certain chunk, and copy and paste the chunk to a new file. I am able to cop...
How to compare two columns.
Hello, i have excel sheet with more columns with applied more formulas. now i want to compare two columns values are equel or not, that rusult sho...
Wild card functions for if function in excel
Hello, im writing in regards of how to formulate the IF function in excel to seperate out certain characters in a particular cell. For example if a...
Smtp settings
Hello, I have set my email account in Microsoft outlook express 2007. My id is corporate one and it is in mail.pw. All my outgoing and incoming ma...
Change color of highest value
SolvedHello everyone, i need a favor. i want to change the font color of the highest value from C3:X3 anyone can help me? much appreciate.
Creating email address with data from cell
Hello, Thank you in advance for your help with this. I have a column that contains the first and last names of people. I need to create a colu...
Macro insert into another sheet
Hello, Please I need some codes for this excel prob. Can anyone help me??? sheet 1 doc num accnt num 2000149110 1123 2000149110 1124 ...
Vlookup
Hello, IN A1 COLUMN FLAT NUMBERS , B1 COLUMN "RECEIPT NO" AND C1 COLUMN "AMOUNT PAID". IN ANOTHER SHEET I HAVE FLAT NUMBERS IN ROWS LIKE A001,AOO2...
Searching, copying, and pasting data
Hello, I Am trying to write a macro in VBA. I am trying to search for certain pieces of data in one sheet and move it to another sheet. Specific...
Compare cell values
SolvedHello, i want to compare the Content of 2 Cells And Replace the value of the cell with the lowest value. like this cell A1 got a value of 21 an...
Memory card password
Hello, I forget my memory card password can i break it Configuration: Windows XP / Internet Explorer 6.0
Comparing two excelfile worksheets
Hi, One more scenario I have . If I have three columns in worksheet1 of file1(book1) and 1 column in worksheet2 of file2(book2), I should get only ...
Outlook problem, solution please????
Hello, TRIED SENDING MAILS THROUGH OUTLOOK, IT RETURNS A MESSAGE SAYING LIMIT1 90 REACHED... PLEASE WHAT DO THIS MEAN????
How to active password on memory card?
Hello, Hello, i am using nokia 6300 n memory card(micro sd,1 GB).i want to make it password protected.whenever i want to put password in it,i can pu...
Multiple workbooks trying to combine into one
Hello, I have multiple workbooks I'm trying to combine into one, so I can perform some data analysis. I'm trying to have a date only show up when a...
Excel 2007 - generate and excel from another
Hi, I have been stuck with this problem for a bit. The problem is - I am sending this excel file to my customers to fill in the bare minimum inf...
Only numeric value
Hello, i can read only numeric value at given bellow Sell 45621 aa aaaaaa Sell 4561 aa aaaaaa Sell 456 aa aaaaaa Sell 56 aa aaaaaa Sell 6...
Lookup function, keep range static
Hello, I understand the Lookup Function in a simple way. I want to copy the Function statement down a column, to lookup data from another sheet. Th...
Nbring same records showing > 1x sequencially
Greetings, My first experience asking a question on this forum was extremely helpful. So I'm trying my luck again. Many thanks to those who coul...
Run same vba macro code on multiple sheets
Hello, I am trying to run the following code on multile sheets in a workbook. so far this code is working fine for one worksheet. Can someone help...
Excel help
Hello, Configuration: Windows XP / Internet Explorer 6.0 I am using a spreadsheet where column A will have as part of the cell text string L3 o...
Excel formulas
Hello, I would like to ask for help on how to go about writing a formula in Excel. I have a bank statement that is approx. 2500 to 3000 line i...
Changing dates into a month on vba
Hello, I have a column which lists the dates of certain activities in dd/mm/yy format. In the next column I would like the macro code in vba to re...
Office03 excel file not open in win7 offic07
Hello, Configuration: Windows 7 / Internet Explorer 8.0I newly installed windows 7 with office 2007 in my system. office 97- 2003 format excel...
Issues opening a word doc
Hello, Has any one had any issues opening a word doc file after installing the quick office on your Nokia 5800 mobile? Configuration: Windows V...
Please send the tally
Hello, how install tally
Signature in outlook !
SolvedHello everyone! Does anyone know where Vista stores signatures for Outlook?
Creating macro's
Hello, We have two excel sheets say sheet-1 and sheet-2. I have to copy particular cells say, from column 'A' first cell to column 'A' 25th cell. ...
Help! find/search within text in excel issue!
Hello, I need help, my boss wants me to put together an excel doc. with 4 columns -A, B, C, D - that when you do CTR+F you only retrieve/search in...
Formulas finding text
Hello, I would like to ask for help on how to go about writing a formula in Excel. I have a bank statement that is approx. 2500 to 3000 line ite...
Formula for date
Hello, I am doing a macro in which while doing page setup we have to put that days date in header, Is there any formula we could give so that it a...
Problems with passwords
ClosedHello, Im having trouble with the password in administrator, and there is only one administrator on the computer which I cant get in the the guest...
Excel
Hello, How can I have excel copy the entire row of data from excel file "sales" to another excel file called database if column N contains COMPANY...
Excel formulas
Hello, Please help me with this ? I know what the percentage being deducted and I know what the end total is, I would just like to know how to ...
Merge cells into one
Hello, Need help to merge range of cells [on selection] into the last selected cell [using - sign as a separator]. Is there a Function or a macro...
Excel macro to find last cell in sheet
Hello, I'm building a compare using Excel and the macro is going to be used on all sorts of data sizes. Could be 100 rows, could be 2000 rows. ...
Lost password
SolvedHello, i lost the password to my dell desttop what do i got to do to get on it? i have Windows Vista Configuration: Windows Vista / Internet Exp...
I'm trying to open a wavestar ".wk" file usin
Hello, I'm trying to open a WaveStar ".WK" file using VBA. I'm able to execute the main file but I recieve an error when I try to then open the f...
How to match two columns
Solved/ClosedHello, I have 2 excel sheets with exactly the same format, in column A, I have the name of my customers and in Column B, the value of their sales. th...
Lost my ms office word key
SolvedHello, i lost my ms office word key and i don't no how to review so plz help me. thank's Configuration: Windows XP / Firefox 3.6.8
Password for microsd 1gb had forgot
SolvedHello, I am using Nokia6300 with microSD 1GB momory card. The password for the card have forgot ,so please help me to unlock the card. Conf...
Password for dell latitude e6400
SolvedHello, im looking for the master password for dell latitude E6400 , THANKS
Allocating positions in a line
Hello everybody, Iam not an expert using code just learning with a excel vba for beguinners but honestly I don't know how to star trying to create ...
Excel condition format based on specific date
I'm trying to use conditional format in Excel to turn the cell GREEN if the date entered is AFTER Sep 30, 2009. Default is Red. I appreciate any gu...
Please help! excel formula needed!
SolvedHello, I have a spreadsheet with many columns: date issued, invoice number, gross£, net£, vat£, date due, date paid. until the invoice is paid ...
Run macro by choice in data validation list
Hello, Excel 2007-I have a macro that I want to run IF one choice of a data validation list is picked. I've read through the site and don't unders...
How to sort/group all highlighted
Hello, I was wondering if there's a way to group all the highlight cells from the unhighlighted cells. thanks!