The discussions
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...
Pdfcreator won't open .ps files
Hello, I downloaded PDFCreator so I could look at some postscript files, but it won't open any of them. PDF Architect just says the file is unsupp...
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
Outlook does not open the .pst file created by the outlook
ClosedHello, Outlook does not open the .pst file created by the outlook. There are important emails. I have zipped outlook 2010 .pst file and copied ...
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
Another libra base question
Woe is me. Im going to cry :( I need to know how to do basic arithmatic with dates in Libre Base queries. All I want to do is find the number...
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...
Problems using outlook after changing gmail password
Using Outlook 2007. I have 2 email accounts which both worked fine. Yesterday I changed my password for both accounts through Gmail online. Account...
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 ...
Without key activation
Hi I have some problem in ms office 10 getting error code 0x8007007B Its product code activation error code How to activate ms office 10 without ...
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...
Pdf now in word document
Hello, I downloaded adobe reader and now all my PDF files is in word and not opening in pdf like it should be. Even my mail i cant open in pdf. Pl...
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 ...
