## The discussions

### Cell colour containing specific info

Solved

Hi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a differ...

6 replies Last reply on 23 Jun 2017 by
JohannGC

### Validate copied data in excel

Solved

Hi, I have a below scenario one row is copied and pasted, this pasted row needs data validation such that total of each cell shouldn't exceed the r...

2 replies Last reply on 22 Jun 2017 by
chint99

### Multiple worksheet data input

Solved

hi TrowaD, I am an on the job trainee at a company, i was ask to encode data from our furnace but its too much time consuming for me to encode all...

2 replies Last reply on 20 Jun 2017 by
vintacu

### Conditional format based on text in same row

Solved

Hi all, New to this forum. I'm running Excel 2016 on Win7 -- my spreadsheet has results of inspections in columns E, G, and J. The possible valu...

3 replies Last reply on 20 Jun 2017 by
Mazzaropi

### How to manage hours and rounding in excel

Solved

Hello, I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E...

2 replies Last reply on 19 Jun 2017 by
Theresa

### Removing " false" value in "if"

Solved

Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C11="Evening",200,IF(C11="Gaze...

10 replies Last reply on 19 Jun 2017 by
share

### Formula

Solved

I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...

7 replies Last reply on 15 Jun 2017 by
x

### Convert date of birth in word

Solved

Hello, pls tell me formula for convert date of birth in word in excel

Ambucias

### Comparing values of two excel sheets

Solved

Hello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...

2 replies Last reply on 10 Jun 2017 by
dh

### Copy/paste a range 'n' times.

Solved

Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...

3 replies Last reply on 9 Jun 2017 by
vcoolio

### Conditional format

Solved

Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell \$AI2 has

3 replies Last reply on 6 Jun 2017 by
Azion

### Vlook up

Solved

Hello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help

2 replies Last reply on 6 Jun 2017 by
Sri

Solved

How do I view hidden formulas on spreadsheet

3 replies Last reply on 29 May 2017 by

### Vba send email via outlook using loop; no response when run

Solved

Hello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the r...

9 replies Last reply on 29 May 2017 by

### Vba code in my command button doesn't work

Solved

Hello, I have a sample table below, I was trying different VBA code in my command button but doesn't work well. Column G is already programmed t...

vcoolio

### Vba column

Solved/Closed

Need to know how to added data in column field if column is not empty then go to another column and paste data

Last reply on 28 May 2017 by
Ambucias

### Format font colour to change

Solved

Hello, Using Excel, I have a range of cells K2-K15 that contain numeric values and I want the font color to change in any of those cells that are g...

2 replies Last reply on 26 May 2017 by
jandc111

### Copy rows to new sheets if condition is met

Solved

Hello , please help... I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The colum...

7 replies Last reply on 24 May 2017 by
vcoolio

### How to "teach" excel to learn names?

Solved

Greetings to all, I'm desperate to find a solution to my tedious work. So, each day i will go through hundreds of records and change product names...

2 replies Last reply on 23 May 2017 by
HoomanCz

### Search for a value in column and copy to different sheet

Solved

Hi I want to search for an employee ID in column EID and copy the whole record into another worksheet within the same workbook if the EID is found...

3 replies Last reply on 23 May 2017 by
raghuprabhu

### If then using multiple cells and words

Solved

Hello, D3,D4,D5 that all need to say either 'Compliant' or 'N/A', for result in E3 to say "yes", else "No". Please help. System Configurati...

4 replies Last reply on 22 May 2017 by
Matt Louisiana

### Need help with conditional formatting

Solved

Good morning, I am trying to change the color of a cell(A) if another cell (D) contains text. The text will contain both a date and other text. Can...

8 replies Last reply on 22 May 2017 by
x

### How to copy data from sheet1 to sheet2

Solved

Hello, I have a worksheet, there are 2 sheets. What I need is to do is copy all the column and rows from sheet1 and paste it to sheet2. The copy butt...

10 replies Last reply on 19 May 2017 by
nisa

### Excel formula for percentage

Solved/Closed

Hello, I am trying to get a formula to calculate the percentage of cell O3 from cell N2. The format is what percentage is my expense (O3) from my ...

Last reply on 16 May 2017 by
tanu

### A macro to create new, copy and name worksheets based on a list

Solved

Greetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list that ...

35 replies Last reply on 11 May 2017 by
vcoolio

### Need help creating an if then scenario

Solved

Hello, I am looking for some help with a problem. I have a big list of items within Excel and I am wanting to consolidate the big list of items do...

12 replies Last reply on 10 May 2017 by
vcoolio

### A macro to copy/paste a cell and other cells in the same row

Solved

I have two wooksheets in a workbook. I need that a value of each cell in a range C3:C52 in sheet 2002 is being searched for in the range B2:B101 of th...

3 replies Last reply on 9 May 2017 by

### Trying to simplify data in excel through vbscript

Solved

Please help desperate novice: In Excel, I have 5 columns: Bob Dad 12 13 blank Sue Mum 34 56 22 Gill Daughter 23 67 34 Jock Son 24 55 blank ...

3 replies Last reply on 8 May 2017 by

### How do i use conditional formatting in excel

Solved

Hello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...

3 replies Last reply on 6 May 2017 by
Mazzaropi

### Excel vba - find and expand matching cell entries

Solved

Hello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...

x

### How to populate information on multiple sheets at once

Solved

Hi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...

14 replies Last reply on 2 May 2017 by

### Outlook 2007 is not sending mails

Solved/Closed

Hello, Have a nice day. I migrate my data from one PC to another. The old one was having Windows XP operating system along with Outlook 2003 w...

Last reply on 2 May 2017 by
danigirl

### Shortcut to edit a cell without using f2 key

Solved

Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...

7 replies Last reply on 25 Apr 2017 by
BenFromSingapore

### Data in a hot key

Solved

Hello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.

4 replies Last reply on 25 Apr 2017 by

Solved

Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...

12 replies Last reply on 24 Apr 2017 by
ac3mark

### Compare the words in 2 columns in excel

Solved

I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...

11 replies Last reply on 24 Apr 2017 by

### Excel forum within a range

Solved

Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...

2 replies Last reply on 24 Apr 2017 by
Gerberreinette

### Convert wordpad document back to pdf

Solved

Hello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done beca...

10 replies Last reply on 21 Apr 2017 by
ac3mark

### Need to delete columns based on column header

Solved

Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...

7 replies Last reply on 21 Apr 2017 by
topazfae

### Auto generation of code

Solved/Closed

Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...

Last reply on 20 Apr 2017 by

### Excel - a macro to create new workbook and copy data

Solved/Closed

In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...

Last reply on 18 Apr 2017 by

### Excel - macro to create multiple sheets

Solved

Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...

5 replies Last reply on 14 Apr 2017 by
vcoolio

### Comparing columns and returning value

Solved/Closed

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...

Last reply on 14 Apr 2017 by
kittu

### Import .pdf ...?

Solved

Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...

2 replies Last reply on 12 Apr 2017 by
RickRoll

### Formula

Solved

I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...

2 replies Last reply on 6 Apr 2017 by
ehmetcalf

### Conditional formatting based on two cell values

Solved

Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

### Copying cond. format for entire row based on 1 cell to other row

Solved

I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>\$A\$2 = red, cell value

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

### Drop down lists

Solved

Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...

3 replies Last reply on 31 Mar 2017 by
Mazzaropi

### Removing false value

Solved

Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...

5 replies Last reply on 30 Mar 2017 by
ac3mark

### Copy rows to other sheets based on value in column

Solved

All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...

6 replies Last reply on 30 Mar 2017 by
vcoolio
Results 401 - 450 out of a total of 2,608