Excel Forum
-
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...
-
macro exception [Closed]
while running macro its throwing an exception 'The range does not exist'. so how to resolve this error.
-
Conditional Formatting HELP! [Closed]
Hello, I am trying to change the color of a cell(A) if another cell (D) contains text. I can't remember (or find) how to write the if statement fo...
-
Copy Employee IDs to same cell in multiple worksheets. [Closed]
Hello sir I have 400 sheets in workbook in first work sheet from I2 to I400 i have employee numbers Which i want to copy automatically to all 399 s...
-
Macro to Find, Copy and Insert [Closed]
Greetings, Despite being completely new to macros, I'm attempting to create one that will search a range of values, and insert a row directly under...
-
Copy data in one excel file to multiple excel files [Closed]
Hello friends, I have an excel field with 3 fields as below: VendorID - Name - Email ID - with nearly 5000 records. I want to get some ...
-
Automatically Copying Row When Sheet Is Opened [Closed]
Hello, I'm trying to figure out how to copy an entire row from one sheet, to another sheet automatically. But, I only want the rows to copy when o...
-
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...
-
Renaming multiple sheets in a workbook [Closed]
Hello, I have workbook with more than 50 sheets.. I would like to rename all sheets with workbook name. Something like workbook.sheet1,workbook.shee...
-
Macro to create a new workbook from a worksheet [Closed]
I would like to create a macro which copies all of the data and formatting from a worksheet into a new workbook with pasted values.
-
Help with Excel +Sheet1!XY function please [Closed]
Hello, I'm using Excel to monitor some data from my class, but I'm a fairly novice user. I've been using +Sheet1!XY to copy data from one shee...
-
How do I change +Sheet1!XY for each sheet? [Closed]
Hi, I've been using +Sheet1!XY to copy data from one sheet to another, from the same row in Sheet1 - row 8 On the next sheet I need to to copy t...
-
Compare 2 columns in 2 sheets and populate 3rd column in sheet 1 [Closed]
Hello, I have following sheets. I want to populate Sheet 1 column B with value in columnB in sheet 2 where sheet 1 CA value matches with Sheet2 CA ...
-
Sort and assign VBA [Closed]
Hello, I am trying to sort a column of Y and N i have in a chart on worksheet 1 in VBA. The list changes hourly. Once I determine who has a Y or N,...
-
Conditional Formatting based on 2 other cells. [Closed]
Hello, I have a couple of things I need help with. First off: I would like to format a cell anywhere in Column D if: 1. There is any cell...
-
need to create a macro to insert row from sheet1 into sheet2 [Closed]
Hello, I need to create a macro that will insert data from sheet1 into sheet2 based on the value in column D. The number of rows of data will var...
-
copy rows to new sheets if condition is met [Closed]
I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The column "AL" contains several ...
-
copy rows to new sheet if condition is met (using macro) [Closed]
I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The column "AL" contains several ...
-
Excel VBA that act like Template wizard? [Closed]
Hello, im kinda new to excel and vba itself. Recently i've been using Template Wizard to create a template and storing it into the database. But i fi...
-
Have to repeat list [Closed]
Dear all Please help out have to repeat two list in one list. Query: List A List B A 1 B 2 C 3 D Results List C A 1 A 2 A 3 B ...
-
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 ...
-
Copy filtered data to sheet 2 [Closed]
Hello, i have a main sheet with say column Item name and BATest. i need to filter data of BATest and if Data is Analog input (for eg) then correspo...
-
Drag formula down depending on number in particular cell [Closed]
Hello, System Configuration: Windows / Chrome 57.0.2987.133 I don't know if it is possible but here we go :) I have data from columns A ...
-
If Statement Excel [Closed]
Hello! Im a complete green at excell, maybe i just dont understand how the if statement work or im not that smart as i think :P The thing i want...
-
how to convert ounces (oz) to milliliter [Closed]
Good morning to all, can someone please tell me how to convert ounces (oz) to milliliter s (ml). Thanks JPortillo
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB