Excel Forum
-
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
-
Font Change with another cell entry [Closed]
Hello, I have "text" in cell G18. However, I want the font color to change based on any currency amount entered in cell J18 System Configuratio...
-
create macro on one sheet to update on another sheet [Closed]
Hello, Trying to create a macro that will update data onto another sheet. Further this other sheet will be spending on the file path that the user ...
-
Finding sort based on gene name [Closed]
Hello, I have 2 gene lists with corresponding expression from 2 different cell lines, I am trying to compare the expression of each gene in the tw...
-
The date does not show up as entered. Date format. [Closed]
I am working with excel 2007 and the dates I enter show up completely different than the data I input. For example: I enter 050116 (no separators) ...
-
Future date based on text result and previu [Closed]
Hello, I'm not very good at this and am struggling to find the correct formula to calculate future dates but with multiple variables and cells as ...
-
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 ...
