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...

1 reply Last reply on 2 Sep 2010 by
RayH

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...

3 replies Last reply on 2 Sep 2010 by
RayH

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...

1 reply Last reply on 2 Sep 2010 by
Trowa

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...

4 replies Last reply on 2 Sep 2010 by
Smart_GCSE_Student

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...

1 reply Last reply on 2 Sep 2010 by
mysterry60

Change color of highest value

 Solved

Hello 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.

2 replies Last reply on 1 Sep 2010 by
ctyong86

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...

1 reply Last reply on 1 Sep 2010 by
rizvisa1

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 ...

24 replies Last reply on 1 Sep 2010 by
rizvisa1

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...

8 replies Last reply on 1 Sep 2010 by
rizvisa1

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...

5 replies Last reply on 1 Sep 2010 by
rizvisa1

Compare cell values

 Solved

Hello, 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...

4 replies Last reply on 1 Sep 2010 by
??????

Memory card password

Hello, I forget my memory card password can i break it Configuration: Windows XP / Internet Explorer 6.0

1 reply Last reply on 1 Sep 2010 by
netsa77

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 ...

4 replies Last reply on 1 Sep 2010 by
THIRU

Outlook problem, solution please????

Hello, TRIED SENDING MAILS THROUGH OUTLOOK, IT RETURNS A MESSAGE SAYING LIMIT1 90 REACHED... PLEASE WHAT DO THIS MEAN????

2 replies Last reply on 1 Sep 2010 by
EMMA

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...

4 replies Last reply on 1 Sep 2010 by
arshi

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...

1 reply Last reply on 31 Aug 2010 by
Ray

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...

1 reply Last reply on 31 Aug 2010 by
Ray

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...

1 reply Last reply on 31 Aug 2010 by
Ray

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...

2 replies Last reply on 31 Aug 2010 by
LoJames

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...

7 replies Last reply on 31 Aug 2010 by
Vivian

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...

2 replies Last reply on 31 Aug 2010 by
Issa

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...

2 replies Last reply on 31 Aug 2010 by
Dazza

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...

2 replies Last reply on 31 Aug 2010 by
Trowa

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...

1 reply Last reply on 31 Aug 2010 by
Trowa

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...

1 reply Last reply on 31 Aug 2010 by
netsa77

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...

1 reply Last reply on 31 Aug 2010 by
cha_mps

Password

 Solved

Hello, i forgot password of my lockbox software.how can i recover from it.

1 reply Last reply on 31 Aug 2010 by
Ambucias

Please send the tally

Hello, how install tally

1 reply Last reply on 31 Aug 2010 by
cha_mps

Signature in outlook !

 Solved

Hello everyone! Does anyone know where Vista stores signatures for Outlook?

6 replies Last reply on 31 Aug 2010 by
iconox

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. ...

1 reply Last reply on 30 Aug 2010 by
venkat1926

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...

1 reply Last reply on 30 Aug 2010 by
Ray

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...

6 replies Last reply on 30 Aug 2010 by
Ambucias

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...

2 replies Last reply on 30 Aug 2010 by
Ray

Problems with passwords

 Closed

Hello, 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...

Last reply on 30 Aug 2010 by
Ambucias

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...

1 reply Last reply on 30 Aug 2010 by
Ray

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 ...

1 reply Last reply on 30 Aug 2010 by
Ray

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...

3 replies Last reply on 30 Aug 2010 by
Trowa

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. ...

4 replies Last reply on 30 Aug 2010 by
DCecil07

Lost password

 Solved

Hello, 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...

3 replies Last reply on 30 Aug 2010 by
Ambucias

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...

1 reply Last reply on 30 Aug 2010 by
cha_mps

How to match two columns

 Solved/Closed

Hello, 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...

Last reply on 30 Aug 2010 by
nitin

Lost my ms office word key

 Solved

Hello, 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

1 reply Last reply on 29 Aug 2010 by
xpcman

Password for microsd 1gb had forgot

 Solved

Hello, 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...

1 reply Last reply on 29 Aug 2010 by
jack4rall

Password for dell latitude e6400

 Solved

Hello, im looking for the master password for dell latitude E6400 , THANKS

1 reply Last reply on 29 Aug 2010 by
Ambucias

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 ...

1 reply Last reply on 28 Aug 2010 by
Carla

Corby pdf viewer

 Solved

Hello, from where do I download software for my corby to view pdf files?

5 replies Last reply on 28 Aug 2010 by
Sushant

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...

1 reply Last reply on 27 Aug 2010 by
Ray

Please help! excel formula needed!

 Solved

Hello, I have a spreadsheet with many columns: date issued, invoice number, gross£, net£, vat£, date due, date paid. until the invoice is paid ...

2 replies Last reply on 27 Aug 2010 by
Ray

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...

1 reply Last reply on 27 Aug 2010 by
Ray

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!

1 reply Last reply on 27 Aug 2010 by
Ray
Results 7351 - 7400 out of a total of 12,266