The discussions

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

Overflow error

Hello, I USED THIS MACRO BUT AN OVERFLOW ERROR MESSAGE APPEARS. KINDLY, HOW CAN I SOLVE THIS PROBLEM ? Configuration: Windows 7 / Chrome 47.0....

1 reply Last reply on 28 Dec 2016 by
RayH

Format cell values to be included in another cell

Hello, I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows...

2 replies Last reply on 27 Dec 2016 by
kcufit

Conditional formatting problum

Hello, i have excel 2010 i have two rows. a & b i want if row a cell value not equal b cell value then change color cell b. (Note this format...

1 reply Last reply on 27 Dec 2016 by
rizvisa1

Using cell a1 to reflect status of a2-a15

Hello, I have conditionally formatted A2-A15 to visually represent a stoplight for a series of equipment dependencies (RED, YELLOW, GREEN). I...

1 reply Last reply on 25 Dec 2015 by
rizvisa1

Excel

Sir I ve the following fields in my database Date Receipt No Ref No Name of the student Fees Tc total 01/04/2015 ...

1 reply Last reply on 25 Dec 2015 by
rizvisa1

Import multiple xmls into a single excel file

Hello, I have > 100 xmls to be imported into excel. Is there a way to import all the XMLs into a single excel? Please help need this urgently. ...

1 reply Last reply on 25 Dec 2015 by
rizvisa1

Date format change

Hello, The date format is as follows : Dec 15, 2015 10:47:52 AM, I need to change to the format "DD/MM/YYYY". Could you please help me with this. ...

1 reply Last reply on 25 Dec 2015 by
rizvisa1

Automatically email notification

Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47...

1 reply Last reply on 25 Dec 2015 by
rizvisa1

How to get filtered data into a separate sheet

I HAVE MY DATA SHEET WITH FIELDS GROUPED UNDER NAME, REF.NO, SALES . I WANT TO SORT IT ACCORDING TO THE REFERENCE NUMBER AND PLACE THE PARTICULA FIELD...

1 reply Last reply on 25 Dec 2015 by
rizvisa1

Database report

Dear Sir I have the following fields Month Receipt No Ref No. Name of the student Fees Transport Total. We enter the data according to the recei...

1 reply Last reply on 25 Dec 2015 by
rizvisa1

Vba script to copy data to another worksheet if the conditions

Hi , Can someone help to give some VB script copy data from one sheet to new sheet if the conditions matches. I have a guest list with name, email ad...

1 reply Last reply on 23 Dec 2015 by
vcoolio

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

Conditional formatting

I want a cell to change colour if the value in another cell is negative

1 reply Last reply on 22 Dec 2015 by
BrianGreen

Watermark

Hello, I have a draft document that I have chosen a watermark but it seems that the watermark is only showing up on certain pages of my document...

1 reply Last reply on 22 Dec 2015 by
BrianGreen

Cant get word back

Hello, I wanted to upload a file on word and so I clicked my document and it said something like do you want to download this on another app. Then...

2 replies Last reply on 22 Dec 2015 by
J

Code macro how to select used rows of a column

Hello everybody, I'm struggle with my macro code. I would like to copy data to a worksheet and paste them to another. My problem is everyday the...

1 reply Last reply on 21 Dec 2015 by
TrowaD

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

Format one cell based on a text value in another cell

Hi I'm trying to change the colour format of one cell with a text value based upon the text value of another cell, but cannot get it to work in exc...

3 replies Last reply on 19 Dec 2015 by
ac3mark

Popup message

Hello, I have a worksheet with several column displaying numbers. I wish the worksheet to popup a message when the number decreases below 21 to po...

2 replies Last reply on 19 Dec 2015 by
Akshay

Creating an order list from a sales sheet

Hello, I am working of an excel sheet which is updated every time a sale is made. what i would like to do is have a list auto populated which woul...

6 replies Last reply on 18 Dec 2015 by
Aytaccemal

Make in to single row in exce;

Hello, I HAVE EXCEL DATA IN THE BELOW FORMAT 93456787 BR129 11-10-2011 12:34:00 PM 93456787 BR140 16-9-2012 11:24:00 PM 93456787 BR1...

1 reply Last reply on 18 Dec 2015 by
RayH

Formula to pull out text in description

Hello, I am looking for a formula that will produce the following results: Actual: A1. Cash 10/2/15 A2. CC Application 10/4/15 A3. Check 10/1...

1 reply Last reply on 17 Dec 2015 by
TrowaD

Date and amount

Hello, I need to write a formula to give me alarm by turning the cell to red color and the formula is about the following: If the amount in Cell...

1 reply Last reply on 17 Dec 2015 by
TrowaD

How do i code using a cell?

Hello, I want to make a code that takes "50,41,62,62,60" and change each number to a letter so it's says something like a phrase such as "hello" h...

9 replies Last reply on 16 Dec 2015 by
ac3mark

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

Macro to cut and paste into next available row in another sheet

Hello, I am very new to Macros and I am trying to write one that will cut the data in cells F3:H13 on sheet 1 and paste them in the next available...

1 reply Last reply on 15 Dec 2015 by
ac3mark

Comparing two sheets in excel to eliminate date

I have two lists in excel, one is a full list of data and one is the list of data that I need to eliminate from the first. How do I compare the two li...

1 reply Last reply on 15 Dec 2015 by
rizvisa1

If formula

Hello, I have to keep track of utility bills for my company on a month to month basis; is there an "if" formula that I could use to alert me if I have...

1 reply Last reply on 15 Dec 2015 by
rizvisa1

Excel 2013 macro

Holà! I am currently using this macro created by a former coworker to create & save as, a couple dozen excel workbooks. (This is just a section to...

1 reply Last reply on 15 Dec 2015 by
rizvisa1

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

Number conversion to code

Hello, Hello, I appreciate any and all who may give this issue some consideration. This is to change a number to a code of letters to hide ...

2 replies Last reply on 14 Dec 2015 by
TSCGCobra043

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

How to separate the worksheet based on data

Dear Sir. I had the data as mentioned below for your reference CODE EMPNAME EB HRA GROSS 175702 MAURICE J P 10,140...

1 reply Last reply on 12 Dec 2015 by
vcoolio

Copy data without opening workbook using vbscript

Hello all, Is it possible to copy data without opening workbooks using vbscript? Thanks in Advance!

3 replies Last reply on 11 Dec 2015 by
ac3mark

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

If a cell in column contains "x", return the value

Basically I have a large spreadsheet and I want to pick out the values that I flag with an X. Not all of the rows have an x next to it, but the ones t...

2 replies Last reply on 10 Dec 2015 by
higgins227

Free pdf to excel converter

please is there anyone that can share a free pdf to excel converter? thanks

1 reply Last reply on 9 Dec 2015 by
xpcman

Adobe acrobat in german need english

How can I change the language from German to English, if I cant read German? Can someone show me with the tabs? I have tried translating each word on ...

2 replies Last reply on 8 Dec 2015 by
mcfox

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

Formula issues with various variables

Hello, I appreciate the time the forum are taking to view my message. I'd very much appreciate it if someone could help me, as I'm trying to make ...

1 reply Last reply on 7 Dec 2015 by
ac3mark

Ms office 2007 work on windows 7 ultimate or not

Hello, ms office 2007 enterprise work on windows 7 ultimate or not ? please reply ...... Configuration: Windows / Firefox 29.0

1 reply Last reply on 7 Dec 2015 by
xpcman

Transfer data automatically from one sheet to other based in

Title->Transfer data automatically from one sheet to other based in specific dates. Hello and sory for my long title. How can transfer data from a c...

4 replies Last reply on 7 Dec 2015 by
NickBR

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

3 replies Last reply on 5 Dec 2015 by
Asrar
Results 2451 - 2500 out of a total of 12,260