The discussions

Finding a date (n30) in a date range b5:b30 and returning a3text

 Solved

Hello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...

3 replies Last reply on 29 Apr 2015 by
MaxStart

Auto. copy a row of data onto another sheet using conditions

 Solved

Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...

8 replies Last reply on 28 Apr 2015 by
Don't Know

Macro to search for a word and put a code on the cell next to it

 Solved

Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...

2 replies Last reply on 28 Apr 2015 by
A.E

Can't open scanned document when broken up into 2 pdf's

 Solved

When I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...

1 reply Last reply on 27 Apr 2015 by
thierryhauet

Repair outlook express dbx file

 Solved/Closed

has a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...

Last reply on 26 Apr 2015 by
ruudromein

Macro for blanks

 Solved

Hello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...

3 replies Last reply on 21 Apr 2015 by
vcoolio

Date of birth in words

 Solved

Hello, How can I enter date of birth in words in Excel?

1 reply Last reply on 20 Apr 2015 by
TrowaD

Recover corrupted outlook express folders

 Solved

I accidentaly deleted some folders in my Inbox Folder. My problem is now, how do I get back the .dbx files without losing any important information? P...

1 reply Last reply on 14 Apr 2015 by
balighawad

Transfer data from one sheet to another automatically

 Solved

Hello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...

19 replies Last reply on 14 Apr 2015 by
vcoolio

What cell is my data coming from?

 Solved

Oh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...

4 replies Last reply on 8 Apr 2015 by
BrianGreen

Transferring information from previous spreadsheet

 Solved

Hi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...

17 replies Last reply on 7 Apr 2015 by
skreechy

How do i resolve file corruption errors in powerpoint 2010?

 Solved

Dear All, One of my colleagues is getting an error frequently(attached) in powerpoint 2010 and as a result he keeps losing many slides that he prep...

3 replies Last reply on 6 Apr 2015 by
montesquinto

Single quote - excel 2007

 Solved

Hi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not ...

8 replies Last reply on 6 Apr 2015 by
FLAWLESSVW

Conditional formatting based on expiration dates

 Solved

Hello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to b...

2 replies Last reply on 6 Apr 2015 by
BC

Two criteria to check if a date in excel

 Solved

Despite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or "Out" ...

13 replies Last reply on 5 Apr 2015 by
vcoolio

Formula to add big number of day to date in excel sheet

 Solved

Dear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180 day...

3 replies Last reply on 4 Apr 2015 by
mgkimmel

Using the last few characters on a different sheet

 Solved

Hi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script that n...

2 replies Last reply on 3 Apr 2015 by
BrianGreen

Vlookup won't work

 Solved

I am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...

2 replies Last reply on 2 Apr 2015 by
Cookie5

Set cell value

 Solved

Hello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...

1 reply Last reply on 28 Mar 2015 by
MaxStart

Vba copy sheet to new excel file + automated manual data entry

 Solved

Configuration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...

4 replies Last reply on 28 Mar 2015 by
MaxStart

Excel formula

 Solved

hello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...

4 replies Last reply on 27 Mar 2015 by
Nic

Recover deleted emails in outlook express...

 Solved/Closed

Hi! Prompt please... Is there any way to recover deleted e-mail messages in Outlook Express? An important message was accidentally deleted from the...

Last reply on 26 Mar 2015 by
joseph.robinson

Code visual basic

 Solved

Hello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...

2 replies Last reply on 26 Mar 2015 by
mcculloch1dj

Excell 2013 - conditional formatting using a formula- apply rule

 Solved

Hello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...

2 replies Last reply on 26 Mar 2015 by
Manos

Excel formula display in cell

 Solved

Hello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...

6 replies Last reply on 25 Mar 2015 by
rc

How to open a prn file in office/word 2010

 Solved/Closed

Hello, How do you open a PRN file to see how it converted? I only want to open the document to see how it converted, not print it. I used Window...

Last reply on 25 Mar 2015 by
Aduka

Some cell date could not change

 Solved

Hello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0

1 reply Last reply on 24 Mar 2015 by
TrowaD

Comparing data in 3 columns on a microsoft excel spreadsheet

 Solved

Would be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...

2 replies Last reply on 23 Mar 2015 by
daniz39

Excel 2013 formula - maybe if formula?

 Solved

I have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...

2 replies Last reply on 23 Mar 2015 by
Cookie5

Wordnum help needed

 Solved

Hello, I hope somebody can help. I use WordNum to spell the result of a formula and it gives me 4 digits (spelled) after the point. I need just ...

7 replies Last reply on 19 Mar 2015 by
TrowaD

Cell format

 Solved

Hi Guys, I'm new here, I have a very limited knowledge about excel. My superior has asked me to do some sort of Advanced Cell Formatting in our per...

3 replies Last reply on 17 Mar 2015 by
MaxStart

Text-to-text equals number

 Solved

Hi.. I'm looking for a solution for a dilemma I'm in.. On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell. On sheet 2 I have the...

5 replies Last reply on 17 Mar 2015 by
kriswiberg

Formula, blank cell

 Solved

Sorry in advance if this has been asked but I can't see anything. Excel 2010 I have a cell that will contain a date then the next adjacent cell the...

3 replies Last reply on 17 Mar 2015 by
MaxStart

Convert date into words(english) in excel 2003, 2007 or 2010

 Solved

Hello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twenty Second April T...

1 reply Last reply on 17 Mar 2015 by
MaxStart

Conditional formating is applied based on date in two cells

 Solved

Hi everyone I'm using Excel 2010 and applying conditional formating on dates in Column E. I don't want the formatting to be applied if there is the f...

6 replies Last reply on 16 Mar 2015 by
TrowaD

Excel - help please! drop down and data filling

 Solved

Good morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one that li...

4 replies Last reply on 13 Mar 2015 by
CatherineGPR

Trying to have the current date go into one cell (a1)

 Solved

Hello, I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to aut...

3 replies Last reply on 12 Mar 2015 by
dbmich

A strange range question ...

 Solved

Hi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...

8 replies Last reply on 11 Mar 2015 by
BrianGreen

Adding a loop to macro to insert pictures

 Solved

Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...

7 replies Last reply on 5 Mar 2015 by
M_TheJax

Change calculated to a hard date

 Solved

I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...

2 replies Last reply on 3 Mar 2015 by
Ritabook

Recovering missing emails by restoring outlook identity from tim

 Solved

had a problem with Outlook 2011 client - emails went missing and not in deleted / purged folders if i restore outlook identity from a date i know h...

2 replies Last reply on 3 Mar 2015 by
howardbridger

Problem recovering deleted item in outlook 2010

 Solved

I try to open deleted item recovery in Outlook 2010 and attempts to recover any message and receives the following error message: "Outlook was unable ...

2 replies Last reply on 2 Mar 2015 by
prueferlas

Opening ost files with outlook 2013

 Solved/Closed

How can one open existing ost files in Outlook 2013? I tried but I get a message that it is not an Outlook Data file.

Last reply on 2 Mar 2015 by
jackdavids

Winxp outlook express lost inbox

 Solved

I STILL HAVE ALL MY SENT ITEMS BUT ONLY SOME ITEMS FROM 2006 LEFT IN MY INBOX' PLEASE HELP.

1 reply Last reply on 2 Mar 2015 by
RobertKenn

Transferring numbers to new worksheet automatically

 Solved

Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...

2 replies Last reply on 28 Feb 2015 by
tresi

Macro to create tabs and populate from other worksheets

 Solved

I already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...

4 replies Last reply on 26 Feb 2015 by
Nickname

How to transfer lines of txt from one sheet to another sheet?

 Solved

Hello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...

6 replies Last reply on 24 Feb 2015 by
Mike

Computer show me the error message. (.pst file)

 Solved

Hello, After restore the .pst file back to hard disk, the computer show me the error message. How can i repair this file? Please help Best regards....

2 replies Last reply on 23 Feb 2015 by
Schreurs

How to restore the telephone book from the wab file?

 Solved

How to restore the telephone book from the wab file? There is a file .wab, by the file size can be seen that the contacts are there but when opening ...

1 reply Last reply on 23 Feb 2015 by
kristopher1

Outlook express 6.0 losing contacts/error msgs. opening and send

 Solved

During the last six weeks or so, whenever I install "updates" for my computer (Windows XP), my Outlook Express loses all my contacts, as well as becom...

1 reply Last reply on 22 Feb 2015 by
robertadams
Results 901 - 950 out of a total of 2,608