Excel Forum
-
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 ...
-
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...
-
Comparing and merging excel files Closed
Good afternoon, Each month, my client sends me an Excel file of their updated widget list. The client's file is 26 columns in total. My file is cl...
-
date format for excel 2016 Closed
Hello, I need to change the date format to dd/mm/yyyy in excel 2016... so that when I save as a .txt file and the date should appear in the follo...
-
Introduce color gradient of col A based on the value in col B Closed
Hello, I am looking for a small help. I have 2 columns A and B, I have text written in A and numbers in % in B. Based on value in B, i want to add...
-
trying to populate columns F, G, H, I and J Closed
I've attached a photo for some clarity. I am trying to populate columns F, G, H, I and J based on the info from columns L, M and D. I've tried P...
-
comparing two files, exclude header from selection Closed
Hello, please help with the comparison of two excel sheets using macro. The one I used is - Sub All_Diffs_Highlighted() Dim wb1 As Workbook...
-
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...
-
Excel Formula Parent/Child Heirarchy assistance required please Closed
Hello and good morning, I respectfully would like to ask for assistance please with an issue I'm having to find an Excel formula to compare data f...
-
Weekly Data Imports to track status changes and new line items Closed
Hello, What method would I use to import data into excel that contains line item numbers that increase each week? Additionally each week the numb...
-
Populate a worksheet from an imported template. Closed
Good Afternoon Currently in my spread sheet There is a Main page, on that there is a button called 'CREATE NEW CLIENT'. When clicked it runs this m...