The discussions
Search for input criteria, return designated cells.
SolvedHey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...
Copying dates to another worksheet.
SolvedHello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
Excel formula - add days to date based on drop down selection
SolvedI want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...
How to auto-populate values from certain cells into a new sheet
SolvedHello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...
Highlight only one column which has greater value
SolvedHello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...
True or false value based on 3 difference cells' criteria
SolvedHello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...
Repeating a simple macro loop up to 1,500 times
SolvedHi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...
Excel external data connection not working properly
SolvedHello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...
Create a date from 3 different cells
SolvedHello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...
Macro to insert multiple rows between existin
SolvedHello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...
Copy and past the not equal value using macro
SolvedHi guys!! Please help me with this. I'm trying to compare two sheets in excel. If it is NOT a match then copy the entire row into a new third sheet. ...
Script is really slow and sometimes crashes
SolvedHi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...
Need help with script or formula
SolvedColumn A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...
Matching cells but exclude blanks
SolvedHello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...
Rounding up time
SolvedHi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...
Vba compile error: do without loop
SolvedHello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...
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...
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 ...
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...
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...
