The discussions

Hiding rows when validation list is changed

 Solved

Hello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...

2 replies Last reply on 24 Mar 2016 by
tani

Userform to export data to another sheet

 Solved

Hello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...

4 replies Last reply on 24 Mar 2016 by
redbaby

Counting and stop counting days in a cell

 Solved

Hello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...

4 replies Last reply on 23 Mar 2016 by
diestra123

Vlookup formula help please

 Solved

=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...

6 replies Last reply on 22 Mar 2016 by
redbaby

Need a formula to sum a column with #value error

 Solved

I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.

2 replies Last reply on 21 Mar 2016 by
redbaby

Auto copy/paste data if criteria (same value in 2 cells) is met

 Solved

Hello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...

1 reply Last reply on 20 Mar 2016 by
JensBCN

Duplicating data from one line on sheet 1 to sheet 2

 Solved

Hello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...

6 replies Last reply on 19 Mar 2016 by
vcoolio

Colour changing in rows determined by text in 2 different cells

 Solved

Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...

1 reply Last reply on 17 Mar 2016 by
TrowaD

Transfer data between sheets in excel

 Solved

Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...

19 replies Last reply on 16 Mar 2016 by
Anonymouse

Compare values of two separate sheets and returning value

 Solved/Closed

Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...

Last reply on 15 Mar 2016 by
ac3mark

Recording macro to duplicate page and rename to numeric value

 Solved

Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...

2 replies Last reply on 15 Mar 2016 by
Shaun@1

Need to find a data in a column and copy below cell data or add

 Solved

Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................

2 replies Last reply on 14 Mar 2016 by
hirdesh_saxena

Count days in excel

 Solved/Closed

Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...

Last reply on 11 Mar 2016 by
Banjo

Combine of column

 Solved

Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.

3 replies Last reply on 10 Mar 2016 by
TrowaD

Comparing two excel worksheets

 Solved

please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...

9 replies Last reply on 10 Mar 2016 by
vcoolio

Copy paste macro needs tweak

 Solved

Hello, I'm new to VBA, and would appreciate any help with this Macro. It copys the mouse input, but overwrites the last paste. I need it to (after I...

2 replies Last reply on 8 Mar 2016 by
frank7788

Conditonal format a because of values in another cell

 Solved

Hello, i am trying to figure out how i can format a cell to show green when above a figure and red when below the figure simple i know but here co...

3 replies Last reply on 7 Mar 2016 by
BrianGreen

Function formula date and text

 Solved

Good day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl frm 1...

4 replies Last reply on 7 Mar 2016 by
vcoolio

Spellnumber vba in excel

 Solved

Hello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation =SpellNumber(1,100,000) =...

2 replies Last reply on 5 Mar 2016 by
Lan

Conditional formatting on an entire row

 Solved

Hello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12

4 replies Last reply on 4 Mar 2016 by
AKA

My email have been deleting without reading

 Solved

Hello, I keep getting emails saying that some emails have been deleted without being read. The message below is typical of what I am seeing is: ...

8 replies Last reply on 4 Mar 2016 by
raja

Copy rows from sheet 1 to sheet 2 if rule is met

 Solved

Hi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...

2 replies Last reply on 3 Mar 2016 by
sierranz

Outlook repair tool for .pst files

 Solved/Closed

Hello everyone, I'm not really sure what happened, but this morning, one of my pst-files was missing and for another I got the error: "Errors have ...

Last reply on 29 Feb 2016 by
ankitsajwan90

Formula

 Solved

Hi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity nd...

1 reply Last reply on 26 Feb 2016 by
RayH

Need cell value copy to defferent -2 work sheets within a excel

 Solved

Hello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel...

3 replies Last reply on 25 Feb 2016 by
BrianGreen

Excel function to check neighbour cells match for all

 Solved

Hi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is mes...

3 replies Last reply on 25 Feb 2016 by
Dan slow

To change cell value automatically

 Solved

Hello everyone here, this is my first question in this forum. In Excel 2013, If I type 1 in cell A1, then it should automatically change as Apple in s...

9 replies Last reply on 22 Feb 2016 by
Dhanuj

Help with if statement / vlookup (i think)

 Solved/Closed

I work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decisi...

Last reply on 22 Feb 2016 by
ac3mark

Help w/if statement

 Solved

Hello, Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return th...

2 replies Last reply on 22 Feb 2016 by
Ann

Frequent missing emails inbox (blank)

 Solved

Hello, Please assist me , why my email in my inbox goes missing, this is my 5th time it happen again. Once my inbox emails goes blank, I need to s...

7 replies Last reply on 20 Feb 2016 by
Ambucias

Macro help

 Solved

Greetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one sh...

2 replies Last reply on 19 Feb 2016 by
futurepsych92

Vba single click to get current date

 Solved

Hello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...

10 replies Last reply on 19 Feb 2016 by
sroche317

How to compare two excel sheets with varying data

 Solved

Hello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...

15 replies Last reply on 18 Feb 2016 by
TrowaD

Find serial number and input average value into adjacent cell

 Solved

Hello, I'm trying to find out if there is a way to do this. i have a list of 15k serial numbers. several of them repeat because the value vary. i ...

4 replies Last reply on 15 Feb 2016 by
Cindy

Cell = yes or other text return value

 Solved

Hello, I'm using IF statements to return a value for the specifc answer supplied for the question and then adding up all the questions for the t...

2 replies Last reply on 12 Feb 2016 by
vcoolio

How to check % value in excel and macro using vbscript?

 Solved

Want to check a cell with % percentage format matches the value in Vbscript code. Sub ChangeColor() Dim lRow Dim myVar lRow = Range("AC" & Row...

4 replies Last reply on 11 Feb 2016 by
anjanasundaram

Formula to copy rows a set number of times

 Solved

Hello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunatel...

2 replies Last reply on 11 Feb 2016 by
Sadat

Vba using subroutines - help please

 Solved

Ok guys, I have a problem (well more than one, but Im not sure I should mention those on this forum!). Im in the process of writing an Excel macro ...

7 replies Last reply on 10 Feb 2016 by
BrianGreen

Date format nightmare

 Solved

solved with this: Because it is not a date to excel. 1. Select the column in which there was date 2. Goto data and choose text to column 3....

1 reply Last reply on 5 Feb 2016 by
xpcman

Excel sum value...

 Solved

Dear I would like to know how to do the below mentioned formula I have tried but not resulted. Excel - Sum value in column when cells contains ...

2 replies Last reply on 3 Feb 2016 by
anazar

Formula help

 Solved

Can someone please help me with this formula =IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470))) What i am trying to do is : if G2 has the...

3 replies Last reply on 3 Feb 2016 by
vcoolio

Conditional formatting based on year

 Solved

Guys, I come again cap in hand with another plea for help on a sort of finished project, but I want to make it better. I have some conditional f...

1 reply Last reply on 2 Feb 2016 by
BrianGreen

Extracting rows from excel

 Solved

Hi there, I have an excel sheet with a very large data. I want to extract different rows and write them in to different sheets of the same excel (or ...

3 replies Last reply on 1 Feb 2016 by
vcoolio

Column to vlookup

 Solved

I am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...

1 reply Last reply on 28 Jan 2016 by
NickBR

Disable a cell in excel using vb code

 Solved

Hello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...

13 replies Last reply on 28 Jan 2016 by
TrowaD

User friendly code for admission no

 Solved

Hello, I would like to request to Code for Admission No Range is started from B11 to B510 If user enter a123456789 or a-123456789 it always conv...

6 replies Last reply on 26 Jan 2016 by
smuneeb

If one cell g4 has value 12345 then cell f4 will have....

 Solved

I need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...

3 replies Last reply on 26 Jan 2016 by
ac3mark

Auto copy row from one sheet to another via info in first cell

 Solved

Hello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...

10 replies Last reply on 25 Jan 2016 by
TrowaD

Excel filter/macro

 Solved

Hello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...

4 replies Last reply on 15 Jan 2016 by
vcoolio

Columns & rows help

 Solved

Hello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...

5 replies Last reply on 14 Jan 2016 by
futurepsych92
Results 651 - 700 out of a total of 2,608