The discussions
Conditionnal formatting using macro
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
SolvedDears, 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
SolvedHello, 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
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
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
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...
Marco that can replaces the cell value
Hello Excel Marco Experts, I need a marco that can replaces the cell value in column A from cell value in column B, if it finds cell value in col...
Reset gt-s3653 phone security password
Solved/ClosedHello, sir I am jass pls help me forgot my gt-s3653 phone security password. My IMEI No:- 35804003285049/1. Reply as soon as possible codes ! Thanks
If a range of cells = to a name
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...
Pdf opens instead of word doc.
Hello, I am trying to open files that my teachers have posted on my school website but they keep opening in PDF(Adobe) Instead of Word. I can save t...
Checkbox selection
SolvedHello, I've got two checkboxes,CheckBox1 and CheckBox2.I would like to make only one of the checkboxes to be selected at any one time.If one become ...
Searching names in drop down list in excel 07
SolvedHello, 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...
Count text with different color in a range
Hello, I have 200+ columns of text data, very simple data like "AA" or "CC", some of which is in red font, rest in black font. I need to count the ...
Comparing two excel files
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...
How do i change or reset the password to my w
SolvedHello, I recently bought a laptop from a second hand store. However the previous owner had a password set on the only administrator account and i ...
Mail.com server settings
SolvedHello, My Indiamail.com which was in Mail.com is not working from 08.04.11. what is happening? I need that ID very essentially. What to do? Sam...
Appology
Hello, Sorry for not being appritiative. I didn't mean to .Iwont do it in future.Thanks very much for pointing that out.Hope my appology is accept...
Laptop types in numbers not words in browser
Hello, I have lenovo G550.....In my browser only, when I type in letter, nnumbers appear instead. The numbers appear as 1234567890123.......and on...
Remove my memory card password
i forgotten the password of my memory card can you pls remove the password or unlock it. Thanks
100 mails data in on excel
Hello, I want to macro, where i can copy 100 Emails data in one excel. Thanks, Kolturra Configuration: Windows XP / Safari 534.13
Forget my memory card password
Hello, i have nokia 2700classic and 1 GB micro sd card and i lost my pasword pl. help Configuration: Windows XP / Internet Explorer 6.0
Please help me in creating this pivot table
Hello, I have to create a Pivot table which has 3 cloumns one is Workflow name, second is max duration and third is Number of records proceeded. ...
Excel macro, if > 0 add 1 to cell!?!?
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
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
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...
Password recovery of memory card
Hello, i have nokia 5130 expressmusic mobile phone with 2 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the...
Excel 2003
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...
Change currency formatting on value of a cell
Hello, I have a conditional formatting issue in Excel 2007. I have a drop down list which shows 4 countries; UK, DE, FR and NL I would like to ...
Need to pull data from deferent sheets
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...
Find last open cell in colomn
Hello, Hope someone can help! I need a formula for the following. If a1 = 4 then copy b1, c1, d1, e1,.. to first open cells in sheet 2 cou...
Formula for text
SolvedHello, I am trying to make a formula for text. This is what i want; In one coloumn i have a category and i want the next coloumn to be the in...
Macro for delete a mail as soon as it read
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...
Saving .pps attachments using windows
Hello, How do I SAVE .pps attachment in Windows XP? Configuration: Windows XP / Safari 534.16
Excel formula question
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 ...
Memory chip password breaker
Hello, My phone model no is nokia 5200.I have forget my memory card password plz help me to retrieve the password.i will be very thankful to all of ...
Match two rows with same values but not in order excel
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...
Do math based on partial match to previous
Hello, I need to subtract column I, the previous row, from column I current row and output the result into column J. The issue I have is I need th...
Subtract the value in the adjoining column
Hello, Thank you for your response. I'm sorry about the link, i must have copied it wrong. Please find below the correct link.... https:/...
Fill a series stop with value of another cell
SolvedHello, I wish to fill to the right, rows whose number of entries depends on a cell to the left, and whose length is therefore variable. e.g. ...
Excel formula problem
SolvedHello, 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
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
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
ClosedHello, 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...
Pdf size increase
Hello, I have donne what jfLawya said (using Adobe Proffesional) and my pdf has turned from 5 mb up to 9mb. It has increased!!! Could it be becaus...
Forgot password
SolvedHello, i forgot my admin password of my windows xp. how do i log on now? Plz help Configuration: Windows XP / Internet Explorer 6.0
Looking for duplicate numbers from one column
SolvedHello, i have 4300 old applicant numbers which i need to check against 3300 new applicant numbers and highlight duplicates. these are in two colu...
Excel: if a1 = a 4 the comy content of b1,2,3
SolvedHello, 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...
Formulas to search for certain words in cells
SolvedHello, I have monthly bank statements that are downloaded into excel, over 2500 line items. In Column A, I have the description of the transac...
System password remove
SolvedHello, how i can remove system password Configuration: Windows XP / Internet Explorer 7.0
Excel - help!
SolvedHello, 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...
