Excel Forum
-
Return text with text colour [Closed]
Hi Is there a way of doing the following for example? In cell B1 for example, I would like whatever is in A1, but with the same text colour. ...
-
Show text in one cell upon drop down list selection in another [Closed]
Hello, I am trying to get text to change in one column based on text selected from list in another; example in D2 I have a drop down list represent...
-
Convert date of birth in word [Solved/Closed]
Hello, pls tell me formula for convert date of birth in word in excel
-
How to use match function in Excel [Closed]
HI I have two excel files .want to know how to compare the data in those excel files
-
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 ...
-
the formula should be simple A+B=C,true or false but nope? [Closed]
Hello, i need formula help please! i am working with three columns of data. if: cell A1=B9904 cell B2=A2399B then cell C2 needs to =B9904 A2...
-
Automatically populating other sheets based on a certain range [Closed]
Hello, I'm making an Inventory workbook for a small manufacturing company I am assisting over the summer, and I've run into a problem. On the fi...
-
Conditional formatting: change fontcolor based on another cell [Solved/Closed]
Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...
-
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 ...
-
Same coloumns in different sheets [Closed]
Hello, I am trying to make an excel sheet for school to enter their different classes data base. I want to to create a templet table or colou...
-
Macro to create, and connect to, individual sheets. [Closed]
Hello, I'm trying to create a macro that I can run that will create a new sheet based on a row. The new sheet will have all of the column headings A-Q...
-
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
-
Comparing 2 Excel spreadsheets [Closed]
I have a giant master list of addresses. I have a second much smaller list of addresses in a specific radius. I want to compare the data in giant li...
-
Issues in writing multiple if conditions inside vlookup [Closed]
Hello, I have two sheets. 1st sheet has an unique information in the first two columns about bike and its repair date (DD/MM/YYYY) format. 2...
-
Pivot table Code Troubleshooting [Closed]
Hello, I am trying to create an auto pivot table using some data that I have. However after repeated attempts at troubleshooting, I am unable ...
-
expenditure reports for every quarter automation [Closed]
I have an excel workbook that contains expenditure reports for every quarter, I want to automate this data and create a report in a required format. A...
-
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
-
Populating Sheets based on value in other sheet [Closed]
Hello, I am trying to set up a worksheet so that when specific values are in a column, the entire row would copy onto another sheet with the same ...
-
how to auto fil 2 differand cells have same value [Closed]
2 different cell have same value , I need to be Auto filled same value in between the all cells
-
Automatically transfer data between worksheets [Closed]
Hii I'm currently trying to make my work life a little easier and have created an excel spreadsheet of all the incoming paperwork we have for stude...
-
Macro to paste a unique count number of times [Closed]
Hi everyone, I am trying to create Macro to paste a unique count number of times in excel for E.g John 2 Steve 5 Matthew 3...
-
Unable to Change the date format [Closed]
Hello, I need to change the date format from Apr 2, 2017 01:39 PM to dd/mm/yyyy hh:mm but still not successful. Kindy assist. System Con...
-
Repeat value certain number of times [Closed]
Hi Guys! I'm having a hard time creating a formula to extract data based from this. This is what's showing in one of the sheets: 8:30 PM 4.00...
-
Macro to automatically insert rows [Closed]
Hello, I am building a training worksheet, with 1 main data tab that has all the company names that we work with in column A and their associated ...
-
excel conditional formatting [Closed]
How do change the color of one cell if another cell contains a text. For example: If B3 contains any text then I want A3 to change color.
-
Excel formula to handle duplicate records [Closed]
Hello, Thank you so much for taking the time to assist in resolving this for me. Column A, Column B 30001234, 587 30001234, 586 3000123...
-
data needs to be added to another sheet [Closed]
hello i need my data needs to be added to another sheet at field of column 1st but column is not empty then add to another column. pls 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
-
vba code [Closed]
adding column data
-
Color cell based on two worksheets' matching values. [Closed]
Hello, I am in the logistics field; one task that I have to do daily is compare two automatically populated workbooks (yesterday's and today's) and...
-
How to automatically copy selected cells to different sheets? [Closed]
Hello, I am trying to build an Excel workbook that records information from certain invoices in one sheet and then categorizes them into other spe...
-
Copying cells if condition is met [Closed]
Hi everybody, I'm trying to make a spreadsheet with a "master sheet" with all the information for the people registered in our club. In this master...
-
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...
-
Excel Help with comparing one file to another [Closed]
Hello, I am trying to see if file matches another file to make sure the account hierarchy is correct. I have manually checked some and they are cor...
-
Extract year from alphanumeric serial numbers. [Closed]
Hello, Cell A1 = SX17010006 Cell A2 = SX17010006 Cell A3 = SX16120001 Cell A4 = SX15070004 I need a formula which read first four alphanumeric...
-
Matching Names to Id Numbers [Closed]
Hi, I have a list of 1,200 students. They have won awards. I want to match the students who won awards with their student id numbers. Is there a...
-
Macro - filling a workbook form with data in another workbook [Closed]
Hi there, i'm looking for some help with a macro. I have 2 workbooks, one is a form with several cells that need to be filled out (FORM.xlsx) and the ...
-
Combining and copying cells if a condition is met [Closed]
Hi, I want to create a VBA script that does the following: Looks at values of column 5 (column E) of Sheet2 (values are Y or N). If the value is Y...
-
Pull information from one sheet to another [Closed]
Hello, I have a sheet called "Master Client List" that contains 4 columns of data: Counselor Name, Client Number, Client Last Name, Client First Na...
-
Excel Find & Paste Formula [Closed]
Hello, I have a list of product name in cell A containing country name and I wanted to bring put that country name into an adjacent cell. Do you...
-
Macro to create a new workbook from a worksheet [Closed]
Hello, Please can somebody help me with the below query? I would like to create a macro which copies all of the data and formatting from a spec...
-
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...
-
VBA to find specific text and cut and past into new worksheet. [Closed]
Hello, I am struggling to find anything to help me with my VBA code that I am currently trying to write. I need it to find specific text (Technica...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- Computer Boots to Black Screen
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram