The discussions
Cell reference to locate /store data in excel
SolvedHello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...
Emailing selected cell range using outlook
SolvedHello, Hi, I have one task. I need to email some of my invoices that I prepare on a daily basis. I have a .xls file with some work sheets. I have ...
Comparing two ranges of numbers
SolvedHello Everyone, Let me first say I'm very much an amateur with VBA code, but I have been using examples I have seen online to cobble together ...
Excel macro help
SolvedHi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...
Auto incrementing alphanumeric cell by 1
SolvedHello, I have an alpha numeric cell in excel sheet. for example IND/APR/6734/INV I am using it to give number to the invoce that I generate everyda...
Lost windows password fix gone bad.
SolvedHello, My buddy changed his password on his computer. He forgot said password and tried all day to log in. He asked me for help and I found a progra...
Old toshiba 3480ct admin password
SolvedHey guys, I have an old Toshiba Portégé 3480CT and need to get past the admin password. I have no idea who would know it, it's been in our office ...
Add/remove month button for chart.
SolvedHello, My chart receives data from columns. Each column is a month. Now I want to create two buttons: First button to add a month and another...
Delete allowediteranges by vba
SolvedDear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...
Delete allowediterange by vba command
SolvedDear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...
Excel conditional formatting rows to columns
SolvedHello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...
Help about macro copy and paste
SolvedHello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...
Copy to first open cell in rowb/sheet 2
SolvedHello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...
Vba - how to replicate the value n times
SolvedHello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have to re...
Help required in ms excel
SolvedHello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3: Organiz...
Check value in a cell vs mid value in another
SolvedHello, I have months in column A in number format. Single digit for the first nine months and double digit for the last 3 months. In column B, I...
How to compare columns of 2 different excel
SolvedI want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...
Excel if then, create a new column
SolvedHello, 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...
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'!...
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
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...
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...
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...
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%...
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...
Format using macro
SolvedHi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...
Filter rows in one sheet
SolvedHello, 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
SolvedHello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...
Delete cells/rows but keep row info intact
Solvedhello, 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...
Looking for value in a column a
SolvedHello, I have to prepare an invoice and calculate the amount of shipping. This is the lay out: I have to compare the subtotal value, E16, in ...
Dates in excel
SolvedHello, 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
SolvedHi, 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 2007 vlookup and match problem
SolvedHello 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...
Transfer barcode info to inventory quantity
SolvedHello, Is there a way to create a macros that would keep track of inventory quanitity by scanning a barcode? I have many boxes that have barcodes...
Office 2010 requirements
SolvedHi, What are the requirements to install office 2010 on system?the minimum ram required? Please reply as fast as possible
Dell d505 booting password reset
SolvedHello, DELL MODEL D505 BIOS REV. A09 laptop show service tag #9R1ZM1J-595B PLEASE TELL ME IF ANYONE HAVE SOLUTION Dell Latitude Bios Password un...
I forgot my password
SolvedHello, could some one please help me i have a dell laptop inspiron 7500 and i cant log in i forgot my password can you help me ...
Pie chart comparison
SolvedHello, I have made a number of different pie charts & want to compare them with each other. Each pie chart is comparing the same thing but the ...
I forgot my login password for my compaq cq60
SolvedHello, i forgot my login password on my compaq CQ60 laptop, i just recently changed it and now i can't remember it. Can i please get a reply ASAP
How to do if statements in excel
SolvedHello, 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...
Summary sheet
SolvedHello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...
