Office Software Forum - solved topics
- Excel (9,795)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
- Solved
-
Zeor to the end of 4 digit number Solved/Closed
Hello, Can someone tell me a formula or macro that will add a 0 Zero to the end of a 4 digit number in each cell. I get a excell file with the 4 di...
-
Excel frame a Do While Loop or macro Solved/Closed
Hi All, Could anyone help me to frame a Do While Loop or a suitable macro? I need a method to copy formulas present in Cells F10 to Q10 in She...
-
date formate Solved/Closed
Configuration: Windows XP / Internet Explorer 8.0 hi i have date formate in dd\mm\yyyy & dd-mm-yyyy. i need all the dates in same formate exp. ...
-
formula for dropdown list Solved/Closed
Configuration: Windows XP / Safari 532.5 n excel i want to use a drop lown list and when enter specified text, then next cell should display my spe...
-
Problem in date format Solved/Closed
Hi EVERY one I have very Big Problem i am making one report where two type of date format is appearing like MM-DD-YY 03-08-2010 and DD--...
-
I want the installation CD key of cod 5 Solved/Closed
i have the cd and i have lost the cd-cover and also lost the installation code,please help me.
-
Insert rows with data when criteria is met Solved/Closed
Hi, Thanks in advance for your help. I have two tables. If a field in table A is chosen, I want a macro which will insert rows of the data listed ...
-
Input a range of cells Solved/Closed
If i want to highlight a row of cells in red to show a lead is dead say A1 to E1, buy inputting "lose" in E1 I now have the formula =$A$1="lose" whi...
-
copy data next to a cell and paste it below Solved/Closed
Hi, everyone I am a newbie in here, and I hope some one can help me solve this: I having a data such as the following cell | A ...
-
Macro Assistance Solved/Closed
I have a spreadsheet that has data ranging from C3:C263. Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload' I need to...
-
convert a date figure into word in excel Solved/Closed
I want to know the formula, how can I convert a date figure into word in excel 2003
-
EXCEL MACRO TO REPEAT AND INSERT ROWS Solved/Closed
I am trying to write a macro that will insert rows as follows: Col 1 Col2 Col3 1 S 456 2 A 222 3 M ...
-
link question Solved/Closed
Using Excel 2003 - I have two tabs one has detail info for unit cost; the second has summery info for each unit. What I'd like to do is if you are on ...
-
Macro for array vlookup to worksheet Solved/Closed
Looking for help with a quick macro please. I have four tabs in the workbook: Datadump - contains daily raw data to clean Central - Accou...
-
Need help with excel message pop up Solved/Closed
I need Excel VB help to show a message pop up box to display whenever the value is below 10 or greater then 50 that's also not a multiple of 5 Con...
-
Updating Data in two+ worksheets Solved/Closed
I have a question, I just created a spreadsheet with 8 tables which contain a deferent data and with Autosum column on each table and I created als...
-
Conditional Formatting with 3 cell Solved/Closed
Hi all I want to do conditional formatting a cell but based on the criteria set by 2 other sells in the row so if A1 = 0 and B1 > 0 i want C1...
-
Link Data Solved/Closed
Dear Excel Expert, I need help. I need to manage my data with diffrent User different sheet & the data need to update every week in master sheet...
-
Range Change Colour Solved/Closed
Please help. If I have a range of Data in cells say A1 to E1 and I wish to change all to red when I enter the word "lose" in A1 only what do I need...
-
Extract date from a series of numbers Solved/Closed
Hi, I need to extract date from a series of numbers like 250420102356478 where 25(date)04(month)2010(year)2056478(sequence number) and answer sh...
-
pls help me with excel formula! Solved/Closed
Dear excel experts, I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 ...
-
finding the last row dynamically Solved/Closed
Hi, I am using VBA in Excel 2007. I have a worksheet which has multiple columns. Each column has different number of rows. I want to find the la...
-
Date formatting problem Solved/Closed
I have a date in a cell that is 23/10/2008, and shows up as this in the editing bar, but in the cell address it shows a figure, ie 39744. Why is this ...
-
vlookup formula Solved/Closed
Hi, Could you please anyone help me in this? (column headings : Roll No. , correction date , Type , code , rank , Marks , exam date , time ,...
-
Highlight a cell greater than the one above Solved/Closed
Hello, I am trying to use conditional formatting to highlight cells in a column (formatted as a table) that are greater than the number in the cell...
-
XCEL formula needed to return multiplication Solved/Closed
I need a formula that does the following: if b10 is => than 10.03 AND c10 is => than 6.69, then multiply b10 times 328 It seems simple, but I ...
-
Incentive Calculation with few Condition Solved/Closed
Hi, I need help... each month I need to calculate the incentive. manual calculation is wasting my time. i know excel can do it, but I am not ...
-
Product key Solved/Closed
Hello, I've trying to enter the product key so many times as behind my laptop. my lap is very new. i can't work with any software without this produc...
-
Sorting and deleting redundant value Solved/Closed
Hi, I have been trying to sort our patient data in our daily work-up in the lab as below: "sample external no" "barcode" "assay" 4 321456 amf ...
-
Conditional formatting Solved/Closed
can any one help me i have following situation and i drag the formula down , i do not want to show the result in c2 because there are no data in it(b...
-
excel formula! Solved/Closed
I would like to make an excel formula that if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "...
-
Selecting the required cells info from the co Solved/Closed
Hi, I have a data like below in one column in excel: SL#00000 Product: ABC Region Name: Name1 City :1 Country:1 User con: Id type SL#88888...
-
Conversion of values already present in cells Solved/Closed
Hi: I need to convert values already present in a range of cells to another currency. The current range changing causing headache. Any suggestions...
-
Copy Paste - Excel Solved/Closed
Hi I have a spreadsheet with a list of job titles in column A. there are a list of dates in columns G & I. there is information in all the ro...
-
Selecting a printer in an Excel 2007 Userform Solved/Closed
I am using the following code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show UserForm1.PrintForm End Sub I can...
-
Excel 2007 - Change cell color using If Solved/Closed
I have a cell with a % in it. I would like that cell color to change to red if the percentage is below 60%, and change to yellow if it is between 60% ...
-
Lookup data on different worksheets Solved/Closed
I have 2 spreadsheets with the same town names in column A and different dates in column N. I have a third spreadsheet with the town name and have ...
-
Excel find a value <>2#'s &get a value beside Solved/Closed
Hi All, I want to enter a number in cell A1 (Sheet 1) and have a formula which gets excel to go to sheet 2 column A finds the two numbers the e...
-
EXCEL FORMULA FOR FINDING PERCENTAGE OF Solved/Closed
Hello, I need a simple formaul for finding the percentage of Total number of members: answer in column A392 Total number of members who have prov...
-
unlock memory card password Solved/Closed
hey i forgot my memory card password n cudnt find ny file manager optin in my nikia 7210.pls help!!! Configuration: Windows 7 / Internet Explorer 8.0
-
IF statement thats Adds Solved/Closed
Dear All, I would like to create an If statement which returns a 1 if a cell is greater than 0, then look at the next cell and do the same. Then ad...
-
conditional hide rows in multiple sheets Solved/Closed
It didn't solved yet. I have one excel file with multiple sheets, and all of them with the same columns and rows . I need to hide specific rows in ...
-
how to copy entire row (URGENT) Solved/Closed
Hi people. i am doing on some assignment for school. I have created a userform with a search button embedded on one worksheet, lets call it SE...
-
How to display formula in excel? Solved/Closed
hi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the form...
-
Excel Skipping a cell when calculating a tota Solved/Closed
i have a series of codes back and forth it seems a bit insane. but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the fo...
-
PPS ATTACHMENTS Solved/Closed
Hello, I tried finding the place under tool/options to untick but I didn't find it. I have OUTLOOK EXPRESS 6 and recently had to reformat computer. ...
-
tabs dont show Solved/Closed
Hiya, some of the tabs are missing from my microsoft word e.g. view, format, dunno what to do. HELP
-
Compare cell against multiple columns Solved/Closed
Configuration: Windows XP / Safari 532.5 Hopefully I can explain this as simply as possible. First here is what my spreadsheet looks like I have sepe...
-
Excel - Run Macro on Cell Change Solved/Closed
I am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I...
-
VBA Code For Excel .......................... Solved/Closed
Dear Expert, Below written VBA code is being used by me to insert jpg picture in the excel file against the code number and its working very well a...