The discussions

How to send an email through an outlook

I need to know please how to send an email message through an outlook thanks

Last reply on 11 May 2010 by
dist.urbd

Identify & mark the data

I have the data in 2 columns i.e A & B. In A column amounts are there(both positive & negative values) and in B column invoice no. are there. Every po...

Last reply on 11 May 2010 by
venkat1926

Data entry

how do I take a row of information in one sheet to another sheet just by entering the info in the first column? Configuration: Windows Vista / Inte...

Last reply on 11 May 2010 by
rizvisa1

Excel formula problem

Hi there, Was hoping some one out there could help me with an excel formula problem... I have a Table ---- A B C ...

Last reply on 10 May 2010 by
rizvisa1

Excel formula help!!!!!!!

I am doing a spreadsheet for a fishing league and would like to know eg: f6 h6 ...

Last reply on 10 May 2010 by
rizvisa1

How do i show multiple matches from one list

Hi I have a worksheet Database of 10 columns X 70 rows of data detailing youth camps and a second sheet in the same workbook with a search facilit...

Last reply on 10 May 2010 by
venkat1926

Sending mail with outlook 2010

I have just installed Outlook 2010. I have a mail account with yahoo and can receive messages but cannot send. Please help.

Last reply on 10 May 2010 by
TIGERsHAKER

Excel 2007 vba find last

 Solved

I have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a c...

Last reply on 10 May 2010 by
rizvisa1

Password problems

i try and i try and i try i key in the password and it just sits and sits and sits. it never used to do this, it used to be as soon as you typed in th...

Last reply on 10 May 2010 by
suff954

Combining data in excel 2007

I have a list of names on one worksheet (Sheet2). Doe, Jane Smith, Joe Hawthorn, Mya On a seperate tab in the same workbook I have another ...

Last reply on 10 May 2010 by
rizvisa1

Excel copy cells based on condition

I have an Excel file with a list of contacts on the first sheet. This sheet is labeled "Master List". In column B of the Master List sheet I am putt...

Last reply on 10 May 2010 by
rizvisa1

Outlook can't send

hello sir, i,m working in outlook ex 2007 and I can't send messages! How can I solve this problem? Configuration: Windows XP / Int...

Last reply on 10 May 2010 by
suff954

Macro to find a info in more than one column

 Solved

Hi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [t...

Last reply on 10 May 2010 by
rizvisa1

Calculate cost in access database

Hello I am trying to calculate the total cost of time and labor when a quality report is written. My database has a subform which gets updated peri...

Last reply on 10 May 2010 by
rizvisa1

Excel

hi... i am trying to do set formula one excel file to another file but it's not working.if i set formula same file but another sheet it's worked... i...

Last reply on 10 May 2010 by
rizvisa1

Excel reset button

Hi all , I am using a form, inputting lots of data into many cells to get a quote, I wonder if there is a way of having a master reset button that ...

Last reply on 10 May 2010 by
rizvisa1

If statment

i want to add an if statment into an excel sheet with the same stracture of vb

Last reply on 10 May 2010 by
rizvisa1

Help me for the following problem(excel)

Dear All, I have an excel sheet which looks like following with the column header(part, Assembly,AVG) Part assembly AVG ...

Last reply on 10 May 2010 by
rizvisa1

Excel 07 to excel 03?

Configuration: Windows Vista / Firefox 3.6 So I have multiple files I created on my new win7 os.... doing the work at home instead of at the job. N...

Last reply on 9 May 2010 by
rizvisa1

Comparison

Dear All, I have an excel sheet which looks like following, Part assembly AVG 7 1.34 40.97 4 5.59 47.38 2 6.19 33.74 1 6.24 39.58 8 6.63 ...

Last reply on 9 May 2010 by
rizvisa1

Alternative for hlookup?

Configuration: Windows XP / Firefox 3.6 I am have been a excel VBA programmer from last couple of years, but not an expert in excel formula. Thou...

Last reply on 9 May 2010 by
rizvisa1

Sorting dates using excel / vba

Configuration: Windows XP / Firefox 3.6 Hello All, Just wondering if you can help me in writing VBA sorting logic for Date in asc or dsc order....

Last reply on 9 May 2010 by
rizvisa1

Zeor to the end of 4 digit number

 Solved

Hello, Can someone tell me a formula or macro that will add a 0 Zero to the end of a 4 digit number in each cell. I get a excell file with the 4 di...

Last reply on 9 May 2010 by
billkirby

Excel query

Hello, I have a query. Whenever I export a file from internet the data gets saved into a new excel file instead of the excel sheet I am working i...

Last reply on 9 May 2010 by
sunil

Excel frame a do while loop or macro

 Solved

Hi All, Could anyone help me to frame a Do While Loop or a suitable macro? I need a method to copy formulas present in Cells F10 to Q10 in She...

Last reply on 9 May 2010 by
madambath

Excel macro to select the latest date

Hi, I have a excel sheet with 6 sheets (1,2,3,4,5,6). The macro for the excel sheet would select all the rows with status 'In Progress' in column P...

Last reply on 9 May 2010 by
rizvisa1

Assign a relative value from a cyclic range?

Ok, i have a very specific and (i assume) fairly complex question: In one sheet i have a data range of 18 time stamps (numeric value of minutes) ...

Last reply on 9 May 2010 by
rizvisa1

Unistall & reinstall the ms office 2007

I have purchased ms office, downloaded & installed in my laptop, with widows vista as OS. Now, I am changing my laptop. How to uninstall & install the...

Last reply on 9 May 2010 by
jorhay

Someone change my emaill pass word

SOMEONE CHANGE MY EMAILL PASS WORD THIS IS MY EMAIL LMSAT-7OZN@HOTMAIL.COM

Last reply on 9 May 2010 by
closeup22

Forget pass word

Hello, pls i forget my pass word help me

Last reply on 8 May 2010 by
SALIM

Make cell keep a total from vary data

How can you make a cell keep a running total when any number is entered in to another cell? ie enter a number in A3, A1 keeps total enter another numb...

Last reply on 8 May 2010 by
macca

Excel date format to be change

WOULD LIKE TO CHANGE THE DATE 07.05.2010 TO 07-05-2010 FORMAT

Last reply on 8 May 2010 by
rizvisa1

Date formate

 Solved

Configuration: Windows XP / Internet Explorer 8.0 hi i have date formate in dd\mm\yyyy & dd-mm-yyyy. i need all the dates in same formate exp. ...

Last reply on 8 May 2010 by
rizvisa1

Formula for dropdown list

 Solved

Configuration: Windows XP / Safari 532.5 n excel i want to use a drop lown list and when enter specified text, then next cell should display my spe...

Last reply on 8 May 2010 by
rizvisa1

Problem in date format

 Solved

Hi EVERY one I have very Big Problem i am making one report where two type of date format is appearing like MM-DD-YY 03-08-2010 and DD--...

Last reply on 8 May 2010 by
rizvisa1

How to set password for inbox

Configuration: Windows XP / Firefox 2.0.0.9 vbmnvnbnbhghjgj

Last reply on 8 May 2010 by
dist.urbd

I want the installation cd key of cod 5

 Solved

i have the cd and i have lost the cd-cover and also lost the installation code,please help me.

Last reply on 8 May 2010 by
dist.urbd

Msd card password recovery

Hi,i forget my memory card password..how to recover it bek? i'm using microsd (1GB) memory card..n using it in nokia 7210 supernova

Last reply on 8 May 2010 by
dist.urbd

Insert rows with data when criteria is met

 Solved

Hi, Thanks in advance for your help. I have two tables. If a field in table A is chosen, I want a macro which will insert rows of the data listed ...

Last reply on 8 May 2010 by
venkat1926

Column wise condition formating

I HAVE A ATTENEDANCE TABLE LIKE THIS NAME 01 02 03 04 05 06 07 08 09 10 UPTO 31 M T W T F S S M T W LIKETHIS ARUN ...

Last reply on 8 May 2010 by
venkat1926

Protect files from being copied

Hi, I'm working in a company and will have to give a client some pictures. Before giving him the pictures I would like to know if there is a way...

Last reply on 7 May 2010 by
sunder

Need help with a graph

Hi all, I created a simple financial excel spreadsheet. Right now it is basically a glorified check register, but what I want to do is make a pull...

Last reply on 7 May 2010 by
rizvisa1

How to map excel files to a common excel file

EXCEL: I need to extract certain columns from different active worksheets (4-5 files) into one summary worksheet. The exact column headings may or may...

Last reply on 7 May 2010 by
rizvisa1

Merging information

I have an excel file containing two sets of (hopefully identical) serial numbers, the second set has significantly fewer serial numbers but also conta...

Last reply on 7 May 2010 by
rizvisa1

Hlook up help!!! please !!!

Does any one know why my HLOOKUP formula that I have looks up the answer even though i give a wrong value. When i enter the date it looks up the ...

Last reply on 7 May 2010 by
rizvisa1

Pulling in data from 1 workbook to another

I have one workbook in which staff members enter information regarding specific departments. The first column is the name of the department and the f...

Last reply on 7 May 2010 by
adit

Copy comments from sheet to sheet

I am using this formula: =IF(ISBLANK(Master!A1),"",Master!A1) If A1 on the 'Master' sheet has a comment, how can I bring it to the sheet I am u...

Last reply on 7 May 2010 by
rizvisa1

Input a range of cells

 Solved

If i want to highlight a row of cells in red to show a lead is dead say A1 to E1, buy inputting "lose" in E1 I now have the formula =$A$1="lose" whi...

Last reply on 7 May 2010 by
andy

Copy data next to a cell and paste it below

 Solved

Hi, everyone I am a newbie in here, and I hope some one can help me solve this: I having a data such as the following cell | A ...

Last reply on 7 May 2010 by
kent5244

Formula is too long....

Can anyone simplify this? =IF(SUM(COUNTIF(M198,"Y"),COUNTIF(M200,"Y"),COUNTIF(M202,"Y"),COUNTIF(M204,"Y"),COUNTIF(M206,"Y"),COUNTIF(M208,"Y"),COUNT...

Last reply on 7 May 2010 by
rizvisa1
Results 8651 - 8700 out of a total of 12,264