The discussions

For and condition

Hello, ANd condition on two different columns - what is the solution please Configuration: Windows 7 / Chrome 41.0.2272.76

1 reply Last reply on 7 Mar 2015 by
cmarzahn

Copy data to new sheet.. more tricky than i imagined

Hi all, Could someone please help me out with this? I've tried looking at other similar questions and solutions but as an Excel beginner I couldn'...

3 replies Last reply on 7 Mar 2015 by
venkat1926

Compare on a condition and highlight the difference

Hello, I have a requirement to compare two different tabs on same sheet and display the difference either by highlighting the rows or add a comment....

3 replies Last reply on 6 Mar 2015 by
RayH

Excel formula

Hello, I want the answer of this formula =IF(AND(L13

1 reply Last reply on 6 Mar 2015 by
Computertech

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

Color coding variable pivot row label interior

Hello All I have a coding problem I have tried numerous ways to solve with no success. I have a macro generating a pivot table for weekly data tha...

1 reply Last reply on 5 Mar 2015 by
BwanaBill

Excel assistance

Hello, Can i PLEASE get some help with this problem? 5KM or more and less than 15km, the cost will be 5... Thanks to everyone in advance

2 replies Last reply on 4 Mar 2015 by
njiebadou

Transfer 5000 records to a new spreadsheets with 50 records in e

I have a excel file which contains 5000 recores, i want to transfer 5000 records to a new spreadsheets with 50 records in each new spreadsheets i.e to...

1 reply Last reply on 4 Mar 2015 by
venkat1926

How to export data from different tabs in excel

Hi, I need help with a spreadsheet that has 4 tabs. My tabs are: Manager, Analyst_1, Analyst_2 and Analyst_3. I need a formula that can t...

6 replies Last reply on 3 Mar 2015 by
JSharon

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

Vba : copy "pivot like layout" to "data dump layout" data

Hello, I am looking for a solution to my challenge. I have a spreadsheet that looks like this. Name - Column Name 1 - Column Name 2 Column...

1 reply Last reply on 3 Mar 2015 by
TrowaD

Macro creation

I need to combine data in two different Excel worksheets. 1. list with user names and their ids and groups and to input this data to the list with j...

1 reply Last reply on 3 Mar 2015 by
TrowaD

Excel-changing calculated dates to "hard" dates

Hello, I used a simple +1 formula to create dates in column A. Now that I have the dates, I want to make them "hard" dates so they don't change eve...

1 reply Last reply on 3 Mar 2015 by
TrowaD

Changing cell color with either conditional formatting or macro

Excel 2003 or 2007, 3 preferred. I have a column 'E' that contains either 2 or 4 digit text codes (MR, SP, BA SC, EU WO, etc), up to 50 unique codes....

6 replies Last reply on 3 Mar 2015 by
bealerusa

If function with date

Hello, The concept is "If the days exceeds 30, the entire cell should be applied with some color or highlighted". Please respond Configurati...

1 reply Last reply on 3 Mar 2015 by
vcoolio

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

Macro is not working

Hello, The first time the macro worked, I was so happy! (I used it once) Now is not working anymore, no idea why. Can someone help me? I rea...

1 reply Last reply on 2 Mar 2015 by
TrowaD

Filter according to 'typed' value

Hello, I need an autofilter to change according to a 'typed' value on another worksheet. I have found this code, which works when the typed val...

1 reply Last reply on 2 Mar 2015 by
TrowaD

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

All of my picture files are showing up as word doc's

AllHello, This was a previous question that was answered. My problem is the same, but ALL of my pictures are showing up as a word file. Can I fi...

2 replies Last reply on 2 Mar 2015 by
Ambucias

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

Move data from one wrksheet to another using submit button

hello im working on a project and ive create a workbook in which I place data into a worksheet known as "processing" which serves as a main page in w...

2 replies Last reply on 1 Mar 2015 by
vcoolio

Sending email issues

Hello, I can received mail but can't send out mail. Error message Ox800408FC. Could someone please help. I have Outlook2003. Thank you so much! ...

1 reply Last reply on 28 Feb 2015 by
BrianGreen

Changing of number into word

Hello, Can you please help me how to change number into word in Excel 2007 Configuration: Windows 8 / Chrome 40.0.2214.115

1 reply Last reply on 28 Feb 2015 by
xpcman

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

Sending email

Hello, When I try to send email , the email go away but the person don't receive the email, my outlook is version 2007, I tried to figure out what i...

1 reply Last reply on 27 Feb 2015 by
Ambucias

Acrobat always opens in second screen

Hi, I have 2 screens. I don't know why, but Acrobat always opens in my second screen, even if I drop the window in the first screen. It doesn't memor...

1 reply Last reply on 27 Feb 2015 by
xpcman

Notification

Hello, I was wondering if it is possible to create a popup when a user has a shared excel spreadsheet open preventing others from using it. The popup ...

1 reply Last reply on 27 Feb 2015 by
vcoolio

Downloadpdfplayer

Hello, I want download PDFplayer, please Configuration: Windows 7 / Firefox 35.0

1 reply Last reply on 27 Feb 2015 by
Computertech

Convert number into words

how i can convert numircal in words

1 reply Last reply on 27 Feb 2015 by
Computertech

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 change the date of weekends in excel?

Hello, how to change the date of weekends in excel? pls help me.. thanks! Configuration: Windows XP / Internet Explorer 7.0

2 replies Last reply on 26 Feb 2015 by
Joseeb

Macro to complete date form

Hello, I've got a spreadsheet with the Month in the top left "A5:B7" merged cells, the numerical days of the week (only Mon-Fri) on the right "L9:...

6 replies Last reply on 25 Feb 2015 by
cmarzahn

Calculate the number of days in any given year

Hello, I am trying to determine how many days in each year so I can calculate costs based upon the number of days. I have the following columns ...

1 reply Last reply on 25 Feb 2015 by
cmarzahn

How to insert rows in excel, when criteria is met ???

Sir, how to insert rows in excel, when criteria is met ??? Regards

1 reply Last reply on 25 Feb 2015 by
Computertech

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

Vba to auto insert comment (by vlookup list) on cell data entry

I have built an accounting program three columns of which are named Vat Number, Debit, and Credit I need that each time I make an entry into any cel...

10 replies Last reply on 24 Feb 2015 by
TrowaD

Transfer full row based on one column on multiple sheet to one

I am new to this, and never did codes for Excel. But I need help. I have a workbook with 4 tabs: Summary, Project A, Project B, Project C. On Project ...

6 replies Last reply on 23 Feb 2015 by
vcoolio

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

Please help me these extremely difficult exercises

 Closed

Hello, Hello everyone, I have an exercise about if function in excel. Honestly, I did pretty well the previous assignments but this one is much com...

Last reply on 23 Feb 2015 by
Ambucias

Covert numbers to words

Hello, how do we convert numbers into words in excel Configuration: Windows 7 / Chrome 40.0.2214.115

1 reply Last reply on 23 Feb 2015 by
Computertech

Convert numbers into word

How do we convert numbers into words format in excel

1 reply Last reply on 23 Feb 2015 by
Computertech

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

Repair excel files.

 Solved

Hello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained ...

3 replies Last reply on 22 Feb 2015 by
pearsonjoseph301

How to remove image with vb?

 Solved

Hello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using excel...

6 replies Last reply on 20 Feb 2015 by
vcoolio

Code to copy data from one sheet and pasting into specific cells

Hi all, I have two worksheets. Namely 'Worksheet Values' and 'Worksheet Final'. 'Worksheet Values' contains all the data that I want to insert in...

1 reply Last reply on 20 Feb 2015 by
cmarzahn

Conditional formatting based on another cell; apply to rows

 Solved

Hello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg, pending, a...

2 replies Last reply on 20 Feb 2015 by
radiofriendlybox

Moving data from one sheet to another

Hello, I need to move a date if 21 days great than today Configuration: Windows 7 / Internet Explorer 10.0

1 reply Last reply on 20 Feb 2015 by
cmarzahn
Results 3251 - 3300 out of a total of 12,264