The discussions
Excel help
SolvedHello, I have an excel worksheet with cells filled with strings of text like this... CAS [354-24-5], 99% I'd like to search a vertical c...
More than 3 conditional formats in excel
SolvedHello, I am working with an Excel spreadsheet, and need the cell background in one column to change to red if its value is within a range of numbers...
Conditional formatting before color sorting!
SolvedHello, I used conditonal formatting to select and color some data, and now i want to apply color sorting to rearrange the data. However, it seems...
Excel 2003 - change row colour with vba
SolvedHi, hope somebody can help I've got a spreadsheet when I need to change the row colour dependent on the data entered into a particular cell. The...
Text match between two column
SolvedHello, I have an Excel spreadsheet where I want to compare "Text" between two columns and return the value to the next column say "Match" or "Not Ma...
Adding pdf files to iphone
Solved/ClosedHello, I am new to using an Apple I phone. I am trying to send a pdf. doc to the iphone from my Windows Home XP laptop. Is this possible and how...
Import webpage data into excel spreadsheet
Solved/ClosedHello, I am attempting to import the web page data from "http://bet1.hkjc.com/racing/pages/odds_wp.aspx?date=19-10-2008&venue=HV&raceno=1&lang=en" th...
Open excel file into worksheet of open workbk
SolvedHello, MS Excel 2000, VBA I'd like to be able to open a file directly into a new worksheet of an open workbook, thus adding the new sheet in the...
Excel formula
SolvedHello, I need a formula to accomplish the following. 5 + years => 15 10 + years => 20 15 + years => 25 20 + years => 30 eg. say I was h...
Multiple criteria sums
SolvedHello, I was hoping somebody could help me do this? A B C INC-001 05/2009 10 INC-002 07/2010 10 CTN-000 05/2009 10 ...
Master password
SolvedHello, I need master password for dell inspirion 1525 service tag #CY14ZG1-595B Configuration: Windows 7 / Internet Explorer 8.0
Ytd cost
SolvedHello, I need your help developin this formula please. I have a spredsheet listing the different contracts my department has and their values. ...
Ipod (touch my apps working! help?! please(:
SolvedHey, I'm trying to download apps onto my ipod (Touch) But i need to download the update 4.0 but every time i try this it comes up with an error and ...
Highlight a cell in a specific row
SolvedHello, I would like to know if anyone knows how to write a Visual Basic script that I could run that will highlight the cell(s) in a color if they...
Office 2008
SolvedHello, I installed Office 2008 for Mac. I needed to uninistall it and re-install under a different product key. The computer remembers the ke...
#n/a
SolvedHi, can anyone help. I have an Excel spreadsheet with a "Final page" which has the accumulation of several other sheets and formulae in a table. For e...
Shade the last 3 days in color .. help!
SolvedHello, I have got a range of date in one column, which i want to shade the last 3 days in blue and the rest in yellow. e.g. If the date is from ...
My new computer will not recognize my printer
SolvedHello, My new laptop with a windows 7 64 bit will not recognize my HP photosmart all in one C6180 printer . How do I solve this issue. Raul ...
Formula to replace "#n/a" with 0
SolvedHello, I have a worksheet that references another sheet and pulls in a date and a transaction amount (simplified). Sometimes the results of my cell...
Cant find my 25 key product code! help!
SolvedHello, I'm 14 and my computer was given to me by my parents 6 yrs ago. I don't have the 25 key product code and my microsoft docs can't be opened...
Combobox not filtering well
SolvedHi everyone, I really need your help, I was trying by myself to finish my code, but I have more than 5 days trying to figure it out and so far noth...
Match colums from sheets
SolvedHello, I have two sheets - S1 and S2. In S1 are colums A and B. In S2 are columns B and C. I want to join columns A and C using colums B (which is...
Shade the rows for different working days
SolvedHello, I need a VBA code that allow me to shade the row color in blue when the date in a cell is performed in the last 3 days of working days . Othe...
Combine columns in excel
SolvedHello, i have got two sheets of data and i have arranged them into ideal orders. Now i want to place data on sheet 2 behind data on sheet 1.( in the...
Putting a picture in a table (word 97)
SolvedHello, I'm using Word 97. I'm writing some instructions, using a table to format them, step, by step. I want to put an image in one of the steps ...
Problem with dates in excel 2004 mac
SolvedHello, I'm working in MAC OSX MS Office 2004 11.5.3 (081114) I have two workbooks opened at the same time. I copied 54K+ rows of data from o...
Macro to copy a certain cell onto another row
SolvedI'm trying to copy values from one cell to another excel via use of a macro, where E#99999 is the employee number to be put to column A until it reach...
Admin password lost
SolvedHello, i can only get on a users account. the password for admin does not work. i cant download any programs on the computer. this sucks. and all the...
Custom function
SolvedHello, wud appreciate help on me building a custom function...i've written a function which shud do the following function in sheet A will get em...
Can't change file association in outlook expr
SolvedHello, I'm running XP Media Center SP3. I recently installed a trial version of Adobe Acrobat 9 Pro (9.3.3). I changed my file association ...
Formula results
SolvedHello, can I show fomula results in next cell Configuration: Windows XP / Internet Explorer 8.0
Conditional formatting of a column of cells
SolvedHello, I am working on a task list/project sheet and I am trying to set a conditional format for a column of cells that is based on two (technical...
Problem moving records to another worksheet
SolvedHello eberybody I have a doubt, I know how to move records from one sheet to another, as this: Worksheets("Sheet1").Range("A" & i + 2).Resize(1,...
Auto fille cell based on different cell value
SolvedHello, I wanted to know if I might be able to solicit for some help on a problem I'm looking to resolve. Currently I use a Excel 2007 spre...
Transfer records to another worksheet
SolvedHello, I have tried everything to move these records to a sheet called "Data" , but I wasn't able to get any good results. what I have been trying...
Formula to copy 1 cell by number in another
SolvedI have a spread sheet with text and numbers in a1 to c1 and then in d1 is a number that i need it copy and pasted by E.G Hello ...
Extracting date from a series of numbers
SolvedHello, I need to extract "date" exsiting in a specific space in a series of numbers and get it in another cell. I don't want to split the series us...
Extra cells removal. excel
SolvedHello, Does anyone know how to hide unused cells in excel? I have got a program that does all the matching for me, but everytime when i finished ...
Link cell to another worksheet
Solvedhi there, What i want to do is to link a worksheet to another worksheet. Like, when I type data on cell in sheet1... then, same data will auto...
Extract a specific word from cells and count
SolvedHello, I want to find the formula in Excel 2003 to be able to extract a specific word from a cell and count the number of instances this word ...
How to select the sheet name from ddm
SolvedHello, I want to select which sheet to store data from the drop down menu. thank you . Private Sub UserForm_Initialize() Dim i As Integer Fo...
Compare columns containing dates
SolvedHello, I have the dates and the close prices of 5 indices in 10 columns. I want to compare the 5 columns containing the dates in order to get the c...
Forgot password of windows vista buisness
SolvedHello, i forgot the password of windows vista buisness. I cannot open the administration one please help. Configuration: / Mozilla Indetermin...
Remove records once they are transfered
SolvedHi, You help me out with the next code. what I want to do is to clear the records from the sheet query once they are transferd to the new sheet so...
Change row color if value in a cell
SolvedHello, I've tried so many variations and cant get it right. All I want is an entire row (A:H) to be highlighted yellow if there is ANYthing enter...
One cell calculation excel - time interval
SolvedHello, I need to calculate the elapsed time in hours if the start time and end time are contained in the same cell. Example: If A1 contain...
Dell latitude c400 password -595b
SolvedHello, Lost my master password on Dell Latitude C400 laptop. Tried to unplug battery, but still need password. Any who can fix the password. ...
Excel : different criteria for excel to look
SolvedHello, Please could anyone help? Attached please find the example. https://authentification.site/files/23122635/nono.xls The sheet (Say in doc...