The discussions
Compare values in two columns and return the value from third
SolvedHello, 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...
Place specfic text in cell based on text in an adjacent cell
SolvedHello 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 ...
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!
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...
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...
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...
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...
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: ...
Adding points from one sheet to another
SolvedHello, 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...
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...
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 ...
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...
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...
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...
Trying to create an order sheet
SolvedHello, 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...
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 ...
Exporting data
SolvedHi 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...
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...
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...
Conditional format to highlight cell based on date
Solvedhi 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...
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, ...
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
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 ...
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...
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...
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...
Vba search column for matching string
SolvedI 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...
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
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...
Negative cells
SolvedHello, 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...
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...
Calculate no of days left from today to a future specified date
SolvedHello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116
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
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...
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...
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...
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 ...
Creating remarks from grades
How do I create corresponding remarks against letter grades?
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 ...
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...
Macro
ClosedHello, 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.
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 ...
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...
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...
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
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...
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...
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...
Compare columns and create list of duplicates
SolvedHello 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 ...
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...