Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
- Solved
-
coloring the last 3 dates in a range of date Solved/Closed
Hello, In my last post, i mentioned about coloring the last 3 dates in a range of date in blue, and the rest in yellow. I used this code as to do t...
-
memory card password Solved/Closed
Hello, i forgot my memory card password, i format it twice now i am battling for getting password. Configuration: Windows 7 / Safari 533.4
-
display the last cell used in another cell Solved/Closed
Hello, In a range of cells A1: A20 i want to show the data in the last cell used in cell A25. So it would look something loke tis 1 2 2 5 ...
-
Find row after look up matching strings from Solved/Closed
Hello Experts, I am looking for a way to find strings from in and put a flag (XXX) next cells. Your help is greatly appreciated. Monkey ha...
-
Unlock Cmos Password Dell Inspiron 1440 Solved/Closed
Hello, Plz, I need help how to unlock cmos password service tag: JL5XKJ1-595B thank you>
-
How to speed up my code Solved/Closed
Hello, Let me start by posting my workbook: https://authentification.site/files/23489429/Copy_of_PostPlanning.xls When you go to sheet "Alle o...
-
Excel help Solved/Closed
Hello, 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 Solved/Closed
Hello, 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! Solved/Closed
Hello, 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 Solved/Closed
Hi, 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...
-
PHONE LOCK PASSWORD Solved/Closed
Hello, PLZ TELL ME MY PHONE YXTEL (X71I ) PHONE LOCK CODE NO....
-
Text match between two column Solved/Closed
Hello, 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/Closed
Hello, 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/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, I need master password for dell inspirion 1525 service tag #CY14ZG1-595B Configuration: Windows 7 / Internet Explorer 8.0
-
YTD Cost Solved/Closed
Hello, 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(: Solved/Closed
Hey, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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! Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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! Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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) Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
I'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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, can I show fomula results in next cell Configuration: Windows XP / Internet Explorer 8.0
-
Conditional formatting of a column of cells Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
I 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, i forgot the password of windows vista buisness. I cannot open the administration one please help. Configuration: / Mozilla Indetermin...