Office Software Forum
- Excel (9,794)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
sum only numeric value Closed
Cell A1 Rs.100 A2 Rs.150 A3 Rs.160 Please tell me how I can sum only numeric value. Please tell me the formula. Regards, ...
-
how to calculate a alphabet Solved/Closed
Hello, for my workers I am mainaning attandance sheet and every month I have to send it to my head office. for their presents iam putting P and for ...
-
Memory Card Password Solved/Closed
Hello, Hello, i have a micro SD card for my phone2700 Classic NOKIA and its password protected and i forgot password i cant open it from my ...
-
micro sd card password lost Closed
Hello, i had a nokia 7210 supernova phone and i had put password to its micro sd card (1GB) bt nw i am using nokia 3110c phone but the same memory...
-
Excel linked to database Closed
Hello, i m working on a excel sheet which is linked to database ,which means whenever i refresh it gets updated.i have created a new column in tha...
-
Matching word phrases over different cells Solved/Closed
Hello, I receive batches of text and need to weed through the duplicates. I have figured out how to find exact matches like "Good Food"repeated t...
-
Excel Macro Help. Solved/Closed
Hi, I was wondering if someone could help me develop a macro that would reference a row in another worksheet. So for example if Column H = "x" in ...
-
Excel macro to identify/modify/combine cells Solved/Closed
Hello, I have a collection of survey results in Excel that are coded from another software that I need to prepare to put in SPSS, the results come...
-
formula of Greatest Common Divisor Closed
What is formula of Greatest Common Divisor in Excell 2003. Please reply me through mail. regards, Goutam Goswami
-
on the excel codes Closed
Hello, I have copied the code, but from tools i try to run and a msg "type mismatch" pops up..what next?thanks Configuration: Windows XP / Inte...
-
Excel help required Closed
Hello, I have data from A1 to A10 I want A1 in sheet2A1 A2 in shett2A2 ........ and so on will u please hel...
-
MS Excel 2007 Date format issue... Closed
Hello, I have an XL spreadsheet with abt 15k rows, with a variety of data, the important ones being the dates - a start date and an end date. Based...
-
Excel search macro Closed
Hello, I have a very tricky problem. I have got an excel sheet having some columns but more than 5000 rows. In those columns there are some names w...
-
Conditinal formattin Solved/Closed
Hello, If e1 cell is contains "closed" the entire row (or) a1:e1 should be highlighted in red color. Configuration: Windows XP / Internet Explo...
-
Excel macro for moving content Closed
Hello, I need a macro that will search for a specific set of values in a specific column for each row of a subset of rows. Example data can be ...
-
VBA code for a IF Function Closed
Hello, I need help on the following: Selecting a range on data e.g A1:A14 Searching for a certain value e.g 3000 if query is true then copy a ...
-
multi criteria conditional formatting Solved/Closed
Hello, I am trying to work out how to reference to cells for an if statement using conditonally formatting (through VBA), I have come up with the ...
-
adobe acrobat setup problems Closed
Hello, during the setup of adobe acrobat, an error telling me that it could not connect to the server comes up. how do i fix this or what am i doing...
-
Comparing Data Closed
Hello, I would like to look at two columns A and C and then if they match take the quantity in column D and insert it in Column B. So Column A ...
-
Excel Formula Closed
Hello, I have 1 Workbook with 2 sheets full of data, both sheets have identical data except for 2 Columns, DOB and Last name. I want a Formula on ...
-
Formulae Solved/Closed
Hello sir, your forumlae working fine, i would like to convert lakhs to paises please send .. Configuration: Windows XP / Internet Explo...
-
Macro to find Min value Closed
Hello, I need code for part of my macro that will find the min value in a particular column and based on the min value clear the contents in other ...
-
memory card password Closed
Hello, i am shirish, i hava loss my memory card password, so pl. tell me what is my password or solution. so pl. say any body to me how solve thi...
-
Select the cell that a button is in Solved/Closed
Hello, I want to run a macro using a button in Excel 2010 without regard as to the location of the current cell. In other words, when I click a...
-
how to copy data from one csv file Closed
Hello, I want to copy data from one CSV file to another CSV file using VBA. Please anyone help me in doing that. Thanks, Madan
-
Excel goal seek doesn't go through a macro Closed
Hello, I'm trying to use the goal seek function of excel to seek out a particular value of a cell (say Y) by changing values of another (say X). ...
-
Word Macro to insert rows to multiple tables Closed
Hello, Configuration: Mac OS X / Firefox 3.5.2 Using MS Word.. I have a few rows to be added to each table; and there are multiple tabl...
-
Trouble recognizing data in excel sheet Closed
Hi, Dear All, I asked some time back about a question on how to highlight thevalues etc that i entered in an excel file, and Mr. Trowa has...
-
installing office 2003 from a cd-rom. Closed
Hello, i have Hp-notebook, want to install office 2003 from a cd-rom, but no luck, i see the files, but it wont't setup.please help smillingking
-
code for firm which open excel sheet Closed
dear sir, I want to create a one firm from where i want to open my existing excel file , how can i do this. Please help me. May I use some code fo...
-
Excel Macro help Closed
Hello, I have an excel spreadsheet table (on one worskheet) that has several date rows in one column C, and one cell J12, for a permit number havi...
-
Copy rows of data from one sheet to another Closed
Hello, I have used the below code to copy selected rows ("x") of data from one worksheet ("QBank") to another ("TestSheet") within the same workbo...
-
VBA Excel Last Used Cell Closed
Hello, I am trying to copy a range of data I have in several columns in a worksheet into one column (all the columns have the same name: OrderID) ...
-
Compare values and conditions Closed
Hello and thanks in advance for any help. I need to do the following: three ranges in age: >45 between 46 and 55 45 and "values" = 75000 the ...
-
Password Reset Solved/Closed
Hello, I can't recall the password on my Toshiba C660/C660D laptop. On entering what I thought it was several times, it is now asking for a remov...
-
Color Column Range Based On Content In Cell Solved/Closed
Hello Sir, I want to know how to color the column based on content in fixed cell like. In Row No 6, If The Value Of Row 6 Is "Sun" Then Color T...
-
Outlook won't send Emails Solved/Closed
Hello, This is not a question, it is a statement. Outlook 2003 would not send emails through my ISP's smtp server. I probably spent 25 hours t...
-
memory card password forgotten Closed
Hello, Configuration: Windows XP / Internet Explorer 7.0 I have nokia 2700 classic with one gb memory card and I have forgotten my password a...
-
Need Excel Macro Closed
Hello, I need a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to search cell...
-
hiding a different sheet in workbook Solved/Closed
Dear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...
-
Report from Excel Data Sheet Solved/Closed
Dear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...
-
Forgot password Closed
Hello, this is naresh i have forgot the pass word of memory card.Please help me Configuration: Windows XP / Internet Explorer 6.0
-
I need help with an excel formula Closed
Hello, I have a spreadsheet that I am trying to find a average of one column with several rows that if another column with several rows contains a...
-
show a range off a drop down menu Solved/Closed
Hello, What I'm trying to do is make a drop down menu that when you pick an option from it, the column next to it changes to a list corresponding t...
-
Excel VB Macro Solved/Closed
Hello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...
-
Excel issue Closed
Hello, There are 3 tables, A, B and c, according to the requirement A = B + C. Need to check the value for B, where B = A - c. Table A contains p...
-
Please resolve my issue ofMS Excel file highl Closed
Deat Towa, http://www.speedyshare.com/... Please see the below mention link, What i want is, 1. Those bolt which are consumed completely s...
-
greater than or equal to Closed
Hello, here is the problem: IF(F4
-
Need Shortcut for full screen in excel Closed
Hello, Anyone give me the Keyboard shortcut to change excel sheet into full screen mode.
-
EXCEL MACROS; Clear, Compare and Replace! Closed
Hi, I need help creating three Excel macro subroutines.... This is for office 2003! The first one clears cells that do not contain "arg1"...