The discussions

Compare values in two columns and return the value from third

 Solved

Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need...

11 replies Last reply on 7 Sep 2016 by
keshav

Place specfic text in cell based on text in an adjacent cell

 Solved

Hello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that cell, I ...

5 replies Last reply on 6 Sep 2016 by
TrowaD

Change format of a cell when another cell is not null

How do I highlight a cell or row when another cell contains anything? Thanks!

1 reply Last reply on 6 Sep 2016 by
Mazzaropi

Conditional formating

Hello, I'm trying to make multiple cells turn red if a single cell has a certain value. So for example is B3 says "abc" cells B3:F21 should turn r...

1 reply Last reply on 3 Sep 2016 by
Mazzaropi

Find duplicate rows and copy content of one cell to new sheet

Hello, I'm totally new to macros and excel. I have an excel spreadsheet with huge data in it (over 9lakh rows). There are many entries that are ex...

5 replies Last reply on 1 Sep 2016 by
pacchiee

How to send an email automatic when a cell is updated

Hello guys, I am imports coordinator I have a tracker created in excel worksheet which I use to track our shipments that arrive at port then proce...

1 reply Last reply on 1 Sep 2016 by
xpcman

Comparing data among excel sheets

Hello, I have three excel sheets with data regarding product numbers and their respective plants as well as another sheet (4th sheet) which is a t...

1 reply Last reply on 1 Sep 2016 by
TrowaD

Finding the @ character within a text, cell range

Hello, I can't seem to find anything that's specific to what I'm looking for. I'm trying to find a formula that will tell me the following: ...

1 reply Last reply on 1 Sep 2016 by
TrowaD

Adding points from one sheet to another

 Solved

Hello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned x po...

2 replies Last reply on 1 Sep 2016 by
TrowaD

Date issue

if my year is only 1991 and i am trying to input the date by default 01-01-1991 in excel how? Am just doing manually 1-1-1991 and the system automat...

1 reply Last reply on 31 Aug 2016 by
ac3mark

Create a registration log

Hello, I am trying to create a registration log for a campground. It would be of great benefit if I could copy the registration info to subsequent ...

1 reply Last reply on 30 Aug 2016 by
ac3mark

Excel - a macro to move data from rows to columns

Excel - A Macro to move data from rows to columns Thanks to Venkat1926 for this tip! This Macro is working well for me, but with the exception of...

3 replies Last reply on 30 Aug 2016 by
TrowaD

Copy data of 1 sheet to another if criteria matched

Hello, 1 have 3 sheet master, damage & shortage. in master sheet if i enter in n column damage then full row should be copied in sheet damage also...

3 replies Last reply on 30 Aug 2016 by
vcoolio

How to stop today function date changing every day in excel

Hi, I am using this formula on my work sheet in cell (M7), and I have 13 sheets for each month in this workbook and I dragged the formula till cel...

9 replies Last reply on 29 Aug 2016 by
Klaas86

Trying to create an order sheet

 Solved

Hello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how may o...

3 replies Last reply on 29 Aug 2016 by
vcoolio

Creating an order

Hello, I have a multi sheet database where each sheet represents a vendor. I'd like to transfer the information from the row, Column A, B, C, to my ...

1 reply Last reply on 27 Aug 2016 by
vcoolio

Exporting data

 Solved

Hi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The data c...

6 replies Last reply on 26 Aug 2016 by
vcoolio

Conditional formatting

Hello, Can I use conditional formatting to change a number from positive to negative based on the text in another cell? For example, I have a fil...

1 reply Last reply on 26 Aug 2016 by
Mazzaropi

Add data inputed from one sheet to anther

I'm trying to do an inventory control spreadsheet where I can put the data (ex, inventory in hand, use, buy, etc and it will be saved in another sheet...

1 reply Last reply on 26 Aug 2016 by
ac3mark

Conditional format to highlight cell based on date

 Solved

hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...

7 replies Last reply on 26 Aug 2016 by
Mazzaropi

Formula that will make a specific text into a number

Hello, I need formula that will make a specific text into a number example: if A1 is R134a then B2 is 1430, if A1 is R404A then B2 is 3922, ...

1 reply Last reply on 26 Aug 2016 by
Mazzaropi

Conditional formatting

Hello, if i type "T" in one Cell i want to be fill colour to entire row how can it possible Configuration: Windows 7 / Chrome 53.0.2785.80

1 reply Last reply on 25 Aug 2016 by
TrowaD

Select a single line even if there are merged cells with vba

Hello, I'm creating a worksheets that needs to be protected at all time. However, users may need to duplicate a line sometimes. What I want to do ...

1 reply Last reply on 25 Aug 2016 by
TrowaD

Excel "if" function with date in test cell

Hello, I am trying to use the IF function with a date in the 2 logic test cell; If the 1st logic test cell has a date then I want the word "IN TRANSI...

1 reply Last reply on 25 Aug 2016 by
TrowaD

Keeping data

Hello there, I have what I consider an interesting issue and would certainly appreciate some options for resolving it as I am no Excel expert. We h...

2 replies Last reply on 25 Aug 2016 by
vcoolio

How to separate data between sheets

Hello, I'm don't know much about Excel in regards to functions and formulas, what I'm trying to do seemed like it may be a simple task but I'm le...

1 reply Last reply on 25 Aug 2016 by
vcoolio

Vba search column for matching string

 Solved

I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a c...

5 replies Last reply on 25 Aug 2016 by
Juzer

Enter date in dd-mm-yyyy

Hello, Please enter date in dd-mm-yyyy only. I have give 25-12-1988 but not accept Configuration: Windows 7 / Chrome 52.0.2743.116

2 replies Last reply on 24 Aug 2016 by
fdibbins

Need a formula

on 1/1/16 (a1) , John (b1) told me he'd pay me $1 in 30 days. i want a formula that will automatically add 30 days from (a1) in date form in another...

4 replies Last reply on 24 Aug 2016 by
Mazzaropi

Negative cells

 Solved

Hello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become positive n...

3 replies Last reply on 24 Aug 2016 by
Mazzaropi

Code for transferring data

i Have an excel workbook with different sheets. In sheet 1, i have date picker, where i select date and enter all the data for that particular date. T...

1 reply Last reply on 23 Aug 2016 by
ac3mark

Calculate no of days left from today to a future specified date

 Solved

Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116

2 replies Last reply on 23 Aug 2016 by
TrowaD

Formula zero return

Hello ~ How can I get a zero return instead of a FALSE statement with the following formula? =IF(F4>E4,(F4-E4)*24,IF(F4

1 reply Last reply on 20 Aug 2016 by
Mazzaropi

Help regarding a pricing sheet

Hello, I'm looking for help regarding a pricing sheet I'm trying to create on excel. I have my quantity in C5 = 2500 and cost in C15 = 75,000 if C...

4 replies Last reply on 19 Aug 2016 by
Kev1027

Changing colour of cell once multiple other cells contain text

Hello, I would like to indicate in a cell at the beginning of a row whether multiple 'mandatory' cells within the row contain text. Red for incomple...

1 reply Last reply on 19 Aug 2016 by
fdibbins

Count if formula

Hello, I have a Excel file where i have specific paths of the files and i Need a formula where it should reefr that cell path and Count the rows w...

1 reply Last reply on 19 Aug 2016 by
ac3mark

Format the color font depending on the value of another cell

Im new to Excel. Is there away or formula to change the color font of a cell depending on another cell? I want my text in colum A B C to be the font ...

1 reply Last reply on 19 Aug 2016 by
Mazzaropi

Creating remarks from grades

How do I create corresponding remarks against letter grades?

1 reply Last reply on 19 Aug 2016 by
Mazzaropi

Insert 1 result if a cell contains one of several possibilities

Hi All, I am new to this level of excel - but what I need is a formula that does the following : Insert if an adjacent cell contains one of up ...

1 reply Last reply on 18 Aug 2016 by
Mazzaropi

Copy values only when using a filter

Hello, VBA below, this is doing exactly what I want... however I can not get it to copy values only...not the formulas and a list which is in a co...

3 replies Last reply on 18 Aug 2016 by
vcoolio

Macro

 Closed

Hello, in excel 2013 I have column of cells a:2:a4955 of the cell.interior.colorindex = 3 then I need to return "red" I can't get his to work.

Last reply on 17 Aug 2016 by
KarenPostell

Copy paste data from one sheet to another automatically

Hello, First of all thanks for your wonderful site. I have a large set of information on one sheet. Column b has the name of the sheets in the ...

12 replies Last reply on 17 Aug 2016 by
ssdgeek

Create duplicate sheet

Hi all, Is it possible to create a worksheet automatically in the same excel workbook. For e.g i have a sheet "1" with some content (includes f...

1 reply Last reply on 17 Aug 2016 by
PoulJ

Auto-copy rows from one tab to another based on cell value

Hello! I'm really hoping this works to get a response because I am stumped. I've read a lot of sites and lot of similar posts but nothing seems to...

1 reply Last reply on 16 Aug 2016 by
fdibbins

Nested if functions using time values

Hello, I have an excel formula here, but it wont work. =IF(AND(G2>=TIMEVALUE("06:00:00"))*(G2=TIMEVALUE("00:00:01"))*(G2

2 replies Last reply on 16 Aug 2016 by
fdibbins

Auto fill in for list - based on another cell's value

Hi! I have different sections of an excel document that feature the same lists over and over again. Sometimes the values selected will be different...

1 reply Last reply on 16 Aug 2016 by
fdibbins

How could i do automatically find the price

Hello, I have question for Excel, it is small hotel booking system? If I have for example 6 rooms, and they have all different prices, i.e. 1...

1 reply Last reply on 16 Aug 2016 by
Mazzaropi

Copy row if criteria is met macro

Hello, I am looking to make a macro that will copy the entire line from sheet 1 to sheet 2 if criteria from column H is met. Essentially if th...

4 replies Last reply on 16 Aug 2016 by
Ram

Compare columns and create list of duplicates

 Solved

Hello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...

2 replies Last reply on 15 Aug 2016 by
CarlosIRL

Auto generate a copy of a template worksheet and rename each

Hello, I am very new to Excel and VB and am trying to create a macro that will do the follow; 1. Create a copy of a template worksheet (named Tem...

2 replies Last reply on 15 Aug 2016 by
vcoolio
Results 1451 - 1500 out of a total of 7,066