The discussions
Single item reporting from multiple sheets
Hello, Good day! I am a newbie in the world of visual basic programming in excel. My problem is my boss wants an automated summary...
Compare dates within rows
Hello, I have a query in access wich returns a title column which is common between 3 tables. The query also returns a date column which is found ...
Changing default language & in browsers too
I installed Vista to work in English, though my location is set as Israel. For some reason, Vista didn't get it right and it thinks that when I open c...
Compare 2 columns of names and report
Hello all, I have an excel spreadsheet with 2000 names (lastname, firstname) in column A, in Column B I have another 1500 names (lastname,firstname). ...
Copy sum of values from one sheet to another
Hello, I am writing a VB .net code to copy sum of values in a column "O" of sheet 1 to the first empty cell in a row "6". I have written the follo...
Compare columns and return date
Hello, I have 2 excel files: Book1.xls and Book2.xls. I want to look through column B in Book1 and column D in Book2 and find the rows that match ...
Installtion microsoft office excel phone g4
Hello, I am looking fore help Iwant to Installtion Microsoft office Excel to my i phon G4 plz
Help editing a macro for excel
Hello, I have a list of names in the form LastName FirstName. For example: Smith John. Most names consist of only one space (between the last and ...
Macro/vba help.
SolvedHello, i need help to do solve the following problem: Sheet1 contains a value for today. e.g £1000.00 (Cell A10) Sheet3 contains every date ...
Colouring a ms excel cell
SolvedHello, I need some help. How could I fill a cell in MS Excel in red if a condition has been met. For example: If the number in Cell A1 is mo...
Compare mutliple excel columns
SolvedHello, I'm working on an excel sheet and comparing multiple columns to determine if a site to be eligible or not eligible for the program, the sit...
Macro to find value and hide other rows
Hello, I hope someone can help me. I've got a set of data that contains many records for my company. I want to be able to specify a certa...
Excel summing up values of scattered data
SolvedHello, I am looking for how to make a cell in excel that tells me how many of a certain item I have. In column b I have values (numerical) of cer...
Deleting rows with data from columns matching
Hi there. Im trying to look for a Macro that will do the following. I have a large data set with a range of numbers. I would like to search tho...
Automatic sorting or rows based on the value
Hello, I basically work on excel which has huge data.. I need to search a transactions based on the amount of the transaction. As of now I'm using ...
How to change a cel color in excel
Hello, Can someone help me, if column A for ex. represents time where the number are between 1 and 15 I would like them to change color after 5 mi...
Excel data help
Hello, I need to take multiple email addressess from one cell to thier own cell. How do I do that? (IE: TOADD:; jane@comcast.net; bonnie@yahoo.co...
Needing an excel formula that has two if/then
Hello, I'm trying to come up with a formula that will pull data from a different tab, with two if/then statements. I need the data to pull if cell...
Copy multiple cells to workbooks faster?
Hello, I am trying to copy values from different worksheets and workbooks into a new worksheet. I know how to do this but it is very time consumi...
Copy values to validated cells
Hello, I have validated a cell to contain certain values only, say 1 and 0. But if i copy any value from anywhere and paste in the validated cell...
Excel refernce to another worksheet
Hello, When I try to reference a cell in another sheet of the same workbook, I get the formula instead of the value. i.e. +"sheet 2"!G65 displays...
Excel need help with greater than less than
Hi! Can somebody help with something like that? I have a list of members of my airsoft team. Every member collects points and gains military r...
Comparing columns and returning value
Hello, I had similer proble which was discussed at https://ccm.net/forum/affich-100231-comparing-columns-and-returning-value but with little...
How add the rows with the same value in a col
Hi Friends, I'm trying to make a macro to have a summary worksheet. - My purpose is to add the data in the rows which has the same ID number in...
Excel help
I am a teacher. I have a list of all the students in the freshman class and I am trying to calculate their GPA. Problem is that each students grade ...
Excel help - problem with date format
Hello all, Actually I created a spreadsheet a while ago now I need to use that one and my problem is that when I entered data that time I used form...
Excel validation with if
Hello, i want some help in excel: I have column A - Brands (about 10 different) In Column B - types of products of the brands (200 different) In ci...
Excel equation
Hello, Add equations to calculate the total cost of the loan by multiplying the number of payments (minus 1) by the monthly payment and adding th...
Copy the value of one cell from worksheet to
Help please...anyone! I'm looking for the formula in excel that copies the data from from a single cell from sheet 1 into a single cell on sheet 2....
Ms excel: value from a range
SolvedHello, HDI get a numerical value (in C2) that is assigned to a word within a range(G2:H8)? Thank you in advance!
Excel how to change a value automatically
SolvedThis is my first question on the forum so I would first like to start by saying hello to all members and moderators :) My question today which I'm ho...
Opening a new excel document using vba
Hello, I'm trying to write a vba macro that will open up a new excel document after I have manipulated my data. I want my end product to be in a n...
Comparing two excel sheets
SolvedHello, i have two excel sheets, one sheet has 100 email ids, the other have 200 email ids, the scenario is I want to know the common email ids from...
Active cell in excel macros
Hey, I'm pretty new to using Excel macros. I'm writing a macro that will be activated from many different cells. It needs to reference some static cel...
Excel custom function
SolvedHello, i have created a custom excel function which works fine. the only problem being, you need to press F2 on the custom formula cell and give en...
Query in excel
Hi I have two worksheets Pg 1 and Pg 2 Pg 1 has the following Data for 2nd Oct Company Name Volume Traded A ...
Connection is ok, can't browse the internet,
There was no warning, it just started happening, i did not installed anything. Local area network shows lots of bites sent but few received, when v...
Pls help - excel - highlight cell if no data
Solved/ClosedHello, Please could somebody help me with a problem. I have a spreadheet and I would like make some cells in a row go yellow if they have no data in...
Need excel2007 formula index, partial match
Hello, I have 2 worksheets that looks like this: (Windows XP / Internet Explorer 7.0/ Excel 2007) Sheet1: Site Information ROWS COLUMNS ...
Count rows from sheet2 and place on sheet1
SolvedHello, Windows XP / Internet Explorer 8.0, Excel 2007 I need help with a formula. On Sheet1, I am trying to get the total # of records for ea...
Dependent cells with data validation
Hello, I have let's say cell c18 include a validation list with choices Y,N. Then in Cell c19, I need it to read "0" if cell c18 is "N", but I need ...
Excel formulas
Hello, I have to create a formula that will sum a column if it meets certain criteria. The criteria must sum the list if the date fall within the ...
Excel help...
Hello, I am an excel beginner and looking for some help. Here is what I am working with... Unit $35,000 Unit $60,000 Es...
Compare two columns
Hello, i have one column has 100 email ids, the other have 200 email ids, the scenario is i want to know the non-common email ids from both the co...
Find name(s) that are in all 4 columns
Hello, I have an excel spreadsheet that has four columns and I need to find the names that are in all four columns. The columns are taken from...
Excel- comparing multiple columns
Hello, I have 8 columns to be compared with each other. Every column is suppose to be compared with every other column . Objective is to identify...
Date change in cell using excel?
Hello, When I'm using Excel, how do you put a date in a cell that will change when you use the file the next day etc.? Configuration: Windows V...
Count conditional formatted cells
Hello, I am trying to count cells that have a conditional format already applied to change their interior color to green (4). I have written a fun...
Excel formula help
Hello, I am trying to create a formula in excel so that if I change a number in one cell it subtracts that amount from a different cell for exa...
