The discussions
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...
Conditional formating of cells
Hello, I am trying to set up the conditional formats of cells as follows :In column D place the company name - have the next 13 cells to the right t...
Copy data from one sheet 1 to sheet 2 only if text
Hello, I have sheet 1 tracking a lot of different information (Client name, date in, date put etc...) for 2 machines. (Machine A & Machine B) N...
Need help to macro my invoice number
SolvedHello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...
Search value error
SolvedHI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...
Selecting the different range of cells based on values
Hi all, consider the Excel sheet A B C D 1 NAME CITY AGE CLASS 2 ALEX NEWYO...
Information automatically updated
Hi, So I am creating a file for my boss on excel 2016 that I want to automatically update information from one table to the other without me havin...
Need help with conditional formatting.
Hello, I need to have my spreadsheet enter a date that is 6 months (180 days) from an original date once it is entered. I have 2 columns - Date Pl...
Searching and replacing dates
I need to search and replace dates. For example, in one row (representing one employee), all dates prior to 8/9/16 and replace those dates with 8/9/1...
Automatic numbering of invoices in excel
How do I create a macro for sequential invoice numbering in Xcel
Need a formula to compare two columns and return a value of 1
Good Morning, I need a formula that will compare two different columns and then return a value of one if certain criteria are met. The criteria: ...
Nested if statement not working
SolvedHello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE =IF(AND(I6>=C7,I6=F7,I6=C7,I6=F7,I...
