The discussions
Problem with script in excel
SolvedHello, I have a problem with my script. What I want is IF the value in column J is equals to "0" then I want the column H to be blank. Ex. J1 ...
Cell colour containing specific info
SolvedHi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a differ...
Validate copied data in excel
SolvedHi, I have a below scenario one row is copied and pasted, this pasted row needs data validation such that total of each cell shouldn't exceed the r...
Multiple worksheet data input
Solvedhi TrowaD, I am an on the job trainee at a company, i was ask to encode data from our furnace but its too much time consuming for me to encode all...
Conditional format based on text in same row
SolvedHi all, New to this forum. I'm running Excel 2016 on Win7 -- my spreadsheet has results of inspections in columns E, G, and J. The possible valu...
How to manage hours and rounding in excel
SolvedHello, I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E...
Removing " false" value in "if"
SolvedHello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C11="Evening",200,IF(C11="Gaze...
Formula
SolvedI am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...
Convert date of birth in word
SolvedHello, pls tell me formula for convert date of birth in word in excel
Comparing values of two excel sheets
SolvedHello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...
Copy/paste a range 'n' times.
SolvedHello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...
Conditional format
SolvedHello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has
Vlook up
SolvedHello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help
Vba send email via outlook using loop; no response when run
SolvedHello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the r...
Vba code in my command button doesn't work
SolvedHello, I have a sample table below, I was trying different VBA code in my command button but doesn't work well. Column G is already programmed t...
Vba column
Solved/ClosedNeed to know how to added data in column field if column is not empty then go to another column and paste data
Format font colour to change
SolvedHello, Using Excel, I have a range of cells K2-K15 that contain numeric values and I want the font color to change in any of those cells that are g...
Copy rows to new sheets if condition is met
SolvedHello , please help... I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The colum...
How to "teach" excel to learn names?
SolvedGreetings to all, I'm desperate to find a solution to my tedious work. So, each day i will go through hundreds of records and change product names...
Search for a value in column and copy to different sheet
SolvedHi I want to search for an employee ID in column EID and copy the whole record into another worksheet within the same workbook if the EID is found...
If then using multiple cells and words
SolvedHello, D3,D4,D5 that all need to say either 'Compliant' or 'N/A', for result in E3 to say "yes", else "No". Please help. System Configurati...
Need help with conditional formatting
SolvedGood morning, I am trying to change the color of a cell(A) if another cell (D) contains text. The text will contain both a date and other text. Can...
How to copy data from sheet1 to sheet2
SolvedHello, I have a worksheet, there are 2 sheets. What I need is to do is copy all the column and rows from sheet1 and paste it to sheet2. The copy butt...
Excel formula for percentage
Solved/ClosedHello, I am trying to get a formula to calculate the percentage of cell O3 from cell N2. The format is what percentage is my expense (O3) from my ...
A macro to create new, copy and name worksheets based on a list
SolvedGreetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list that ...
Need help creating an if then scenario
SolvedHello, I am looking for some help with a problem. I have a big list of items within Excel and I am wanting to consolidate the big list of items do...
A macro to copy/paste a cell and other cells in the same row
SolvedI have two wooksheets in a workbook. I need that a value of each cell in a range C3:C52 in sheet 2002 is being searched for in the range B2:B101 of th...
Trying to simplify data in excel through vbscript
SolvedPlease help desperate novice: In Excel, I have 5 columns: Bob Dad 12 13 blank Sue Mum 34 56 22 Gill Daughter 23 67 34 Jock Son 24 55 blank ...
How do i use conditional formatting in excel
SolvedHello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...
Excel vba - find and expand matching cell entries
SolvedHello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...
How to populate information on multiple sheets at once
SolvedHi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...
Outlook 2007 is not sending mails
Solved/ClosedHello, Have a nice day. I migrate my data from one PC to another. The old one was having Windows XP operating system along with Outlook 2003 w...
Shortcut to edit a cell without using f2 key
SolvedHello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...
Data in a hot key
SolvedHello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.
Conditional format if hyperlink
SolvedHello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...
Compare the words in 2 columns in excel
SolvedI gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...
Excel forum within a range
SolvedGood day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...
Convert wordpad document back to pdf
SolvedHello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done beca...
Need to delete columns based on column header
SolvedHello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...
Auto generation of code
Solved/ClosedHello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...
Excel - a macro to create new workbook and copy data
Solved/ClosedIn the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...
Excel - macro to create multiple sheets
SolvedHello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...
Comparing columns and returning value
Solved/ClosedHello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
Import .pdf ...?
SolvedHello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
Formula
SolvedI need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
Conditional formatting based on two cell values
SolvedHi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...
Copying cond. format for entire row based on 1 cell to other row
SolvedI have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value
Drop down lists
SolvedHi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...
Removing false value
SolvedHello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...
