Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
Need password for dell D620 Solved/Closed
The origanal hard drive stopped working. I bought a new one and when I turn it on it asks me for a system or administator password. I have no idea. Sy...
-
find and replace cell value macro help pls Solved/Closed
Hello, i have these 20 formulas (1 per stock code) in my spreadsheet that come from etrade =PROStaticData(2, "mqg.ASX", "2010/08/10;2010/08...
-
READ:phone lock password for samsung gt-s5230 Solved/Closed
Hello, i have forgotten my phone lock password for my phone and I dont have a clue how im going to unlock it again... if you could help me I would b...
-
If one cell contains a name then?..HELP.HELP. Solved/Closed
Hello, I have a 2 columns in (Worksheet 1) . One with Names (A1) and the other with Numbers (B1) corresponding to the names. On (Worksheet 2) (C1...
-
Filtering problems Solved/Closed
Hello, I have a microsoft database access and I'm trying to filter some records. This is what I do: 1. I have a form for query purposes, in tha...
-
Macro: Watch a cell and copy if changed Solved/Closed
Hello, The problem in a nutshell is that I have 5 pivot tables on one worksheet, each with a field called "date" above the main text. Each day the...
-
Create a macro to format a column Solved/Closed
Greetings, I am not a programmer but I know how to create basic macros that would perform simple repeated tasks in a fixed range within a sheet. ...
-
Macro to delete duplicate items -Help please Solved/Closed
Hello, I'm trying to create a macro to delete the row that has a word at the biginnig and the same word at the end. Example: MIA/SFO/MIA ...
-
technics to unlock administrative passwords Solved/Closed
Hello, Can you help by showing me how to unlock a computers with an administrative passwords if theres no unlocking software? Configuration: Wi...
-
SUM with conditions but look at date Solved/Closed
Hello, I want to sum the conditions in a certain month. Say for June from the 1st to30th or July 1 to 31. The formula that is used without the date ...
-
Word - Print Preview vs page location Solved/Closed
Hello, I like to edit my documents in Print Preview, and at 100% zoom. However, when I do that the page is being displayed on the left hand side ...
-
Help to adjust this code slightly! Solved/Closed
Hello, I have this code, Sub IMPORT() Dim NextRow As Long Sheets("New & Renewals").Range("A4:D4").Copy NextRow = Sheets(...
-
to get password of G-five U-909 Solved/Closed
Hello, i have forgten my security or password of my mobile so how can I open the my mobile. please help me Configuration: Windows XP / Internet...
-
Textbox Date value max Solved/Closed
Hello, My english is not good so sorry in advance need to get the maximum and minimum value of date in excel userform . i m use these code ...
-
Formula Help Solved/Closed
Hello, I need a formula to calculate overtime. I have this spredsheet that tracks everyones time, a regular day is 8 hours, anything above that is...
-
forgotten its password Solved/Closed
Hello, Hello, i have21GB micro sd card & i have forgotten its password now it is blocked so help me in opening Configuration: Windows XP / ...
-
Excel, filling in cell values automatically Solved/Closed
Hello, I have two worksheets in Excel 2007 and am trying to automatically fill in cells in worksheet two based on values in the first worksheet. A...
-
text help in excel Solved/Closed
Hello, i need to get 2 text cells on sheet 1 to list in 1 cell on page 2 any help would be cool with me since i am new to this neet thing called e...
-
Lessthan or =,Greater than and Sum Solved/Closed
Hello, I have the following values in Excel 2007: A1(38)B1(26)C1(20)D1(80)E1(75)F1(50)G1(3) In H1 the formula =IF(AND(A1=C1,D1>E1,SUMPRODUCT(F1-G1)...
-
web cam problem Solved/Closed
Hello, web cam of my note book doesnt work where i have to download free driver for webcam Configuration: Windows 7 / Internet Explorer ...
-
one cell two formulas Solved/Closed
I have a cell that can change from "USD" to "PESO". When this cell is changed i need another cell to calculate appropriately. I have these two formula...
-
VLOOKUP in other worksheet (date) Solved/Closed
Hello, Attached please find the reference file. https://authentification.site/files/23765947/sort.xls I am doing a VLOOKUP from sheet 1 to she...
-
vlookup tool Solved/Closed
Hello, Configuration: Windows XP / Internet Explorer 8.0 I am using Excel2003.Plz let me know how can i use vlookup tool. Step by step met...
-
Help with Excel please Solved/Closed
Hi I have an excel spreadsheet with two columns in A is a list of codes, and in B a list of names containing the codes in a string A ...
-
copy entry from each worksheet to new sheet Solved/Closed
Hello friends, After reading some very useful suggestions. I thought of posting my problem, hoping i'll find a solution I have a workbook which...
-
My new computer does NOT recognize my printer Solved/Closed
Hello, I just bought a new computer with Wndows Vista. I have a HP Laserjet 1200 seires printer that my computer cannot seem to recognize. The pr...
-
administrator password in ragistray Solved/Closed
Hello, dear all pls tele mi wich location save the administrator password or user password in ragistry
-
Excel Absolute Reference? Solved/Closed
Hello, Configuration: Windows XP / Firefox 3.6.7 I have cells A1:A5 as "5, 10, 15, 20, 25" respectively. I want to make cells C1:G1, ref...
-
To find the max value + Solved/Closed
Hello, Hi need to get the maximum value for certain range of cells. and the value of the cell next to that max cell. can any one help ...
-
Browsers all stop. Router is fine. Solved/Closed
Hello, Recently, without installing any new software, my browsers all eventually stop. Firefox is my main, and would be the first to fall after abo...
-
data validation formula Solved/Closed
Hello, I have a spread sheet that tracks attendance. What i want to do is to alert the user whenever 3 OR MORE CELLS IN SEQUENCE CONTAIN THE SAME D...
-
Find last time text entered and return value Solved/Closed
Hello, I've got text in column D and a value for it in column G. I want to lookup/find the last time "Bolt 'was entered and return it's value.(the...
-
Copy and paste to other file. Solved/Closed
Hello, Can anyone tell me what's wrong with this code? I record it using macro.. Columns("G:M").Select Selection.Copy Workbooks.Open ...
-
VLOOKUP according to location not NAME Solved/Closed
Hello, i put the name of the files i want to perform in some cells and wrote a maco for excel to call up the file according to the location. (lets s...
-
Help with a conditional macro? Solved/Closed
Hello, I am trying to use VBA to check whether an M appears in column B and then, if it does, paste the information from that row (Columns A thr...
-
go to next page in word doc using VBA code Solved/Closed
Hello, Can any one tell me how go to next page in microsoft word doc using Excel Vba + macro code
-
Outlook connect to your incoming (POP3) Solved/Closed
Hello, At the time of setting my email account in indiatimes the following error showing sending & revived box.plz suggest Task 'umakanta200...
-
Copy rows until meet given line Solved/Closed
Hello, I'm trying to split one spreadsheet into several spreadsheets. The splitting has to be done when a certain value is found. I need to mo...
-
ms office 2003 product key Solved/Closed
Hello, i am rajesh i want to install the ms office 2003 but i have no product key please arrange the product key Configuration: Windows ...
-
forgot my corby password Solved/Closed
Hello, i had a password for phonebook and messages ..i reset the password anforgot..now how will i unlock it?? Configuration: Windows Vista / F...
-
Insert 2 rows, copy the formula.VBA HELP Pls Solved/Closed
Hello, I have a huge file to work on. Please help me with a VBA that does the following for the entire sheet (until the last row) 1) Whenever y...
-
Changing font colour Solved/Closed
Hi, I've looked at some posts on your site and followed the advice, however I can't get this to work. I'd like to change the font colour of a range ...
-
Do not count if date not entered Solved/Closed
Hello, I have a date in C3(30/06/2010) and sometimes a date in C4 (01/02/2010).In C5 i got a formula =((C3-C4)-I3)+1)*24. I3 will have the amount ...
-
found and paste Solved/Closed
Hello, i have two files, one is excel which contains few articles like 111230, 111412, 552136 etc and other file is notepad which contains hundreds o...
-
VBA macro-move to cell underneath the button Solved/Closed
Hello, I want my VBA macro to move to the cell 'underneath' the particular button that is being pressed. (I have a series of buttons down the page, e...
-
forgot my login password Solved/Closed
Hello, Configuration: Mac OS X / Safari 531.22.7i can not get in to my laptop it is a dell forgot my login password
-
Width & Merge Cells Solved/Closed
Hello, I Have 1 WorkSheet In Which There Are Too Many Sub Sheets. I Want The Width & Merge Cells Of Sheet1 In To All Sheets. But I Dont Need The ...
-
Matching 2 columns in Excel Solved/Closed
Hello, I've got 2 columns of data- I'm trying to see if there's a match between the data in Column A with Column B- if the data is in Column B somewhe...
-
How to convert a numeric value into English w Solved/Closed
Hello, How to convert a numeric value into English words in Excel plz show that formula regards Ravi
-
dell latitude d630 administrator pasword Solved/Closed
Hello, i have a laptop latitude d630 with an administrator pasword please help me. Configuration: Windows XP / Internet Explorer 6.0
