Excel Forum
-
how to compare columns of 2 different Excel Solved/Closed
I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...
-
VBA Module with checkboxes to use in excel Closed
Dears, I will be very grateful if some one can help me in the following. I have excel file include 50 sheets for customers, in each sheet I have 2...
-
Delete data in excel with macro Closed
Hello, plz can u sent coding for following matter: i want to use macro in exl which is find the total word & del all data from right side plz pl...
-
Excel If Then, create a new column Solved/Closed
Hello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7 variab...
-
conditionnal formatting using macro Closed
Hello, I am trying to create a calendar in excel in which certain days shoulded be marked with a colour. In my excel file, one day is one column ...
-
VBA to Protect sheets & keep some options on Solved/Closed
Dears, I will be very grateful if some one can help me. I have excel file include 50 sheets, so I made one sheet that include all the basis info fo...
-
Indirect function on Excel Solved/Closed
Hello, I need to know how I can add the following to an exsiting cell reference in a whole column. ='Sheet1'!A2 to show =INDIRECT("'Sheet1'!...
-
Visual basic find number if can't find look in next sheet Closed
Hello, I have a list of 240,000 numbers in excel on 4 sheets is it possible to write a macro to open up an input box put in the number and it search...
-
Deleting rows and columns in a spread sheet Closed
Hello, I'm doing a project that requires 31 rows and 7 columns in a spread sheet i want to delete all the rows and have only 31 rows left but i ...
-
Macro run time error Closed
Configuration: Windows 7 / Firefox 3.6.16 Hi, I have a peice of code that filters a column for zero values and returns the rowcount. I tried...
-
If a range of cells = to a name Closed
Hello, Hope someone can help me? I have a list of text in 1 sheet, lets say: A1 Image Gallary A2 Welcome Message This list are generated...
-
searching names in drop down list in excel 07 Solved/Closed
Hello, I have placed a drop down listbox in my excel 2007 work sheet and selected the range of names which are in the same sheet. In the list I hav...
-
Comparing Two excel files Closed
Hi I need VBA code to compare two sheet's cell content in different workbook.Its very urgent pls help me. Thanks in advance. Configuration: Wind...
-
100 Mails data in on excel Closed
Hello, I want to macro, where i can copy 100 Emails data in one excel. Thanks, Kolturra Configuration: Windows XP / Safari 534.13
-
Excel macro, if > 0 add 1 to cell!?!? Closed
Hi all I am fairly new to writing macros and am completely baffled by what you guys know. I have been reading for hours on various websites etc ...
-
Advanced spreadsheet help needed Closed
Hello, im tryin to setup a spreadsheet but the stuff i learnt was oh so long ago....... i need a cell to look at another cell and if the value is...
-
Excel Data Intervals Closed
Hello, In worksheet 1, I have data in columns. I want to revise the formatting of this data in worksheet 2 so that a single record, the data from...
-
Excel 2003 Closed
Hello, I know that you can use conditional formatting in excel 2003 to format a blank cell a certain color until text is entered into that same cell...
-
need to pull data from deferent sheets Closed
Hello, I need to pull data from diferent sheets but I need to pull only if the names are the same. I need to pull from colum AI from diferent s...
-
Macro for delete a mail as soon as it read Closed
Hello, I want to send a mail to some one, the attachment contains some personal data. so i wants that as soon as he read the mail the mail will b...
-
Excel formula question Closed
Hello, Im not good at terminology. Sorry in advance. I have a spreadsheet that has several formulas. for this instance, M2 =Q1-(O2) where the ...
-
Match two rows with same values but not in order excel Closed
Hello, I'm New bee if some one could help, I wanted to match coloumn B with the values of column C which has the same values as C but less in num...
-
Excel formula problem Solved/Closed
Hello, Please Help =IF(V12=1,2*(R12*50%)) I have a problem with this formula: What I need, is if v12 = 1, 2, 3, or 4 count R12 times 50%...
-
Excel - Formula for taking avg with filters Closed
Hi Experts, I am new with excel and want to do the follwing. 1. I have sheet of all students with their names, subjects and grades 2. I have a...
-
Microsoft excel macros - Workbook names Closed
Hello, I am having a slight issue with a Macro within excel. I have a template file, with a working macro which does X Y and Z, (Summary is tha...
-
Macro between workbooks Closed
Hello, I tried to look for answers for some questions i couldn' find. My question is I have to run a Macro in such a way that. I have to sel...
-
Excel: If A1 = a 4 the comy content of b1,2,3 Solved/Closed
Hello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks Confi...
-
Excel - Help! Solved/Closed
Hello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is the...
-
Can you take the same row of data from different sheets and paste them in differ Closed
Hello, I have 12 sheets. I want to take the data (same row on each sheet) and paste that data into a new sheet but each row from the sheet will be ...
-
Find and replace with excel macros Closed
Hello, What I am trying to do is copy a cell from tab one (always the same cell) and then look for it in a column in another tab. Once I have fou...
-
how to sort more than one condition in excel Closed
Hello, I have a spreadsheet that determines quotes that need to be turned in there are several situations when the quotes have to be turned in suc...
-
Time sheet Closed
Hello, This is quite complicated to explain, therefore, I hope I don't confuse you. I am doing out timesheets. The criteria is as follows: Time p...
-
Format using Macro Solved/Closed
Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...
-
Filter rows in one sheet Solved/Closed
Hello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present ...
-
converting rows data into columns on conditon Solved/Closed
Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...
-
Excel personnel tracking sheet Closed
Hello, I am trying to make an excel sheet that counts consecutive days that a person is on the list...the list being days that certain person...
-
delete cells/rows but keep row info intact Solved/Closed
hello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report...
-
If/Then Excel Question Closed
Hello, I'm trying to get the If / Then function to do what I want and apparently I'm missing something. For example, If d2 is greater tha...
-
Dates in Excel Solved/Closed
Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For ...
-
Excel Comparing 2 columns removing duplicates Solved/Closed
Hi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A B 1 ...
-
Excel Macro to convert 'AAA-####' to 'AAA ### Closed
Hello, I'm working on a project and need a macros that will look at all the cells in a column and covert the value in the cells from AAA-#### to A...
-
Excel 2007 VLOOKUP and MATCH problem Solved/Closed
Hello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and sorted...
-
help me with excel 2003 Closed
hello, i need some help with excel 2003. i have the date in d6. And an amount in e6. Now, I want the g6 cell to reflect the following values- a) ...
-
I have 3 columns of numbers, if my number is between columns 1 and 2 Closed
Hello, I have three columns with 198 numbers in each. I want to find a formula to find if a specific number is between column 1 and 2, returns value...
-
Pivot table + VBA Closed
Hello, I am very much new to VBA programming in Excel. This is the code. Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Range I...
-
To compare substrings of two columns Closed
Hello, I was looking to compare corresponding cells of two columns for match in substrings of both the columns in Excel 2010.My data looks as Col...
-
Problem in excel Closed
dear sir, i have a problem in excel In column A have 50000 data including 9 digits . and in Column B I have 25000 data with 9 digit number. most o...
-
Excel: Matching/Sorting Closed
Hello, I'm dumb, lazy, and having trouble finding an efficient way to complete a price list for my store. Here's what I need to do. I have two fi...
-
Compare 2 sheets - output in sheet 3 - Excel Closed
Hello, I have 2 sheets. For example: Sheet 1: A2 = 777 B2 = 5 A3 = 438 B3 = 4 A4 = 555 B4 = 3 Sheet 2: A60 = 777 ...
-
How to do if statements in Excel Solved/Closed
Hello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of fig...
