The discussions

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

Copy data from another sheet if the condition is met

Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...

1 reply Last reply on 23 Nov 2015 by
vcoolio

Transfer data if....

Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...

3 replies Last reply on 23 Nov 2015 by
vcoolio

How to convert a numeric value into english words in excel 2007

Hello, Configuration: Windows XP / Chrome 43.0.2357.134 Sir, How to convert a numeric value into English words in Excel 2007 in software

1 reply Last reply on 22 Nov 2015 by
BashirYazbik

Outlook.com

Hello, I have a email that I consider as voluntary work. Address is: ***@*** I would like to have a personal email that will not be affiliated ...

1 reply Last reply on 22 Nov 2015 by
Ambucias

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

Word icon

Hello, My word icon desapered from desktop how do I recover it?? Configuration: Windows / Chrome 46.0.2490.86

1 reply Last reply on 21 Nov 2015 by
BrianGreen

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

Listing ignoring blanks and avoiding duplicates

I have a query but need to send a sample excel file for that. How do I attach a file as I do not see any link for that. Regards. jsexcel

1 reply Last reply on 20 Nov 2015 by
RayH

If formula

Hello, I've got this formula that is supposed to give me two values however when ever I implement it, it seems to just give me one value all of time...

1 reply Last reply on 20 Nov 2015 by
RayH

Excel: get value from sheet 1 to sheet 2

Good evening, I need help please about what I am wrong. I have Cells A6 to F6 in Sheet1 has formula in it and I was trying to get the value of tho...

6 replies Last reply on 19 Nov 2015 by
BashirYazbik

Today function

Hi, i am using today function in excel, i don't want change the date, when i open other day, it should show the previous date. Thanks Bbbp

1 reply Last reply on 19 Nov 2015 by
TrowaD

Regarding office 2013

Is VISTA capable for microsoft office 2013 ? Plz answer me .

1 reply Last reply on 19 Nov 2015 by
TrowaD

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

Formula to count the duplication of a value in a range

Hello, I am looking for a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the ...

4 replies Last reply on 18 Nov 2015 by
ARZANM

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

=if(l9+m9>=40,10,) =if(d8>=5,-40,) how do i make this work

Hello, =IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work? Configuration: Windows 7 / Firefox 42.0

1 reply Last reply on 17 Nov 2015 by
RayH

Positioning teams for tournament

Hello, I'm creating a spreadsheet for a netball tournament and want it to calculate the finishing positions (1st, 2nd etc) based on the points sco...

1 reply Last reply on 17 Nov 2015 by
TrowaD

Macro to rename sheets based off cell value

Hello, I have a workbook that I copy each month with dated sheets I would like to be able to rename each sheet based on the date.

7 replies Last reply on 17 Nov 2015 by
TrowaD

Don't know what my mobile password is

 Closed

Hello, My one app is asking for my mobile password and I don't now what that is? Configuration: iPhone / Chrome 38.0.2125.102

Last reply on 17 Nov 2015 by
Computertech

Spreadsheet

Hi everyone, I have a question regarding this problem. I want when I enter in one cell code example: C.1.1.2., C.1.1.3, C.1.1.4. ..., that my other...

1 reply Last reply on 16 Nov 2015 by
ac3mark

Copying data one excel sheet to another with transposing columns

We have a spreadsheet with rows and rows of data. Let's say column 1 is name, column 2 is address, column 3 is phone number, column 4 is rep name. L...

1 reply Last reply on 16 Nov 2015 by
TrowaD

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

Subtotal

Hello, Im using subtotal and it isn't changing when i hide values. =SUBTOTAL(109,A42:GA42) Configuration: Windows 7 / Chrome 46.0.2490.86

1 reply Last reply on 13 Nov 2015 by
RayH

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

Copying rows when inserting a column

Hello, everyone I have a problem with my database I am inserting new columns when there is a new company added and the go between two existing columns...

7 replies Last reply on 13 Nov 2015 by
rizvisa1

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

Connecting excel database to the company's website

Hello everyone and thank you for any help on this problem that I have. My boss just asked me to connect the excel database I am finishing up on cre...

1 reply Last reply on 12 Nov 2015 by
xpcman

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

Macro to create list from master sheet

Hi! I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet...

1 reply Last reply on 12 Nov 2015 by
TrowaD

Find which stock #s are on both spreadsheets

Hello, I have two excel spreadsheets. I want to know how I can find out which stock numbers are on both spreadsheets. Do I use VLOOKUP and if ...

1 reply Last reply on 11 Nov 2015 by
vcoolio

Transfer of data to other sheet

If I put a name in cell AC4 then I want to transfer value of cell A4 & Y4 to other sheet. Can some some help me in this matter. Thanks Musharaf

5 replies Last reply on 11 Nov 2015 by
vcoolio

Cannot load microsoft office

Hello, I have purchased Microsoft Office and I am trying to load it from my digital locker. I keep getter a certificate error even with the pro...

1 reply Last reply on 11 Nov 2015 by
xpcman

Positioning in excel

I have aproblem with positioning in excel and i have been doing this but i have failed can you give me an assistance like by positioning them lyke 1s...

1 reply Last reply on 11 Nov 2015 by
rizvisa1

Excel multiple if conditions

Hi I have 9 different descriptions of trailer loads in Column D (they are programmed so I can choose them from a drop down list). Then in Column F ...

1 reply Last reply on 11 Nov 2015 by
rizvisa1

Bring back a value (customer id)

Hello, I need to bring back a value (customer Id) into Column J if column A from that workbook and Column A from another workbook are a match. T...

1 reply Last reply on 11 Nov 2015 by
rizvisa1

Conditional formating with if statements

I want to do conditional formatting. But my numbers change if a certain box is checked..... how do I accomplish this??? i.e. A regular clean would...

5 replies Last reply on 10 Nov 2015 by
ac3mark

Return header if word within cell matches word within any array

Hello guys, I'm trying to classify a cell [G1] based on particular words found within 2 columns [D1 & E1]. This classification copies down from [...

1 reply Last reply on 10 Nov 2015 by
rizvisa1

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

Word 2007 download

how to download microsoft word 2007 without paying anything

1 reply Last reply on 10 Nov 2015 by
TrowaD

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

Excel formula

Hello, How do I put in a formula to search a worksheet and add the numbers up which is in the cell next to a name. Ie. I want to search for DS ...

1 reply Last reply on 10 Nov 2015 by
TrowaD

Excel macro

WPS require an automated process for adding new suppliers into the "Resource Management" workbook. There is data for three new suppliers (Agenda Corpo...

1 reply Last reply on 10 Nov 2015 by
rizvisa1

Formula for date comparison

Hello, Configuration: Windows 7 / Internet Explorer 9.0 I am looking for a formula that will compare two columns with dates. It would be co...

1 reply Last reply on 10 Nov 2015 by
rizvisa1

Cut copy paste option

Hello, I would like to request if user copy data from "ExcFileB" Sheet1 to "ExcFileA" Sheet1 then it always Pasted as Values. Is this possible i...

5 replies Last reply on 9 Nov 2015 by
smuneeb
Results 2551 - 2600 out of a total of 12,266