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
Jackthelad

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

Specific price depending on the words in 2 cells? please help

 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...

1 reply Last reply on 15 Dec 2015 by
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);...

1 reply Last reply on 10 Dec 2015 by
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

Forgot cyber cafe pro's admin username and password

 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
CADU1947

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...

1 reply Last reply on 3 Dec 2015 by
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 ...

1 reply Last reply on 24 Nov 2015 by
rizvisa1

Add sheets to combobox

 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
TrowaD

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

Adobe reader error 0:104

 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...

1 reply Last reply on 21 Nov 2015 by
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: ...

1 reply Last reply on 18 Nov 2015 by
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

Adding two non-adjacent cells (number and text)

 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