The discussions
Automate the process
Hello, I have this problem on how to make this in to just one procedure. Range is C:C now as you can see it selects a range and copy its ...
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 ...
Conditional formatting multiple `if then's
Hello, Quite simply, I would like to sort and filter names and dates (in specified colors given the specified dates). What has taken me four days...
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...
Any one with help please??
Hi , im just wondering any one no why my saved work will not open after installing microsoft word 2010 and deleting the 2000 version, aprt from that a...
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...
How to remove system password
Hello, i have no idea what i did . but apparently i put a "system password" & a " HDD password" and i have to put that everytime i start computer. Ho...
Memory card password
Hello, Hello, i have noika 3110c and i had put a password for the memory card and now i have fought the password so if u can help me. Conf...
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...
Log on/log off loop and admin password
SolvedHello, I am in computer nightmare, I have been doing my best to try and find the solutions, every time I solve one problem another occus. I cant af...
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...
Copy & paste a cell with formula
Hello, Please help me out on this. I have a problem to copy & paste in excel. What i want is to copy the result of formula in Column "A1" then st...
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...
Asking user for required data
Hi Frens, I am actually stuck up with lot of manual work, keep spending so many hours doing it. I actually have a huge data dump, I need to format i...
Checking for multiple words (text) in a cell
Hello, In excel 2007 I need to tweak the follwing formula: =IF(ISNUMBER(FIND("PIZZA",A307)),"true","false") So that it will look for multipl...
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 ...
Using vb code to copy formulae
SolvedHi I am using the following code to insert 'x' number of new rows dependant on value 'y' and it does this just how I want, however, I also want the...
Master document, page numbers
Hello, I am formatting my thesis, and I have put all my chapter documents in my master document. Now trying to get it to number my pages, but it s...
How to change a cel color
Hello, I wonder if You can help me. Is i there a way to make, if row A has numbers between 1 and 15 representing time to make the cell color in ex...
Product keycode from downloading on your site
Hello, I have just downloaded publisher 2007 from your site and it did not give me a product key code which is now being requested. Granted it will ...
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...
Please help! make my 0 become -
Hello, I have a simple formula "=sum(A1:F1)" The formula automatically shows as "0", but I want it to show as "-" if the answer is zero. Will ...
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...
Inbedding a dvd in power point
Hello, Is there a way to in-bed a dvd video on to a power point presentation? I have several videos I need to in-bed. Any assistance would be grea...
Not able to send messages
Hello, i am sapna and i am not able to send the messages to any of my friend ,i have to msg urgent to my colleague pls help me in this proplem
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...
Conditional formatting question
Hello, I am having problems with conditional formatting on Microsoft Excel 2003. The Excel file I am trying to format is basically a long list of ...
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...
Password
Hello, Configuration: Windows XP / Firefox 3.6.10 i have forgotten my memoprycard password and i want data without formatting. if is it possi...
How i apply password for my memory card
SolvedHello, how i apply password for my memory card i am using nnasaki mobile made by china
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...
Boot password
Hello,my laptop crashed now its asking me for boot password,if i press f8 its says entering boot menu plz wait and auto detecting ide devices then bac...
Get back unsaved data in mixmeister
Hello, Somehow, I managed to close down MixMeister Fusion (7.3.5.1) without saving the work I've done. Is there ANY way to get the stuff? Very...
Explorer fails opening pdf
Hello, my explore shuts down whenever I try to open a pdf file online or from e-mail. If I save the pdf I can open it later through open file in adobe...
Can i change cell color whe cell is empty?
Hello, I tried using conditional formatting but I think I am just missing it...is there a formula i can put into conditional formatting that will ...
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...
Infected .doc files
Hello, I'm having problem with my document files. First, i scanned my external harddisk with Avira, after scanning, it detected 10k of infected f...
Music playerz
SolvedHello, Whats the best Music Player that i can get installed on my computer, please help, thanks. Configuration: Windows 7 / Firefox 3.6.10
I'm recieving mail but not able to send mail
Hello, I am not able to send mail's but i am recieving mail I have confirgared Outlook Express my mail i d is rajendrapal@inspiringstep.com i ...
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 ...
