The discussions

Conditional formatting on an entire row

 Solved

Hello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12

4 replies Last reply on 4 Mar 2016 by
AKA

My email have been deleting without reading

 Solved

Hello, I keep getting emails saying that some emails have been deleted without being read. The message below is typical of what I am seeing is: ...

8 replies Last reply on 4 Mar 2016 by
raja

Issue with date and text in if formula

 Closed

Hello, I'm trying to write a function for a cell which refers to different descriptions in one column - where it only should combine some descript...

1 reply Last reply on 4 Mar 2016 by
Computertech

Receiving an error message for vba

Hello, I was given a workbook to fix with 5 different sheets. The Summary sheet has a button to "Refresh Equipment List" which is supposed to ...

1 reply Last reply on 3 Mar 2016 by
ac3mark

Error message - pdf wasn't decoded

Hello, when i try to send pdf as attachment in email - when the receipt opens the mail he gets an error that pdf was not decoded. i am sending th...

1 reply Last reply on 3 Mar 2016 by
Ambucias

Where is the downloaded software?

Just downloaded Publisher, but can't find it.

1 reply Last reply on 3 Mar 2016 by
xpcman

How to sum row color

Hello, Please help us with how to sum numbers marked in different colors. Configuration: Windows 7 / Chrome 48.0.2564.116

1 reply Last reply on 3 Mar 2016 by
TrowaD

Simple way in excel to copy data

Greetings, Can anyone help me. I am working on a huge project and looking for a simple way in Excel to copy data. If I have a master document w...

3 replies Last reply on 3 Mar 2016 by
TrowaD

Copy rows from sheet 1 to sheet 2 if rule is met

 Solved

Hi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...

2 replies Last reply on 3 Mar 2016 by
sierranz

Vsb error autogenerate worksheet from list

Hello, So I have an excel that has mutiple worksheets "2016 Census" "Tracker Template" What I did was use a code to automatically pull data f...

2 replies Last reply on 3 Mar 2016 by
vcoolio

How do io open 2 different excel sheets simultaneously

Hello, How do I open 2 different excel sheets simultaneously. Thanks

1 reply Last reply on 3 Mar 2016 by
vcoolio

Adding a value to a cell that contains text

Hello, Can someone please help me? I want my cell to have the word FREE written in it BUT I also want that cell to represent 0.00$ when I add it to ...

1 reply Last reply on 2 Mar 2016 by
ac3mark

Compare two spreadsheets to return a single value

 Closed

Hello, I'm comparing two spreadsheets and I want to see if items appears on both spreadsheets. I've tried index match but I none of my columns hav...

1 reply Last reply on 1 Mar 2016 by
Computertech

Only partial return of search for copy and paste rows

Hello, I have a workbook with multiple worksheets with same format that has data in A4:K15 that I would like to search by any field and have the r...

4 replies Last reply on 1 Mar 2016 by
smcgrath171

Activate cells after data entry @a1 or cell 1

Hello Guys, Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input cha...

1 reply Last reply on 1 Mar 2016 by
TrowaD

Vba macro help

 Closed

So i have multiple sheets with data and i was wondering if a Macro could be written to pick up values from one excel file and color the cell in anothe...

1 reply Last reply on 29 Feb 2016 by
Computertech

Outlook repair tool for .pst files

 Solved/Closed

Hello everyone, I'm not really sure what happened, but this morning, one of my pst-files was missing and for another I got the error: "Errors have ...

3 replies Last reply on 29 Feb 2016 by
ankitsajwan90

Damaged .pst file, how to repair???

 Closed

Hi everyone, Does anyone know the best way of repairing a 0.5GB .pst file? I had tried the normal ways through outlook and was just wondering if anyb...

2 replies Last reply on 29 Feb 2016 by
ankitsajwan90

If a cell a contains x then display cell b value

 Closed

Hello, How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column blank or ...

1 reply Last reply on 29 Feb 2016 by
Computertech

Use date to return value of 1

Hi, can anyone tell me how to use the entry of a date field to return a value of 1 in Excel? I need to tabulate items where a date is the entered reco...

1 reply Last reply on 27 Feb 2016 by
RayH

Formula

 Solved

Hi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity nd...

1 reply Last reply on 26 Feb 2016 by
RayH

How to convert date of birth in word

Dear Sir, With reference to the above mentioned subject, I want the solution in excel for change the date of birth in words. For Example :- if I wi...

2 replies Last reply on 26 Feb 2016 by
vcoolio

2 rows into one in excel

 Closed

Hello, I would like to sort 2 rows of excel into one A B 2 4 5 6 To C 2 4 5 6

1 reply Last reply on 26 Feb 2016 by
Computertech

Need cell value copy to defferent -2 work sheets within a excel

 Solved

Hello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel...

3 replies Last reply on 25 Feb 2016 by
BrianGreen

Excel / comparing data

Hello, my name is Malwina. I would very much appreciate your help, please. I was trying to compare the spreadsheets but really have no idea ho...

1 reply Last reply on 25 Feb 2016 by
TrowaD

Transfer data from an old report to a new one

Good evening everyone. I'm trying to develop a macro that will compare data between two versions of the same report. The old file, contains a list o...

2 replies Last reply on 25 Feb 2016 by
thanpanag

Identify value "o/b", if true search column for "/"

Hello, Im trying to make a break list to be active on a daily basis in a workplace, currently it works immacutely but i have hit a speedbump in co...

1 reply Last reply on 25 Feb 2016 by
TrowaD

Pdf attached to email won't open

Hello, When I receive email with a PDF attachment, they do not have Adobe icon but do have the .pdf extension. If I try to open it, the Windows Medi...

1 reply Last reply on 25 Feb 2016 by
ctree42

Excel function to check neighbour cells match for all

 Solved

Hi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is mes...

3 replies Last reply on 25 Feb 2016 by
Dan slow

How to map 2 different columns in from 2 different excel files?

Dear All, I am trying to Map values from 2 different columns from 2 different excel files. I am unsure as how to invoke the sheets and print the re...

1 reply Last reply on 25 Feb 2016 by
anjanasundaram

Multiple if functions

Hello, I am trying to built a multiple If condition. I want excel to search for 2 words in an array "Lose" and "Tie". If it finds "Lose" then i want r...

1 reply Last reply on 24 Feb 2016 by
RayH

A1 draws amount from other cells by live date.

I'm stumped. I need the value in cell A1 to change automatically the first of each month. Column A2:A13 has dates for the first day of Jan through D...

2 replies Last reply on 23 Feb 2016 by
RayH

Sum of the total times a column has a certain text

Hello, I am trying to find the total amount of times that a certain text appears in a column. From A2:A689 I am trying to find the amount of times...

1 reply Last reply on 23 Feb 2016 by
TrowaD

To change cell value automatically

 Solved

Hello everyone here, this is my first question in this forum. In Excel 2013, If I type 1 in cell A1, then it should automatically change as Apple in s...

9 replies Last reply on 22 Feb 2016 by
Dhanuj

Help with if statement / vlookup (i think)

 Solved/Closed

I work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decisi...

1 reply Last reply on 22 Feb 2016 by
ac3mark

Help w/if statement

 Solved

Hello, Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return th...

2 replies Last reply on 22 Feb 2016 by
Ann

Multiple options for if in a drop down menu

hello, i trying to make a drop down list in which u can select food and it has a price so in the drop down list there is a3,a4 AND a5(in the drop do...

3 replies Last reply on 21 Feb 2016 by
RayH

Searching for a specific values on multiple sheets using macro

Hello, I have multiple different sheets, for example I have 4 sheets now. first sheet,second sheet, third sheet, forth sheet. each sheet has 5 ...

1 reply Last reply on 20 Feb 2016 by
Fajr123

Ms office 2010 publisher download

Your link http://ccm.net/download/download-1620-microsoft-office-publisher indicates the download is in English, however when I download it, it's Fren...

1 reply Last reply on 20 Feb 2016 by
BrianGreen

Frequent missing emails inbox (blank)

 Solved

Hello, Please assist me , why my email in my inbox goes missing, this is my 5th time it happen again. Once my inbox emails goes blank, I need to s...

7 replies Last reply on 20 Feb 2016 by
Ambucias

Macro help

 Solved

Greetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one sh...

2 replies Last reply on 19 Feb 2016 by
futurepsych92

The perpetual question: auto-populating sheets based on criteria

Hello, I realize this question has been asked in a million iterations, but my understanding of programming is so nonexistent that I can't confiden...

5 replies Last reply on 19 Feb 2016 by
vcoolio

Vba single click to get current date

 Solved

Hello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...

10 replies Last reply on 19 Feb 2016 by
sroche317

Macro to create, name and fill new sheets based data set

Sorry, I realize this question gets asked all the time. What I'm looking for seems different enough that I will need some specific help. The post righ...

1 reply Last reply on 19 Feb 2016 by
vcoolio

Moving view, not moving selection

Hi there :-) Is there a way to keep the selection, e.g. multiple cells, but move the view to the top of the sheet? Of course another way than scrol...

1 reply Last reply on 18 Feb 2016 by
TrowaD

How do i get a value in a cell based on another cell

Hi, How can I get excel to fill in some information for me? I want the value in column A to be filled in based on the value in either column B ...

1 reply Last reply on 18 Feb 2016 by
TrowaD

How to compare two excel sheets with varying data

 Solved

Hello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...

15 replies Last reply on 18 Feb 2016 by
TrowaD

I need to copy the hyper link as well as the text in the followi

 Closed

I am new to VBA, This code looks in one sheet and pastes it in a new sheet, but does not copy Hyper link, can this be done. Range(wsO.Cells(1, 1...

1 reply Last reply on 18 Feb 2016 by
Computertech

How to return to only one line for each mail

Every mail in outlook comes with 2 lines. to open mail I click oj the second (the one with closed envelope). To delete this mail I need to click twice...

1 reply Last reply on 17 Feb 2016 by
Ambucias

Ranking sorting problem

Hello I would appreciate some help on the following formula problem. I have a game where some teams have wins, losses and draws. My problem arises wh...

4 replies Last reply on 16 Feb 2016 by
whatsit
Results 2301 - 2350 out of a total of 12,258