The discussions
Conditional formatting based on another cell?
Hi everyone! I'm trying to finish my financial sheet to work out where I am for this year. I need it so that when I type in the word "yes", It shows t...
Formula 1,2,3 division
Hello, sir Plz notice the formula =if(cell address >55%,"1st",if(cell address >50%,"2nd",if(cell address >45%,"3rd","Fall"))) is the correct answer? ...
Can't open microsoft office word
Hello, i'm using Word 2007. Yesterday I opened a file and it kept loading and loading but didn't open. Every files is the same. Then a notification po...
Automatically transfer data from one sheet to another
SolvedHello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...
Range of numbers
Solvedhello, I would appreciate help on the following problem :- If cell R1equals any number in the range 12 to 31 then I wish cell b1 to equal 2. Is ther...
Excel formula for conditional formatting of dates
Hello, I am having trouble coming up with an Excel formula that will provide conditional highlighting to a cell whose corresponding cell is not fil...
Add incremental number based on conditions in excel
SolvedHello, I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column bas...
Outlook on multiple pc's
Hi, At the company I work for we have 2 PC's with Outlook sharing the same email address. I was wondering if there is a way to sync this so that for ...
Date formate
Hello, how to change the date format to 19-july-09 19.7.2009 23.04.2008 26.07.2010 System Configuration: Windows / Chrome 55.0.2883.87
Increment cell value according to cell colour
Hi Guys, Can anyone help with a problem I have. I need to increase a cell count by 1 or 0.5 based on the fill colour of the cell. I am using the foll...
Copy/paste row based on date
Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the d...
Forgot password
Hello, I have forgot gmail password System Configuration: Android / Chrome 43.0.2357.121
Copy row if specific word is in a column
I have an Excel File with a tab named Ledger. I want to copy a row if it contains a specific word (Pets, Entertainment, Dry Cleaning, etc) and add th...
Google spreadsheet importrange - continuous formula
Hi, I am finding out solution on how I can make the Importrange formula continuous on the google spreadsheet. Currently, I am manually changing the ...
Excel if statement with date condition
Hello, =IF(I20=0,0,IF(I20-M20-P20-'Rate '!$D$9
Outlook can receive but not send with certain wifi networks
SolvedHello, I moved my PC to a new home and found that my Outlook can receive but not send when connected to the home's wifi. When I set up a hotspot on...
Need a macro code
Hello, need a code to copy a column from one sheet to another based on the heading name
How to show a specific column
sir i want show only a specific column on another sheet.for example i have A-Z column with data and i want to print only specific column means show da...
Generate excel workbooks based on excel list
SolvedHello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...
If then
SolvedIm trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...
Copy specific data from master sheet to multiple sheets.
Master sheet if first tab in workbook containing following: Case # Case Name Open date Atty Destroy Box # All rows in numerical orde...
Excel formulas
HI, I NEED HELP WITH CREATING A FORMULA FOR A SPREAD SHEET. THE WORK BOOK HAS THREE SHEETS (UNITS, COMPONENTS, LOADLIST). IN THE UNITS SHEET SETS OF ...
Choosing a list item
I wish to populate $values in f14 by choosing a name in a drop down list located on the same worksheet Qty Unit Price Price YT004-Oscar Terr...
Email with multiple attachments through vba
SolvedDear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column B Ro...
Can anyone pls help me
Hello, Private Sub CommandButton1_Click() Dim orange As Range, acell As Variant, bcell As Variant, ccell As Variant Dim ws As Worksheet Dim fin A...
Conditional format based on another cell containing text
Hello, i want to format a cell(make it red and negative value) if the cell next to it cantains one of the words: cancelled_by_guest. thanks stavro...
Separating dates using if function
Hello, I'm trying to set up an IF function, I believe...I have a spreadsheet that lists dates back to 2013 as MM/DD/YYYY. I'm trying to create a for...
Copy rows into sheets depending on a condition in one column
Hi, This thread has been really helpful. The first part of my code works and copies data that includes the term "EMAS" into the appropriate sheet. Ho...
Automatic copy paste
I want to copy same highlighted cells from one sheet to another ,for example sheet 1 contains a column with different highlighted colours now i want t...
If and is text or is not blank
SolvedHello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...
Conditional formatting range of date cells based on another cell
SolvedHi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...
I have a problem in match function
Hello, i want to ask u that if i have a text in one cell and i want to match more than one text from cell.for ex. cell contains(buy now this is a spa...
Compare 2 excel documents and find the same data in both sheets
Hi I have 2 separate excel documents, 1 which had 2015/2016 data and the second which has 2014 data. What i need is to compare the 2 documents for m...
Wifi connected but no internet access
Hello, wifi conected but o inetrnet access Configuration: Windows 7 / Chrome 55.0.2883.87
See which names are duplicates
Hi, I have a massive list of about 12,000 names and then another list of about 1000 names, formatted in different columns such as First Name | Las...
Convert number to word with currency
Hello, I wank to ask you guys about exel. I want to convert number to word with currency. Ex: 150.5 to One hundred USdollars and fifty cents. H...
Search for a keyword. add value from another cell.
SolvedI'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...
A if(istext) formula that needs a trimming, please help?
SolvedHello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...
Trying to drag the formula down it just copies the same
Hello, I am using the " proper" formula on my mac , but when trying to drag the formula down it just copies the same name ? Please help Confi...
Conditional formatting
Hello, I conditionally formatted cell D4 that it's color changes from white to red when value in A1 is increased from 1 to 100. Now, can I make E4 a...
Worksheets into workbook
SolvedDear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...
Text from two different cells to give value shown in certain cel
SolvedHello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...
Conditional formatting for word and date
SolvedHello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...
Auto copy and paste cell range to a separate sheet
SolvedHello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...
Need to create multiple tabs based on data in table
SolvedGood Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...
Return value in cell address
Hello, I'm having an issue returning the value cell A32. I have "A32" stored in cell H3 (it was a long drawn out process to isolate the "A32" that i...
Compare data
Hello, I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need ...
Copy a range of cell x number of times
Hello, Friend my query is I want to copy value from range (E1:F1) Base on the value from G1 And paste on range from A1&B1. It should continue ...
Transferring data from one sheet to another in excel
I followed the instructions for transferring data between Excel spreadsheets using the +Sheet(X)!((XY) formula. So glad I found your article! This w...
Lettering malfunction (appearance)
there is a problem with my LT in lettering appearance!
