## The discussions

### Formula if you have credit in one column, debit in next column

Solved

Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...

4 replies Last reply on 13 Jan 2016 by

### How to re/name a cell if another cell contains x

Solved

Hello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...

5 replies Last reply on 8 Jan 2016 by
vcoolio

### Strike through when entering date

Solved

Hello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...

3 replies Last reply on 2 Jan 2016 by
vcoolio

### Place new code to working code

Solved

Hello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...

2 replies Last reply on 1 Jan 2016 by
smuneeb

### How to apply conditional formatting in excel

Solved/Closed

Hello, I need to apply conditional formatting to range H1:H10000 based on corresponding values in another column, G1:G10000. If the value in t...

Last reply on 30 Dec 2016 by
amazed

### Excel question, if cell contains certain word

Solved

Hello, I have a excel spreadsheet that has a bunch of companys with full addresses, phone numbers, etc. They are all in column A. I want the inf...

5 replies Last reply on 29 Dec 2016 by
Kym

### Hello, where am i going wrong with this formula?

Solved

=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...

6 replies Last reply on 22 Dec 2015 by
j1969c

### I want to build intelligent excel

Solved

Task is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell,...

7 replies Last reply on 21 Dec 2015 by
nullun

### Extracting multiple date from master sheet to new sheets

Solved

Hi I run a sports tipping site and I want to extract data from my master sheet to make other sheets. I.e in sports cloumn I have multiple sports and w...

32 replies Last reply on 21 Dec 2015 by
alan180

Solved

Hello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches ...

6 replies Last reply on 20 Dec 2015 by
JoeyM

### Excel 2013 has stopped working

Solved

Hello, Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked ...

2 replies Last reply on 20 Dec 2015 by
kudret_hayrettin

### Find data and copy dynamic range

Solved

Hello all, I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the sample...

4 replies Last reply on 16 Dec 2015 by
Poojapriya

### Resize the range

Solved

Greetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while usin...

3 replies Last reply on 16 Dec 2015 by
Poojapriya

### Using the if function for dates

Solved

Hello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...

RayH

### Outlook can receive mail but can't send mail

Solved

Hello, I have a friend who is suddenly unable to send emails. But he Can receive, however. Error Message is "unknown error" Ox800CCC13 windows 10 ...

3 replies Last reply on 12 Dec 2015 by
Ambucias

### Help writing a if formula

Solved

Hello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works IF(A2=''receive'',1,2);...

ac3mark

### Help with a formula

Solved

Please help !! Looking to calculate totals based on the following... Entering the formula in the following field K4 I have rows (B4 thru B18) e...

2 replies Last reply on 8 Dec 2015 by
hockeymom

### Formula to add 1 with if statement

Solved

Hi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...

2 replies Last reply on 8 Dec 2015 by
edmaclod

Solved

please can somebody help me. after installing cyber cafe pro 5 for just 4 machines, I completely forgot the admin username and so I decided to unins...

3 replies Last reply on 5 Dec 2015 by
Unknown

### How to remove mark up area in microsoft word 2007

Solved/Closed

Hello, How to remove mark up area in word file Configuration: Windows 7 / Firefox 29.0

Last reply on 5 Dec 2015 by
Asrar

### Not pasting values in excel file

Solved

Hello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no merging...

2 replies Last reply on 5 Dec 2015 by
smuneeb

### Coping formulas to next row using a macro

Solved

Hello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. I...

6 replies Last reply on 4 Dec 2015 by

### Add a restriction to a column

Solved

Hello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should st...

rizvisa1

### Conditional formatting through macro

Solved

Hello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...

9 replies Last reply on 3 Dec 2015 by
vcoolio

### Sum values from one column if another column equals x

Solved

Hello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...

3 replies Last reply on 2 Dec 2015 by
vcoolio

### Transfer worksheet

Solved

Hello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...

3 replies Last reply on 1 Dec 2015 by
Gili

### Excel formula

Solved

Hello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks

3 replies Last reply on 25 Nov 2015 by
vcoolio

### Scroll mouse in listbox

Solved

Hello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...

2 replies Last reply on 25 Nov 2015 by
smuneeb

### Copy a 'template' sheet onto multiple other sheets

Solved

Hello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...

rizvisa1

Solved

Hello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...

5 replies Last reply on 24 Nov 2015 by
smuneeb

### Conditional formatting on multiple criteria

Solved

hi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...

5 replies Last reply on 23 Nov 2015 by

### Comparing columns in excel 2010

Solved

Hello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...

2 replies Last reply on 22 Nov 2015 by
laulou95

### Set rows height also exception in range

Solved

Hello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...

5 replies Last reply on 21 Nov 2015 by
smuneeb

Solved

One of my users is having a strange issue. When she tries to open a PDF file from within Internet Explorer 8 using Adobe Acrobat Reader X (latest ver...

BashirYazbik

### Comparing rows on two worksheets and pull data into a new sheet

Solved

My requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...

2 replies Last reply on 20 Nov 2015 by
manny

### Remove (shape) straight line

Solved

Hello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...

3 replies Last reply on 19 Nov 2015 by
smuneeb

### Home button

Solved

Hello, I would like to request for the Macro which always take to "Sheet1" and also deactivated at "Sheet1" Thanks & Regards Configuration: ...

rayh

### Next and previous button and de-activate at last sheet

Solved

Hello, I would like to request to create a button on Sheet that will click which goes to next sheet and this button also de-activate when it g...

2 replies Last reply on 18 Nov 2015 by
smuneeb

### A macro to create new spreadsheet and copy data

Solved/Closed

Hello, I m a University student and currently learning VBA programming. I have a VBA coursework where i have a file with 63 sheets. is any macro w...

Last reply on 15 Nov 2015 by
Ambucias

### Showing the \$ value difference

Solved

Hello, I am using Excel 2016.. and need some help. I am doing a budgeting sheet and cant figure out how to do the following; Column A - Budget \$ ...

2 replies Last reply on 13 Nov 2015 by
KirstyLee

### Tell excel where to look

Solved

Hello, I am trying to make a cell return a word when you tell it which cell to look in for that word. If i type J2 in a box i want a cell to then l...

5 replies Last reply on 13 Nov 2015 by
Mase

### Excel: if date =, then enter a value

Solved

I am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--") How do I now create a string to check a number of dates (company holid...

4 replies Last reply on 13 Nov 2015 by
BrianGreen

Solved

Hello, I seem to be having a problem with a nested IF(statement) I am on a separate worksheet that I use to calculate my formulas for my summary page....

8 replies Last reply on 13 Nov 2015 by
dkayeh1

### Drawback of copy and clear code

Solved

Hello, I have requested that please solve this issued if it could be solved. I have found major drawback (May be I am wrong) in the code of Copy ...

2 replies Last reply on 12 Nov 2015 by
smuneeb

### How to extract target value from other cell

Solved

Hello, I would like to request that Suppose this line of code is working for Column B MsgBox "You entered is Invalid" this will show the m...

2 replies Last reply on 10 Nov 2015 by
smuneeb

### Excel is automatically changing dates to a numeric code

Solved

Hello, I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlightin...

2 replies Last reply on 10 Nov 2015 by
mamagiglio

### Protecting your formulas in multiple worksheets

Solved

Hello everyone, thank you in advance for any help I receive with is question. I have multiple worksheets in a workbook that have formulas in them b...

5 replies Last reply on 9 Nov 2015 by
rizvisa1

### Fix the code

Solved

Hello, Its being requested please fix the code given below the problem in this code is that any one of the given condition execute and once ...

3 replies Last reply on 9 Nov 2015 by
rizvisa1

### Date format changes when editing it

Solved

Hi, I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems. However, as soon as I begin to edit a date, it changes to...

5 replies Last reply on 9 Nov 2015 by
rizvisa1

### Copying entries from multiple sheets to new sheet, then summing

Solved

I run a weekly pub trivia and I use a spreadsheet to keep track of cumulative scores. There are 6 sheets in the file... Week 1 Week 2 Week 3 W...

2 replies Last reply on 9 Nov 2015 by
nahidule
Results 701 - 750 out of a total of 2,608