The discussions
Excel frame a do while loop or macro
SolvedHi 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
SolvedConfiguration: 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
SolvedConfiguration: 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
SolvedHi 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
Solvedi 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
SolvedHi, 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
SolvedIf 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
SolvedHi, 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
SolvedI 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/ClosedI want to know the formula, how can I convert a date figure into word in excel 2003
Excel macro to repeat and insert rows
SolvedI 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
SolvedUsing 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
SolvedLooking 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
SolvedI 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
SolvedI 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
SolvedHi 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
SolvedDear 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
SolvedPlease 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
SolvedHi, 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!
SolvedDear 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
SolvedHi, 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
SolvedI 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
SolvedHi, 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
SolvedHello, 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
SolvedI 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
SolvedHi, 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/ClosedHello, 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
SolvedHi, 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
Solvedcan 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!
SolvedI 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
SolvedHi, 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
SolvedHi: 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
SolvedHi 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
SolvedI 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
SolvedI 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
SolvedI 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/ClosedHi 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/ClosedHello, 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
Solvedhey 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
SolvedDear 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
SolvedIt 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)
SolvedHi 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?
Solvedhi 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
Solvedi 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
SolvedHello, 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
SolvedHiya, some of the tabs are missing from my microsoft word e.g. view, format, dunno what to do. HELP
Compare cell against multiple columns
SolvedConfiguration: 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
SolvedI 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 ..........................
SolvedDear 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...