Office Software Forum - solved topics
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
- Solved
-
Excel - Copy rows "n" times with calculation Solved/Closed
I need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col C for e.g. C2 may have the number 5 in it. I need to...
-
EXCEL Solved/Closed
hi i always make our employee salary in excel. this file is very big. every month I have to put only OVER TIME,WORKING DAY and ABSENT...and i make all...
-
Can a macro add a number? Solved/Closed
I am working on a excel project where I will be able to click a button and the result would be a number added on another cell. For example, counting a...
-
copy columns one below another Solved/Closed
Configuration: Windows XP / Internet Explorer 7.0 hi i have data in the following form a b c d 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 1...
-
Combining 2 cells to 1 Solved/Closed
Hi, I have data like below in two column of excel sheet: 1-Jan | 2004 23-Jul| 2004 12-Feb|2003 ................ ......... Out out require...
-
help excel: click & automatically copy paste Solved/Closed
I need some help Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: popula...
-
Search and Replace macro for microsoft excel Solved/Closed
I have two workbooks with identical setup. item name address 1 address 2 address 3 x 12 34...
-
Click a Cell and insert a wingding Solved/Closed
In excel I am wanting to be able to click a cell to insert a Selected wingding from a list. But to also beable to click the cell a second time to cha...
-
Add cells with other identical attributes Solved/Closed
I'm looking to create a formula which can be copied into other cells that will add numbers in one column, where their attributes in another column are...
-
Line to reflect a Dash if no value Solved/Closed
I am designing a check book registry, and I want the total column to reflect a - if there is no value from the formula. I had it this way in the past...
-
Help with Excel data selection Solved/Closed
I would like to take a worksheet and create new worksheets for each specific value in a column. for example, one of my columns is "customer". I want...
-
Excel 2007 VBA Find Last Solved/Closed
I have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a c...
-
Macro to Find a info in more than one column Solved/Closed
Hi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [t...
-
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 ...