The discussions
If date
ClosedHello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
Macro for merging data from multiple sheets
SolvedHello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...
How to convert date into text.
SolvedHello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...
Updating master sheet with most recent data
Hello, I'm curious if anyone knows of a way to have a master sheet/summary sheet only update with the most recent data entered on a different sheet?...
Copy files from google spreadsheet to excel
Good Day partners How do I copy files from Google Spreadsheet to Excell, or How do I merger files from Google SPreadsheets
Copy row and it's contents based on value in x cell.
Hi everyone, this is my first post so I hope I'll explain myself clearly! I have a spreadsheet with the following content: (Column I (in yel...
If formula needed
Hello, I need a formula that IF there is any data/text in the cell it will EQUAL another cell, BUT... I want the cell with the formula to display th...
Statement that returns pass, fail, ""
Hello, Wanting to test row of numbers to a certain number and return pass, fail, or blank. =IF(AND(X7
Excel formula
Hello sir, . But its can't working why i dont know! Please find my attachedments. Regards, Bicky Das, bickydas00@gmail.com
Function button: unhide cells between values and hide all other
SolvedHello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...
Cell content move with vba code
I have a workbook that we create service tickets from. The main sheet is used to enter information about the job. When complete I have a button that n...
How do you have multiple out comes for the same if condition in
Hello, I have a condition in my file such that =IF(C5=C4,D3+1,D5=1 ->>>> trying to add this andD4= D3+1) Basically this what I want to happen C...
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? ...
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...
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...
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
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...
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...
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...
