Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
Excel Macro - Set and Autofill a range? Solved/Closed
Hello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, etc.)...
-
cherry mobile Q3tv PhoneLock lost Password Solved/Closed
How Can I Recover my Password Please Really Need Replies
-
How to copy informations from Excel to EES Solved/Closed
Hello, I wanna know if anybody can help me to copy 2 columns (supply) from Excel to EES (another program if anyone used it before) and then copy the...
-
Removing apostrophe (') from the beginning Solved/Closed
Hello, I have an excel sheet where I have formulas with an apostrophe in the beginning. Example: '+34+54+56+22 '+34+222+224+556 '+92+922...
-
Excel 2007 Activex Option Button Default? Solved/Closed
Hello, I have two activex option buttons, Yes and No. How do I get it to display "No" as marked as a default? I have created a process that c...
-
convert Indian currency numeric to words Solved/Closed
Hello, I have one requirement where I need to convert Indian currency numeric to words. Like 100.90 it should convert to Hundred rupees and Ninety...
-
How to create a count down formula Solved/Closed
Hello all I'd be grateful if anyone could advise on a formula to highlight a cell which would change colour 30 days before the expiry date. I belie...
-
can not read pdf file Solved/Closed
i can not read pdf file plz help
-
copy entire data immediately when entered Solved/Closed
Hello, I have a spreadsheet in which I maintain sale records of a no. of polymers. For every polymer (For eg. Adflex Q 100 F), I have a table show...
-
Excel date formatting into another column Solved/Closed
Hello, I want to check using IF function in one column and change the date format to another column from MM/DD/YYYY to has DD/MM/YYYY in excel 2010....
-
Excel - transfer information from file Solved/Closed
Hi there! I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of informa...
-
Add when multiple criteria is met in rows Solved/Closed
Hello, I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in row B8...
-
forget my password of n2690 Solved/Closed
Hello, i forget my password of n2690. Plz suggest some ideas quickly. Configuration: / Opera 9.80
-
IF fuction Solved/Closed
Hello, I would like to right this formula =IF(d5677="Maromix","RESIN-1925",IF(D5677="Marble" or "onyx" or "matamix" or "decoration","RESIN-1600","...
-
Sumifs in Excel 2003 Solved/Closed
Sir I was using System with office 2010 and deriving some values by using "Sumifs" function. Now i am using Office 2003 system. When i copied the wo...
-
cannot access all office 2003 file Solved/Closed
Hello, after i scanned my computer with eset nod32 i cant open/copy/move the encrypted(green font color) ms office file such as excel and word. ...
-
Create new worksheet & copy the based on date Solved/Closed
Hello, Can any one help me to copy the excel sheet data from one sheet to another sheet? -> I have one excel sheet (name: Test.xls, sheet name: S...
-
Copy Worksheet to another Workbook (unopened) Solved/Closed
Hello, I want to copy a portion (A1:F54) of my current worksheet that I am working on, over to another workbook, that is not open. I want to use ...
-
Create Inquiry For Quotation Solved/Closed
Hello, I'm Mike, I'm a mechanical engineer, in my company we send inquiries for quotations. I have two Excel file the first is a table where all t...
-
Copy & Paste Data Upon Click Solved/Closed
Hello, Good day. I need some advices on how to copy and paste data upon mouse click. I have a set of data on A2 to A10. When I hit cell B1 wh...
-
Converting & then copying date format Solved/Closed
Hello, I wonder if anyone can help? I have a spreadsheet with over 40k records which have the date format & time format like this: 02/01/2003 09...
-
address of searched element Solved/Closed
Hello, hi help me pls... my question is --- A----- B---- c 1 as 2 ad 3 sd 4 dg 5 ki 6 we 7 rt 8 ty 9 ru my questio...
-
Using Text in 2 Fields in a Formula Solved/Closed
Hello, Those who read and attempt to think about the following, I definately do appreciate you taking your valuable time to help me out. I want...
-
Excel macro help needed to name ranges Solved/Closed
Hello, I have a 10 column x 500 row spreadsheet A1:J500 I would like to name ranges as follows: Range A1:J1 should be named with the content of...
-
Conditional Display of Existing Data Solved/Closed
Hello, Configuration: Windows XP / Firefox 11.0 I am trying to find a way to perform the following without Macro but met with much difficul...
-
excel related Solved/Closed
Hello, could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain colo...
-
Macro to create worksheets Solved/Closed
Hello, I'm Mike, I'm new to Macro excel I need a Macro that read from a table the name of projects and create for each project a sheet named th...
-
How to make 2 VBA codes to work correctly Solved/Closed
Hello, How can I correct the following 2 codes (which written in the same sheet) in order to work correctly, other wise it gives me Error (debug)?...
-
password forgot plz reset my password Solved/Closed
Hello, i have nokia 5130.my brother change password of my memory card.now he don't know password.now my memory card is locked.what i have to do...
-
Auto-copy of select rows to another worksheet Solved/Closed
Hello, This is my first time asking a question, so I will do my absolute best to follow and respect the forum guidelines and it's contributors. I...
-
i forgot my password (samsung e1120) Solved/Closed
Hello, i for my password I wish you could help me Configuration: Windows XP / Firefox 10.0.2
-
Correcting VBA code in Excel Solved/Closed
Hello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...
-
Highlight unique or duplicate on 2 sheets Solved/Closed
Hello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets...
-
Mircosoft office Help Solved/Closed
Hello, i would like to ask , if i change my gmail pw will my microsoft outlook still be able to recieve mails and sent them or they are not able to re...
-
Excel dynamically fill cell with data Solved/Closed
Hello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of dates ...
-
copy text frm a cell n append it thru macro Solved/Closed
Hello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the...
-
Column comparation in different datasheet Solved/Closed
Hello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list of n...
-
mass spectra for successful drawing Solved/Closed
Hello, I need a macro for solve a mass spectroscopy problem (mass spectrum). I have columns A and B (m/z numbers and abudances). How to fill column ...
-
VBA copy/paste cells then drop 1 row for next Solved/Closed
Hello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...
-
Conditional Formatting Question Solved/Closed
Hello, I am trying to create a formula for the following: If there is any text in cell A1, there is a border around cell B3. I know I need...
-
How to determine cell value in Excel column Solved/Closed
Hello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
-
Excel Macro Solved/Closed
Hello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...
-
open pdf file using command buttong in excel Solved/Closed
Hello, i have a form in excel which retrieves details of a user from one of the worksheet. against tht user row, there is a pdf file name which basic...
-
compare cell a1 to entire A col in sheet2 Solved/Closed
Hello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...
-
Excel problem Solved/Closed
Hello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...
-
Excel - copy data macro Solved/Closed
Hello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...
-
how to move data in rows to columns Solved/Closed
The data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this format 1 2 3 9 15 16 20 25 1 ...
-
If, then statement in Excel Solved/Closed
Hello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a dat...
-
Count Days Excluding Weekends Solved/Closed
Hello, I want to do a monthly report and I have four colums: "issue date" "pick date" "pack date" "Ship date", each cell have dates, I need a form...
-
Show value of row 1, where row 2 is greatest Solved/Closed
Hello, 0 1 2 3 4 5 6 7 8 9 10 0 2 5 6 5 1 3 1 0 0 0 1 4 2 4 5 4 2 1 0 0 0 0 4 6 5 1 5 0 1 0 0 1 1 0 5 8 5 3 1 0 0 0 0 in the t...