The discussions

Want to know how to convert date into words(english) in excel

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

1 reply Last reply on 29 Apr 2016 by
xpcman

Excel doubt - if formula

 Solved

Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...

3 replies Last reply on 29 Apr 2016 by
Joao Brito

Conditional formatting

Hello, Want to apply conditional formatting for specific text but not able to do so. Below is the case:- I have two texts - 1. "N" & 2. "NA"...

1 reply Last reply on 29 Apr 2016 by
Mazzaropi

Add worksheets to excel workbook using count defined name

 Solved

Hello, I need to add worksheets based on a count which I defined as ADDTABS located in cell B4 on a worksheet called QRY-CMW. The worksheets ne...

2 replies Last reply on 27 Apr 2016 by
raungst98

Sum of returned lookup values in a text cell

I'm using the lookup formula below to search user comments in cell B1 to find individual words listed in column C, and return the adjacent number valu...

1 reply Last reply on 25 Apr 2016 by
BaCkToHaCk

Publisher?

 Solved

Hi, just joined looking for Publisher, which I thought I had found. The only problem is it ask for a key code and it is all in French. Advice please?

3 replies Last reply on 25 Apr 2016 by
TrowaD

Find and replace with condition

Hello, I would like to ask that in the Range D11 to D510 of all sheets in workbook find "." and replace with ". " If in the above mention range "...

3 replies Last reply on 25 Apr 2016 by
TrowaD

Using if with a fixed date

Hello, im trying to use a if statement in excel with a fixed date =if(A2="Active",E2=Date(2016,03,31),"Closed") but it returns a 1900/01/00 date p...

1 reply Last reply on 25 Apr 2016 by
Mazzaropi

Excel vba/macro

Hello, Need help in creating a Macro to do the following I have a set of formulas on a worksheet called “Adam”. Cell A2 of worksheet “Adam”...

1 reply Last reply on 23 Apr 2016 by
vcoolio

Pdf e-mail attchmnts open to word by default

 Solved

Hello, When I receive an e-mail with a pdf attachment it opens as a word encoded document (e.g. garbage). I need to change the default settings f...

14 replies Last reply on 22 Apr 2016 by
PC

Text format to date/month/year on excel

 Solved

Hello, I have a huge list of data that has multiple dates/year along with different time format. I want to delete the time and obtain only the d...

20 replies Last reply on 22 Apr 2016 by
ExcelNewbie

I want to retrieve value from multiple sheets of same workbook

 Solved

Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...

9 replies Last reply on 22 Apr 2016 by
Mikkelo

Excel formula using 3 tabs

Hello, Can someone please advise if there is a formula or a macro that I can use for an excel spreadsheet. The first sheet tab consist of the ...

1 reply Last reply on 22 Apr 2016 by
davyom

Copy range data in a column to new column.

 Solved

Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...

6 replies Last reply on 21 Apr 2016 by
anthonyishere

Counting between dates

Hello, I want to count the response to applications made to different organisations between set dates. In column C i use a simple 1 or 0 to indic...

3 replies Last reply on 21 Apr 2016 by
Zohaib R

Word processing software

My computers have always come with word processing software already installed. I purchased one recently and it looks like there is none installed. I...

2 replies Last reply on 21 Apr 2016 by
Marlay53

What does this macro code mean?

Hey, The below macro was posted by another user, aquarelle, and is very useful for inserting copies of rows in an excel sheet. I tried asking them ...

4 replies Last reply on 21 Apr 2016 by
nbe9

Compare fields

Hello, My name is Swapnil Veer. I have two sheets in excel. I have to compare two different columns in sheets and add respective entry in front of...

1 reply Last reply on 21 Apr 2016 by
Mazzaropi

Compare two columns

 Solved

Hello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...

2 replies Last reply on 21 Apr 2016 by
kumar

Counting number of times a value appears if..

 Solved

Hello, I conducted a survey in which some questions allowed more than one response. Using Excel - I'm trying to count the number of times a cert...

7 replies Last reply on 21 Apr 2016 by
sambr22

Pdf converter

Hi Greetings I need the PDF converter from any kind of file like word, Excel etc

1 reply Last reply on 21 Apr 2016 by
Zohaib R

Transfer an entire row from one sheet to another

 Solved

Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...

5 replies Last reply on 20 Apr 2016 by
vcoolio

Auto fill a macro

Hello, I want to auto fill a macro button down column A, that copies the information from several cells to a different sheet in the work book. here ...

5 replies Last reply on 20 Apr 2016 by
vcoolio

Conditional formatting, graded color scale

 Closed

Hello, I use graded color scale from green to red to color cells based on value Example: Value (color) 1 (green) 10 (yellow) 20 (red) If m...

1 reply Last reply on 20 Apr 2016 by
Computertech

Barcode scan

Hello everyone, I would really appreciate if someone could help me out.. I'm a small reseller but now I have over 600 items. I use the same barc...

1 reply Last reply on 20 Apr 2016 by
vcoolio

Add to excel macros

 Solved/Closed

Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...

6 replies Last reply on 20 Apr 2016 by
vcoolio

Formula for fetch data from another sheet

Hello, First I would like to asked that how could I insert a excel file or create a link, to understand my query. because the query that I want t...

2 replies Last reply on 19 Apr 2016 by
smuneeb

Formula to copy data based on the text in the cell

Hello, I need to find out how to do this (and would be grateful if anyone could help me with this): I have a tab (1) in Excel with ten thousand...

3 replies Last reply on 19 Apr 2016 by
Mazzaropi

Ms office activation key

 Closed

Please I need an activation key for Micro Soft Office 2010 and 2013. Please help.

1 reply Last reply on 19 Apr 2016 by
Ambucias

Formula to check days of the month and display only weekdays

Hello, Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and...

1 reply Last reply on 18 Apr 2016 by
TrowaD

Multiple sheet, find, copy specific cell and paste

Hello, i have a challenge for you. Im working on a doccument to pull information from a different sheet, that was imported from a web based huma...

1 reply Last reply on 18 Apr 2016 by
TrowaD

Protected worksheet

 Solved

Hello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...

2 replies Last reply on 18 Apr 2016 by
whatsit

Inserting image files from a directory specified by text string

G’day CCM forum Quick hypothetical; I have a list of image file names in a column on an excel spreadsheet and a cell at the top of the page contain...

16 replies Last reply on 18 Apr 2016 by
MattRNR

Copy row only if one cell's value is not 0

 Solved

I would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!

3 replies Last reply on 18 Apr 2016 by
vcoolio

F2+enter key for macro

Hi I would like to request for a Macro that which execute a F2 and Enter keys. Please don't make a selection for a cells. I have a sheet where ...

2 replies Last reply on 17 Apr 2016 by
smuneeb

Microsoft office adding publisher

I purchased the 365 days of Microsoft Office along with my new computer in December and it didn't include Publisher. How can I add that?

1 reply Last reply on 15 Apr 2016 by
ac3mark

Help with simple 2 step macro?

Hello, I ask help to write a macro that 1. searches for 1 name "(Nghiem, Emily)" 2. and then types "X" in the next cell to the right. (What I tr...

1 reply Last reply on 15 Apr 2016 by
ac3mark

Multiple if to show different statuses

Hello, I am trying to have different status in my reports depending on the dates in different cells H START I ACTUAL START J DUE K DATE COMPLETED...

1 reply Last reply on 15 Apr 2016 by
JasmineJasmineVV

How to get a macro to work in all worksheets

I know I am missing something simple here. I made a macro to create a chart from a template based on two ranges in a worksheet (Brisbane April Sales ...

3 replies Last reply on 14 Apr 2016 by
Robbo166

Ibm lotus symphony

Sir, I tried severel times to download ibm lotus symphony but failed. please help. With regards Mantu

1 reply Last reply on 14 Apr 2016 by
Ambucias

A variation on the compare 2 columns in excel

 Solved

Guys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...

2 replies Last reply on 13 Apr 2016 by
BrianGreen

Search for a word in a worksheet and return row

Hi, Hoping to get some help. I have a spreadsheet full of data in Sheet 1 from A1:AG159382. I would like to use a separate worksheet to search for...

3 replies Last reply on 13 Apr 2016 by
vcoolio

If then formula

Hello, I am trying to build an If Then formula. I am trying to reference a cell with a specific text in one cell like A2=Light and only if Lights is ...

3 replies Last reply on 13 Apr 2016 by
vcoolio

How to change word in cell using another word in another cell

 Solved

Hello, I have 2 qns 1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the o...

10 replies Last reply on 13 Apr 2016 by
Cherietan

Copying macro

I want to write a macro where it groups my data by group # and copy the data of each group # into different sheets. Afterward, rename each sheets t...

5 replies Last reply on 12 Apr 2016 by
group123

Outlook 2010 configuration for mail.com

 Solved

Hello, I am not able to configure outlook 2010 for mail.com. OS- window 7 64 bit Could you please provide me the server, port details.. Thank y...

11 replies Last reply on 12 Apr 2016 by
Rod B.

If function time

 Solved

Hello, I am trying to make a rota and I need help with a formula. A1 B1 C1 07:00:00 14:30:00 =b1-a1 The person st...

2 replies Last reply on 11 Apr 2016 by
Ashakil

Copying an entire worksheet to another worksheet automatically

Hello, How can I automatically copy all data from one worksheet to another to include charts etc. Basically a copy of another worksheet tab. than...

3 replies Last reply on 9 Apr 2016 by
vcoolio

How to make macro repeat

Hello, I am trying to run a macro where I multiply a range (B3: B615) by a number (B2). The problem is I want to do this for every column in my wo...

1 reply Last reply on 8 Apr 2016 by
ac3mark

Changing font colour in a range based on criteria in another

Hello, I am trying to change the font colour in a range of cell based on conditions i set in another range of cell. How do i go about it, its giv...

1 reply Last reply on 8 Apr 2016 by
ac3mark
Results 2151 - 2200 out of a total of 12,249