The discussions

Set a conditional year end date outcomes

Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31/201...

1 reply Last reply on 7 Jul 2016 by
Mazzaropi

Macro code

Hi there. So I have a question. I want to create a macro that makes uses the list of name in cells B6:B60, E6:E60, B66:B119, and F6:F74 to make a tab ...

1 reply Last reply on 6 Jul 2016 by
ac3mark

Compare two columns input value from another

 Solved

Hello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...

2 replies Last reply on 6 Jul 2016 by
Maureen

Highlight cell if another cell contains any text

 Solved

Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...

4 replies Last reply on 4 Jul 2016 by
LvH

Microsoft outlook microsoft exchange is unavailable

Hello, I could not open Microsoft outlook at all, the error message a following: The connection to Microsoft exchange is unavailable. Outlook mu...

2 replies Last reply on 2 Jul 2016 by
captainashish

Help! my ms word icon has changed

Hi. I hope you can help me. About a week ago my Word doc icons suddenly changed on documents that I created or edited. Once edited or created, they ...

1 reply Last reply on 30 Jun 2016 by
ac3mark

Excel help please

Ok here's what I want to accomplish. I want to be able to type the name of a medication: and the formulations automatically appear in the rows foll...

1 reply Last reply on 30 Jun 2016 by
Mazzaropi

Auto row copy to another worksheet

I'm new to excel and need to set up a simple double entry bookkeeping system in excel. I need to know what formula to put into a cell to accomplish t...

8 replies Last reply on 30 Jun 2016 by
Anon

Assign numerical value to cell based on text in another cell

Hello, I'm trying to solve an issue... Column A cells have a drop down which has 4 text options to choose from: Tier 1 Tier 2 Tier 3 Tier 4 ...

1 reply Last reply on 30 Jun 2016 by
Mazzaropi

Cant figure out a formula

Hello, I need help figuring out a formula that will if two cells values match then the data in selected rows will go to one if that makes sense......

1 reply Last reply on 29 Jun 2016 by
ac3mark

Microsoft outlook app

Hello, I am looking to see how I can stop my outlook app from syncing when on holiday, evenings, weekends etc. I have looked at help online bu...

1 reply Last reply on 29 Jun 2016 by
kieferschild

How to save next data entry in next target range

Hello, I am running a macro using a command button that saves data from A3:AB3 to a7:AB7. however when I change the data from A3:AB3 and click sav...

1 reply Last reply on 29 Jun 2016 by
vcoolio

Create a macro which monitors the cell "c1" to be changed to "a"

Hello, I hope someone can assist with this In my workbook; I have two worksheets labeled "log" and "master" I want to create a macro which monitor...

2 replies Last reply on 28 Jun 2016 by
Fkhan777

Auto add or subtract between two cells

Hello, This is probably a very simple question. I am trying to auto add or subtract between two cells. example: if B1 is greater or less t...

1 reply Last reply on 28 Jun 2016 by
ac3mark

Excel vba: application.filesearch error in running excel 2013

 Solved

Hello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to 2007).Up...

6 replies Last reply on 28 Jun 2016 by
TrowaD

Percentage

Hello, how do I figure out the mark up percentage when I have the cost and sell price. cost Q2 1.14 sell P2 8.04 what's the per...

1 reply Last reply on 27 Jun 2016 by
Mazzaropi

How to stop rows underneath being affected by a filter

Hello, I have a filter set up for a table which works fine and is filtered when a quantity is entered in column D. However under the table is more row...

1 reply Last reply on 27 Jun 2016 by
TrowaD

Simple multiplication gives wrong result

Hello, I am raja, In my excel 2010 when i am trying to multiply two cells of values 743.91 & 0.87 , the result is as given 646.88. But the actual...

1 reply Last reply on 27 Jun 2016 by
TrowaD

Column with dates not sorting/formating

Hello, a column with dates is not sorting nor formatting. I have tried to do the suggested answer on the forum but to no avail. This is driving me cra...

1 reply Last reply on 27 Jun 2016 by
TrowaD

Copy paste special into last row of another worksheet

 Solved

Hello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am ...

3 replies Last reply on 27 Jun 2016 by
TrowaD

How to create student exams record and printout using ms excel

I wish to design student exams records using MS Excel afterward, I should be able to pull records of student using Matric_No and then print out the st...

1 reply Last reply on 27 Jun 2016 by
pervezjan

Letter writing and printing

I downloaded this programme on the understanding it was a free version of Microsoft word but I don't see where to start a letter for printing ??

1 reply Last reply on 25 Jun 2016 by
xpcman

Multiple query in once button in same sheet

Hello all, I have created two separate queries in excel VBA. I have given two different buttons for both queries and both are running successfully...

1 reply Last reply on 25 Jun 2016 by
vcoolio

Transfer names from general sheet to separate other sheets

Hello, So i have 3 separate sheets, the first is a general info sheet with names and other information on it, names are in column A. Each name is ...

1 reply Last reply on 25 Jun 2016 by
vcoolio

Help for creating a macro

Hi all. I'm here to ask for ypur help. I want to create a macro, that opens a dialog box and leting you browse your computer and open a new excel file...

1 reply Last reply on 24 Jun 2016 by
r.rafailov

Complex nested if formula help...

Hi, I'm new to this excel lark, i rather like it but am stuck, please can you wise people help me... heres a pic of what I'm working on... s...

1 reply Last reply on 24 Jun 2016 by
Mazzaropi

Show calculation on the first of the month

Hello, I have created a spreadsheet with various calculations. I have it divided as monthly items, however, I prefer that a certain calculation o...

1 reply Last reply on 23 Jun 2016 by
ac3mark

Account formulas

Hello, i am raja, i am working on milk processing excel sheet(it contains parts annexure II to annexure X) to start new business. anyone can help m...

3 replies Last reply on 23 Jun 2016 by
ac3mark

If statement that adds 1 for specific text

Hello, I have a spreadsheet that I have a column (I2-I48) that contains text for different ticket types. I am trying to create a formula that give...

1 reply Last reply on 23 Jun 2016 by
Mazzaropi

Find the last blank cell

Hello, I am looking for a formula/method of finding a last blank cell in a column example column A 1 2 3 4 blank cell 1 2 3 ...

3 replies Last reply on 23 Jun 2016 by
Mazzaropi

Oulook doesn't send emails, just receiving

Hello, tried all of the options you have posted here but the test message always cannot be send, feeling a bit desperate now already... maybe some...

1 reply Last reply on 22 Jun 2016 by
captainashish

Excel formula

Hello everybody! That seems so simple but I can't do it :( I would like to know the formula for this: If any text is found in cells T23 U23 V2...

3 replies Last reply on 22 Jun 2016 by
fdibbins

Names matching

Hello, I have two columns A and B, in the both columns i have the names.i have to match the all the A columns names with the B column names and B ...

1 reply Last reply on 22 Jun 2016 by
fdibbins

Microsoft outlook keeps sending the message

 Solved

Hello, I have Windows Vista with Office 2007. Microsoft Outlook has been working fine for 18 months but has suddenly developed a fault when sending e...

11 replies Last reply on 21 Jun 2016 by
Emma

Roster management spread sheet.

 Solved

Hello, Can anyone help with a spreadsheet to manage fatigue management. I have a work project where I need 20 people and for both day and night ...

1 reply Last reply on 21 Jun 2016 by
TrowaD

Finalizing macro

Hello, I've tired to work with this MACRO but I am trying to combine the content in order for it to work yet I keep getting bugs. The purpose of ...

1 reply Last reply on 21 Jun 2016 by
TrowaD

If certain 'type' is in col. k have whole row copy to new sheet

 Solved

Hello, I am wondering if it is possible to have a whole row copy to a designated sheet based off of the value in a column. So for example if my ro...

2 replies Last reply on 21 Jun 2016 by
vcoolio

Finding max value with criteria list

 Solved

Hello Chaps I don't often ask for help here but this one has stumped me. For a dashboard of sorts... I have a list of values in column S. E...

11 replies Last reply on 20 Jun 2016 by
fdibbins

Change color of cells in excel based on data in other cells

Hello, I have a question for Excel 2010 Conditional Formatting. How can I change the color of a cell to red if the value in another cell is diffe...

1 reply Last reply on 20 Jun 2016 by
Mazzaropi

Convert single column to rows, into matching rows

 Solved

Hi, I would really appreciate any help with an issue I currently have. I have a file which downloads as ASCII (text), and when opened in excel give...

4 replies Last reply on 20 Jun 2016 by
TrowaD

Help with formatting

Hello, Hi everyone. I am looking to do some conditional formatting and I need some assistance. Can someone please help me to understand how I can ...

1 reply Last reply on 20 Jun 2016 by
fdibbins

How to do conditional colour fill.

Dear CCM team I want to have cell colour of cell AL3 to green if AK3 > or = D3 and the colour should be red if it do not meet this condition. Kindl...

1 reply Last reply on 19 Jun 2016 by
fdibbins

Excel error

Hello, I am working with MS Excel 2010. While inputting data in a four-sheet file, older data of one sheet keeps being replaced by newly added dat...

2 replies Last reply on 19 Jun 2016 by
HangNguyen96

Vba code for excel

Dear Expert, Hope you will be in good health! This is Santosh from India (Gurgaon). I need your help to get images saved in the excel sheet o...

1 reply Last reply on 18 Jun 2016 by
ac3mark

Need help with counting value formula

 Solved

Hello, I am brand new. I am trying to figure out a score based counting formula. I have columns with Name, Status, Rank and Value I want the v...

3 replies Last reply on 17 Jun 2016 by
QAA007

Extract data from one sheet to another

 Solved

Hello, I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1...

1 reply Last reply on 17 Jun 2016 by
Mazzaropi

Cant open a file.

Hello, I have some problems not with excel, but with a .xlsx file , I tryed to copy ,but system writes , that file has wrong end ,and copied file do...

1 reply Last reply on 16 Jun 2016 by
DDson

Copy a row from one worksheet to another, based on criteria

 Solved

Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas alread...

5 replies Last reply on 16 Jun 2016 by
TrowaD

Cell updated when if condition is changed (macro)

Hello, Can anyone help me with a simple thing I cannot get done ? Using a macro, I want the value (integer) of a cell to be changed depending o...

3 replies Last reply on 16 Jun 2016 by
TrowaD

Convert date of birth into words

if I write 11.07.1982 in A2 ,how to get the appearance like this Eleventh July Nineteen Eighty Two Thanks

1 reply Last reply on 16 Jun 2016 by
Ambucias
Results 2001 - 2050 out of a total of 12,266