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. ...
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...
Hello, pls tell me formula for convert date of birth in word in excel
HI I have two excel files .want to know how to compare the data in those excel files
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 ...
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...
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...
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...
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 ...
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...
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...
Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has
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...
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...
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 ...
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...
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
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 ...
2 different cell have same value , I need to be Auto filled same value in between the all cells
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...
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...
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...
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...
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 ...
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.
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...
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
How do I view hidden formulas on spreadsheet
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...
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...
Need to know how to added data in column field if column is not empty then go to another column and paste data
adding column data
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...
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...
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...
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...
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...
Hello, Cell A1 = SX17010006 Cell A2 = SX17010006 Cell A3 = SX16120001 Cell A4 = SX15070004 I need a formula which read first four alphanumeric...
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...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
DON'T MISS