Excel Forum
-
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...
-
Excel Macro help, copy rows and paste rows X times below [Closed]
Hello, I need an macro to simply the below operation. I want to copy below text x times A B C D E F G If I want to output it 3x, t...
-
Trying to simplify data in Excel through VBScript [Solved/Closed]
Please help desperate novice: In Excel, I have 5 columns: Bob Dad 12 13 blank Sue Mum 34 56 22 Gill Daughter 23 67 34 Jock Son 24 55 blank ...
-
Lookup formula to find names. [Closed]
Hi All, Thanks for your time. column C is from 1 to 12 column D is an amount I have a table of numbers which categorized the numbers with...
-
picture browsing using excel data [Closed]
Hello, please proving coding for above requirement thanks
-
any one can help. [Closed]
Hi All, column C is from 1 to 12 column D is an amount I have a table of numbers which categorized the numbers with specified amount and catego...
-
Data draw issues [Closed]
Hello, We're trying to create a document that displays the amount of homework hours for students based on the totals found in separate excel docum...
-
Conditional Formatting [Closed]
Hello, I am trying to change a text color of one column based on another columns value. For example in Column A if it shows a W then the Dollar amou...
-
How do I use conditional formatting in Excel [Solved/Closed]
Hello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...
-
Parent/Child flat heirarchy formula needed [Closed]
Hello, I need to compare data from one column to a another column in a hierarchy level, so if the level is 1, there is information in different co...
-
Move named data from rows to same named columns [Closed]
I have a spreadsheet that has different test results for the same patient listed n multiple rows. I need to have all the results for the same patient ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Get More Followers on Instagram
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account