The discussions

Cells display a total or text

 Solved

Hello, I have an excel workbook that has cells that display a currency amount U43, U45, U47, U49, U51 and Q53. For example U43 would have $200 in...

2 replies Last reply on 11 Nov 2011 by
Michael

Outlook 2007 email randomly not sent

 Solved

Hello, the problem started a few days ago. Randomly Outlook 2007 does not send a message. Looks like it is mostly when I reply to another email. I...

3 replies Last reply on 10 Nov 2011 by
tuscanguy

Conditional format more then 3

 Solved

Hello, I have seen a solution on your web from aquarelle, but how do i put that in my excel, sorry maybe its a basic question. But i have tried i...

2 replies Last reply on 10 Nov 2011 by
gaggie

Excel transfer selected rows

 Solved

Hello, I have in place a data validation,''list''. I want to be able to transfer selected rows with the different list names into separate worksh...

12 replies Last reply on 8 Nov 2011 by
Julz

Excel data validation

 Solved

Hello, I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues. Column b is 'Transaction Type' and I want to pro...

2 replies Last reply on 3 Nov 2011 by
Excel List

Vlook up fails!

 Solved

Hello, this is the code that i have: =VLOOKUP(C2,'sport'!I:L,1,FALSE) Where C2 can be varied, depends on user input. the column containin...

1 reply Last reply on 30 Oct 2011 by
venkat1926

Vb excel 2010 - loop until can't find

 Solved

Hello, We are trying to manipulate data from a very old DOS program. We have a lengthy macro that works well until the end where it seaches for s...

25 replies Last reply on 26 Oct 2011 by
whitepanther

Excel: locate value in one list & copy

 Solved

Hello, I need some help with Exel. I have two lists: List one contains two coulmns: ID numbers and age. List two contains also two coulms: ID ...

3 replies Last reply on 26 Oct 2011 by
Brad

Copy if condition range is met

 Solved

hey guys i tried hard, altered other peoples codes but i cant figure it out for the life of me all im trying to do is copy from sheet to anot...

4 replies Last reply on 26 Oct 2011 by
raaz

Data reshuffling of cells

 Solved

Hello, Dear Friends, I need your help to solve the following problem. I have few files containing data of more than 50,000 records. Some rec...

3 replies Last reply on 25 Oct 2011 by
Aslam

Find word within certain lookup reference

 Solved

Hello, I need help to solve this problem. Example : Cell A1 : "cost of electricity" Cell B1 : "$100" Cell A2 : "telephone charges" Cell B2 :...

6 replies Last reply on 25 Oct 2011 by
gadir_arfan

Combining values using if/then search

 Solved

Hello, I am trying to combine two worksheets that have some similar data points but not all. Example: Sheet 1 has columns: Name, Age, Class She...

2 replies Last reply on 21 Oct 2011 by
mike

How to make more color

 Solved

Hello, all expert, I am using the Excel 2003 worksheet to make a project. But due to the limintation for the conditional formatting for the color ...

1 reply Last reply on 21 Oct 2011 by
rizvisa1

Copy and paste/transpose each row by n times

 Solved

Hello, To get my data in to an Enterprise program, I need to have my data like the following: Col A Col B Col C Bank A 2010 1 Bank A...

4 replies Last reply on 21 Oct 2011 by
venkat1926

Change adobe reader from default application

 Solved

Hello, How do I change my settings so that Adobe Reader is NOT the default application used when downloading a JPEG image? Everytime is save a JP...

3 replies Last reply on 19 Oct 2011 by
Anonymous User

Excel macro copy to cell based on criteria

 Solved

hey everyone, I'm stuck. I hope someone can help me out today. I have an excel spreadsheet with 1400 rows. The first 3 rows are irrelevant (headi...

6 replies Last reply on 15 Oct 2011 by
rizvisa1

Excel vb script to notify/popup

 Solved

Hello, I want to have different cells in the worksheet have pop up messages/notifications when the date or deadline is reached. so when the 1 june 2...

12 replies Last reply on 15 Oct 2011 by
rizvisa1

How to match the 1st left word on diff sheet

 Solved

Hello, I'm trying to match the exact first words from sheet 1 to sheet 2. (like the way we get the match for Vlookup formula) I have a file which...

5 replies Last reply on 14 Oct 2011 by
cheryl

Ms office problem

 Solved

Hello, i am still using 2007 office but my some excel files in 2003 office format so pls suggested me now how to opned my old file in 2007 offic...

2 replies Last reply on 13 Oct 2011 by
Anonymous User

Yes or no return on a comparison of two colum

 Solved

Hello, Column A contains 80 cells with numbers such as this, not in sequential order: 3-1705578711 Column B contains 50 cells with numbers simila...

2 replies Last reply on 12 Oct 2011 by
Fooberry

Excel macro for deleting rows if cells not...

 Solved

Hello, I need help to create a Excel macro. Basicly what I have is a sheet full with information about different departments and what I want to do...

11 replies Last reply on 12 Oct 2011 by
Jo

Ms word 2007 field codes are shown

 Solved

Hello, I'm working on a long word document and all of a sudden field codes are displayed instead of references, page numbers etc. I followed what s...

8 replies Last reply on 12 Oct 2011 by
PhD Panic

If a1 contains the a word, then show b2 in c2

 Solved

Hello, I'm trying to create a formula to display the contents of B2 in C2 if cell A2 has a certain word. ex. =IF(ISNUMBER(SEARCH("BACH",B13)),"=C1...

1 reply Last reply on 11 Oct 2011 by
help

Excel - select last 25 records

 Solved

Hi I have a spreadsheet that is entered into daily a list of actions taken in a department. This needs to be printed weekly and displayed. Obviously t...

1 reply Last reply on 10 Oct 2011 by
TrowaD

Excel - removing different rows in 2 sheets

 Solved

Hello, I have two worksheets containing a different number of rows. I want to delete all rows in sheet 1 that have a value in column A that c...

4 replies Last reply on 10 Oct 2011 by
venkat1926

Compare columns and copy

 Solved

Hello, I need a Macro to do next : i have 2 sheets Sheet1 and Sheet2. In Sheet1 column A has a variable range of values i.e. A2 : A... Column B is e...

2 replies Last reply on 9 Oct 2011 by
danparaianu

Creation of dropdown from dynamic list in vba

 Solved

Hello, I have been trying to make a Macro that can create a dropdown list from a dynamic list in column A. So far I've come up with the followin...

3 replies Last reply on 7 Oct 2011 by
Kasper

Avg multiple cells in multiple sheets - excel

 Solved

Hello, I need to average multiple cells across multiple sheets, but not all are in the same column/number. I need to average B35,D35,F35 in Sheet 1...

2 replies Last reply on 6 Oct 2011 by
FarmersDaughter1680

Macro to insert data to changing cells

 Solved

Hello, I'm trying to write a macro in excel for inserting input text to a specified cell. I have already an InputBox specifying the text to be put...

2 replies Last reply on 5 Oct 2011 by
Kasper

Excel merge text files

 Solved

Dear Forum Members, As I am not a VB expert I have copied some codes and edited to suit for my purpose. My idea is to combine many .pyc files in a f...

8 replies Last reply on 4 Oct 2011 by
madambath

How to remove powor on password of my g five

 Solved

Hello, How to remove powor on password of my g five mobile,plz help me. Configuration: Windows XP / Internet Explorer 8.0

1 reply Last reply on 1 Oct 2011 by
Ambucias

Compare two excel columns of differant size

 Solved

Hello, i am having two excel columns of differant size..Both the columns contain mobile numbers..i have columns A containing all the mobile numbe...

6 replies Last reply on 30 Sep 2011 by
rizvisa1

Copy paste rows in excel across worksheets

 Solved

Hello, I'm trying to create an excel macro that will copy a sequence of rows from 2 different worksheets and paste them in a third worksheet using t...

3 replies Last reply on 28 Sep 2011 by
rizvisa1

Word files converted into pdf, cannot be open

 Solved

Hi, Many of my word files have converted into PDF file. On the other hand those files cannot be opened /viewed. What can I do now to convert those fi...

2 replies Last reply on 28 Sep 2011 by
Anonymous User

Excel if formula text vs numbers

 Solved

Hello, I am trying to run an If formula that if the cell range contain text then use Counta but if cells contain number use Sum. At present I'm us...

2 replies Last reply on 25 Sep 2011 by
NW

Seach for all worksheet and copy the name

 Solved

Hello, I'm trying to see if anyone can help me with this, I do have a master excel file that get info from other excel files, currently I have to d...

8 replies Last reply on 23 Sep 2011 by
rizvisa1

Ms excel 2007 - quick function question

 Solved

Hi Guys, So say you have 3 cells. A, B, and C. I'm trying to come up with a function to put in C that erases/blanks A if B is #N/A (IsError?). Can ...

2 replies Last reply on 23 Sep 2011 by
rizvisa1

I have forgoten password of my samsung i900

 Solved

Hello, i have forgoten password of my samsung omnia i900. it is a windows mobile6.1 .please help me. please help me to open it .. god may help ...

1 reply Last reply on 13 Sep 2011 by
bionik

Complicated table question.

 Solved

Hello, I have just started a new job and i was asked to do the following. Please help me as I dont know how to do it. System ID Clien...

1 reply Last reply on 13 Sep 2011 by
TrowaD

Copy and paste certain columns based on dates

 Solved

Hello, I am trying to create a macro that will look at a list of dates in column B then copy and paste the data in column C and D to another sheet...

5 replies Last reply on 13 Sep 2011 by
jones835

Searching for a word in table

 Solved

Hello, In excel, I have 5 columns of words (5 undividual word lists) and a row at the top that gives information on that word list. I want to use a ...

2 replies Last reply on 8 Sep 2011 by
TrowaD

Mobile tracker password forgot

 Solved/Closed

Hello, i reset the mobile tracker password and forgot the password, I kindly request you to suggest me a solution to reset the password for the Samsu...

1 reply Last reply on 4 Sep 2011 by
Ambucias

Auto filter depend in droplist value

 Solved

Hello, I'm wondering if anyone knows some formula to filter data depend in dropdown list My spreadsheet has a column with the order status ...

1 reply Last reply on 29 Aug 2011 by
venkat1926

Why doesn't this simple vb code work?

 Solved

Hello, What I want to do is the following: When a cell in column AH is selected move to the next sheet and select the cell in column C same row. ...

6 replies Last reply on 23 Aug 2011 by
TrowaD

Hide columns

 Solved

Hello, I recorded a macro to hide some columns (says, column M to O). However, when I tried to run the macro again, the macro hide all the columns f...

1 reply Last reply on 23 Aug 2011 by
venkat1926

Forgot my phone password

 Solved

Hello, i forgot ma phone password......n nw i cant put a new pass word wat sud i do plz help me..... Configuration: Windows 7 / Safari 535.1

1 reply Last reply on 23 Aug 2011 by
bionik

How to find a number from the list

 Solved

Can u please help me in writing a macro in excel as below: 1) When we click on the command button, it should prompt for entering the number in the ...

13 replies Last reply on 19 Aug 2011 by
rizvisa1

Vb code for drop-list menu width

 Solved

Hello, If any one can help me. In one excel sheet I made list of names and defined that list as "Names", then in another excel sheet in column ...

7 replies Last reply on 19 Aug 2011 by
rizvisa1

Hide unhide column with clickbox and password

 Solved

Hello, All Please can you help, is there a way that you can hide/unhide colmns with a click box, I have the code to group ungroup when the sheet a...

5 replies Last reply on 19 Aug 2011 by
rizvisa1

Copying a row based on part of a field

 Solved

Hello, I am trying to get an excel macro to do a search of Sheet1 that will go through each row in column E and copy any row that contains a X or ...

1 reply Last reply on 18 Aug 2011 by
TrowaD
Results 1551 - 1600 out of a total of 2,603