Excel Forum - solved topics
- Solved
-
Excel external data connection not working properly Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hi, 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 Solved/Closed
Column 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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 Solved/Closed
Hi, 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 Solved/Closed
hi 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
I 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 Solved/Closed
Hello, pls tell me formula for convert date of birth in word in excel
-
Comparing values of two Excel sheets Solved/Closed
Hello, 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. Solved/Closed
Hello, 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 Solved/Closed
Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has
-
Vlook up Solved/Closed
Hello, 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
-
Spreadsheets viewing formulas Solved/Closed
How do I view hidden formulas on spreadsheet
-
VBA send email via Outlook using loop; No response when run Solved/Closed
Hello, 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 Solved/Closed
Hello, 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/Closed
Need 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 Solved/Closed
Hello, 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 Solved/Closed
Hello , 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? Solved/Closed
Greetings 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Good 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 Solved/Closed
Hello, 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/Closed
Hello, 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 Solved/Closed
Greetings, 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 Solved/Closed
Hello, 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 Solved/Closed
I 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 Solved/Closed
Please 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 Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hi 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 ...
-
Copy and insert rows n number of times in Excel Solved/Closed
I am trying to create a macro under Excel. My data is as follows: Col1 Col2 Col3 Col4 Col5 Col6 Col7 A1 1080 90 M 40 45 50 A2 999 90 M 25 ...
-
Shortcut to edit a cell without using F2 key Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
I 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 Solved/Closed
Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...
-
Need to delete columns based on Column header Solved/Closed
Hello, 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/Closed
Hello, 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/Closed
In 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 Solved/Closed
Hello, 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/Closed
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...