The discussions

Inserting/copy rows, transpose vba help

 Solved

Hello, I have searched through many posts and it appeard everyone is very helpful. My skills in vba are ok but i lack the knowledge to solve my prob...

9 replies Last reply on 23 Jun 2011 by
shameem007

Merge rows if it meets criteria in excel

 Solved

Hello, I would like to know if I can merge rows if it meets certain criteria in Excel. If Project ID on column A is matched, it will merge all the ...

6 replies Last reply on 21 Jun 2011 by
rizvisa1

Conditionally deleting rows in excel 2007

 Solved

Hello, I'm hoping someone here might be able to help me with this. I have a spreadsheet where column A is a project name then columns B, C and D a...

5 replies Last reply on 20 Jun 2011 by
aquarelle

Returning value if criteria falls w/i range

 Solved

Hello, I am trying to create a spreadsheet that will lookup and return the value from column C, when the given criteria falls between columns A an...

3 replies Last reply on 17 Jun 2011 by
rizvisa1

Webpage to excel

 Solved

Hello, Could you please help me in downloading data's from a web page to an excel. If that web page has multiple pages ( 1,2,3,4.... ), i want all ...

1 reply Last reply on 17 Jun 2011 by
TrowaD

Conditional formatting issue

 Solved

Hello, I'm using Excel 2007 I want my cell in F2 to be formatted conditionally to A1 being >250 and

1 reply Last reply on 17 Jun 2011 by
TrowaD

Find text string in one column and replace

 Solved

Hello, I need a macro to compare two columns, only if particular texts in column C, text in adjacent row of column D should be changed. Text in ot...

13 replies Last reply on 15 Jun 2011 by
PMARI

Exel run time error 13

 Solved

Hi All, Please can you trie and help, I have a error message in my code. The error message comes in at this line. If cell.Value = 4 And cell....

3 replies Last reply on 14 Jun 2011 by
rizvisa1

Formula: to count cells and then add number.

 Solved

Hello, All Hope you can help! I have a list of actions 1 Contacts 2 Appointments 3 Estimates 4 Sales contacts counts as 1 contact,...

3 replies Last reply on 14 Jun 2011 by
rizvisa1

Forgett password

 Solved

Hello, I forgot my phone lock code (password)* on my Samsung S3650 Corby, and now i can't enter my phone. *I changed the phone lock (passwor...

1 reply Last reply on 14 Jun 2011 by
bionik

Needed a vba.

 Solved

Hello, I'm very new to progamming kind of stuff... i need to generate a report from a excel sheet. Coloumn Q of "data" sheet has only 0 or 1, whi...

6 replies Last reply on 13 Jun 2011 by
rizvisa1

I forgot my mobile password s3310i

 Solved

Hello, hi i have samsung 3310i mobile i forgot my password plz tell me the solution this my new mobile plz Configuration: Windows 7 / Safari 53...

1 reply Last reply on 10 Jun 2011 by
bionik

Mobile password forgot

 Solved

Hello, i have nokia5130c2. i have forgot mobile password so i can't restore factory setting...plz solve my problem.

1 reply Last reply on 10 Jun 2011 by
pcsces

Excel "if" for letters to equal values

 Solved

Hello, I have a yes or no sheet, one column for yes and one column for no. I want the end column to calculate a 1 for yes, and 0 for no, and in s...

1 reply Last reply on 9 Jun 2011 by
TrowaD

Conditional formula

 Solved

Hello, Hi everyone, Just want to seek for your help about some conditional formula about excel. I just want to create program about our inven...

4 replies Last reply on 9 Jun 2011 by
RWomanizer

Word settings

 Solved

Hello, I change some of my settings when I went to word options on my vista word document, now when i open a blank document it is full of grid square...

8 replies Last reply on 6 Jun 2011 by
lucky PTY

Text function does not change date format

 Solved

Hello, I'm using the CONCATENATE function to put together a sentence mixing text and date. The formula I'm using is: =CONCATENATE("Text part he...

1 reply Last reply on 6 Jun 2011 by
TrowaD

Simple excel formula help

 Solved

Hello, Configuration: Windows 7 / Firefox 3.6.17 Hey guys I'm doing some project on Excel for a class. When it comes to entering and crea...

1 reply Last reply on 6 Jun 2011 by
TrowaD

Forgot my admin password on my old dell 630c

 Solved

Hello, i forgot my admin password on my old dell 630c can you help me reset or delete the password so my laptop will boot up>? windows vista/os i...

1 reply Last reply on 4 Jun 2011 by
bionik

Msgbox retry/cancel buttons are confusing me

 Solved

Hello, I can't figure out what's wrong with my code. Hopefully someone can enlighten me. Here is the code I'm using: Dim x As Integer Sub Adj...

9 replies Last reply on 3 Jun 2011 by
TrowaD

Excel name match query

 Solved

Hi I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list o...

5 replies Last reply on 1 Jun 2011 by
Guest user

Split data into multiple sheets using macro

 Solved

Hello, Configuration: Windows Vista / Firefox 4.0 I have an excel sheet with the data in following manner. a b c d 1 1 1 1 2 2 2 2 3 ...

16 replies Last reply on 31 May 2011 by
rizvisa1

If function error !!!

 Solved

Hello, I have created a time tracker worksheet for my process. Am just stuck up with one function. I have used the below function which has 8 ...

38 replies Last reply on 30 May 2011 by
Waseem

How to calculate a alphabet

 Solved

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 ...

12 replies Last reply on 30 May 2011 by
Hilda

Memory card password

 Solved

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 ...

2 replies Last reply on 29 May 2011 by
shareek

Matching word phrases over different cells

 Solved

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...

5 replies Last reply on 27 May 2011 by
rizvisa1

Excel macro help.

 Solved

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 ...

7 replies Last reply on 27 May 2011 by
TrowaD

Excel macro to identify/modify/combine cells

 Solved

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...

3 replies Last reply on 27 May 2011 by
TrowaD

Conditinal formattin

 Solved

Hello, If e1 cell is contains "closed" the entire row (or) a1:e1 should be highlighted in red color. Configuration: Windows XP / Internet Explo...

2 replies Last reply on 26 May 2011 by
TrowaD

Multi criteria conditional formatting

 Solved

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 ...

4 replies Last reply on 25 May 2011 by
bretsh

Formulae

 Solved

Hello sir, your forumlae working fine, i would like to convert lakhs to paises please send .. Configuration: Windows XP / Internet Explo...

3 replies Last reply on 25 May 2011 by
rizvisa1

Select the cell that a button is in

 Solved

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...

4 replies Last reply on 24 May 2011 by
Vernoman

Password reset

 Solved

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...

1 reply Last reply on 23 May 2011 by
bionik

Color column range based on content in cell

 Solved

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...

4 replies Last reply on 22 May 2011 by
Game Start Now

Outlook won't send emails

 Solved

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...

1 reply Last reply on 22 May 2011 by
xpcman

Hiding a different sheet in workbook

 Solved

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...

1 reply Last reply on 21 May 2011 by
venkat1926

Report from excel data sheet

 Solved

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 ...

4 replies Last reply on 21 May 2011 by
ram

Show a range off a drop down menu

 Solved

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...

3 replies Last reply on 20 May 2011 by
TrowaD

Excel vb macro

 Solved

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 "...

4 replies Last reply on 20 May 2011 by
b_85

Codes for reminder creation in excel vba

 Solved/Closed

Hello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...

Last reply on 17 May 2011 by
vivek

Can not run macro

 Solved

hello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...

1 reply Last reply on 17 May 2011 by
ram sharma

How to create shortcut keys to xl 2007macros

 Solved

Hi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...

3 replies Last reply on 17 May 2011 by
RWomanizer

Ignoring rows with zero value

 Solved

Hello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...

3 replies Last reply on 16 May 2011 by
RWomanizer

Highlighting the values entered in an excel

 Solved

Hello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...

3 replies Last reply on 16 May 2011 by
TrowaD

Copying data to another worksheet

 Solved

Hello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...

1 reply Last reply on 16 May 2011 by
TrowaD

Forgotten password

 Solved

Hello, i changed my password on my samsung S8300 today, i then turned my phone off, when i turn my phone on it asks for a phone lock, it doesnt except...

1 reply Last reply on 16 May 2011 by
bionik

Excel: matching and sorting

 Solved/Closed

Hello, Ok, how sould a computer dummy to this (the dummy is me): I have a list of 300 bike racers. In the columns next to the racer is items such a...

Last reply on 12 May 2011 by
lew13

Can someone please write me a macro for excel

 Solved

I want to be able to input a number into a cell and have that number recorded in a list elsewhere within the same sheet. Then be able to replace tha...

3 replies Last reply on 12 May 2011 by
TrowaD

Copy selected cells to new sheet in a row

 Solved

Hello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f 32, ...

9 replies Last reply on 10 May 2011 by
suryam

To recover a forgotten password of a mobile p

 Solved

Hello, I have a Samsung GT-S5603 mobile phone. I have forgotten a user password, so I can't open it, now. Please, tell me how to crack this passwo...

1 reply Last reply on 9 May 2011 by
bionik
Results 1651 - 1700 out of a total of 2,608