The discussions

Conditional copying into different worksheets

Hello, i have excel 2003. what i am trying to do is set up a complaint sheet for 4 different people. In total there are 5 sheets (Main, Al, Bri...

1 reply Last reply on 22 Jun 2011 by
rizvisa1

Excel formula needed to look up and copy data

Hi, I have a list of aged debtors that is updated weekly, Im looking for a formula that will search the previous list via the invoice date and if ...

1 reply Last reply on 22 Jun 2011 by
RWomanizer

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

Remove my memory card password

Hello, how to remove my memory card passworld Please tell me Configuration: Windows XP / Safari 534.24

1 reply Last reply on 21 Jun 2011 by
bionik

Excel 2007 is not working properly

Hello, We are using office 2007. My problem is, we are type 2400 or other number in my excel sheet. It hides the last to digit. It show only 24 .We ...

1 reply Last reply on 21 Jun 2011 by
Excelguru

Write a formula in exel

Hello, Configuration: Windows XP / Internet Explorer 8.0 I am trying to write a formula - If the sum of a group of cells is more than 8 t...

1 reply Last reply on 21 Jun 2011 by
Excelguru

Help with excel macro

Hello, Hi. I am not a programmer and have not used Visual Basic before so that's probably my first problem (!) but I am trying to debug a macro in...

1 reply Last reply on 21 Jun 2011 by
Excelguru

To unlock memory card password

hello sir i am using nokia 2700c and i have foget my memory card password sir please tell me how to unlock memory card password of nokia 2700c plz tel...

1 reply Last reply on 21 Jun 2011 by
bionik

Pulling ordered parts from sheet 2 and insert

Hello, What I'm attempting to do is create a master list of items ordered and what they are ordered for. Sheet 1 is a list of tasks generated b...

1 reply Last reply on 20 Jun 2011 by
venkat1926

Import data into excel

Hi, I have 2 excel sheets namely A.XLS and B.XLS. I would like to import the data from A to B by running a command button in spread sheet B. Can an...

1 reply Last reply on 20 Jun 2011 by
venkat1926

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

Excel data updation

Hello, Configuration: Windows XP / Internet Explorer 8.0 I have date in an excel spreadsheet that gets updated automatically every minute. ...

1 reply Last reply on 19 Jun 2011 by
venkat1926

Calculating dates with some conditions

Hello, Could you please help me in calculating some dates, for ex: today's date ( D ) - 11/06/2011 I want to calculate dates for D+1, D+2.....D+30 ...

3 replies Last reply on 18 Jun 2011 by
Priyaa

Need help in saving file which macro download

Hello, I have a macro which login to one of my site and download a file based on the no what the macro picks up from the excel file. While doing...

2 replies Last reply on 17 Jun 2011 by
hari

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

Word 2007 page numbers not increasing

 Closed

Hello,

Last reply on 17 Jun 2011 by
Ambucias

Web page import

Hello, I import following web page in exel. The wabe page show all share rate. but when share rate change the sequace of share in web page a...

1 reply 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

Macro to copy certain data

Hello, I regret to say that I missed using hello and other polite words in my earlier post. I do respect the people behind the forum. I know that ...

9 replies Last reply on 16 Jun 2011 by
venkat1926

Forget password

Hello there, good day, Please help me retrieve my password. I've been trying my best to recall it but i cannot remember at all. Moreover, i also cann...

1 reply Last reply on 16 Jun 2011 by
bionik

Copy value only if condition meet

Hello, I have a below table 1A 1B 1C 2A 2B 2C........31A 31B 31C ( Beginning with cell DN31,1A and ending with cell HB31,31C) .I would like to h...

6 replies Last reply on 15 Jun 2011 by
rizvisa1

Conditional formatting a cell based on change

Hello, In Excel, I have columns of values, all are in the same units. Each column represents a new week. If the value in column C4 is increased or...

3 replies Last reply on 15 Jun 2011 by
rizvisa1

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

Email

 Closed

Hello, my email will not open. it downloads Configuration: Windows 7 / Internet Explorer 8.0

Last reply on 15 Jun 2011 by
RWomanizer

Copy an excel worksheet multiple times

Hello, I have an excel worksheet, which I want to make 38 copies of, and rename each copy with the initials of the person to whom it belongs. The ...

1 reply Last reply on 14 Jun 2011 by
rizvisa1

How can i compare two excel sheets using vba

Hello, I am having two text files ( which is a comma separated file).The template of the two file is given below. SD,CurrentDate,RecordCount ...

1 reply Last reply on 14 Jun 2011 by
rizvisa1

Linking excel sheets and getting 0's all over

Hello, I have a document that we adjust the master, and then each fiscal year I want on separate sheets but to be updated with the master. I linke...

1 reply Last reply on 14 Jun 2011 by
rizvisa1

Title...memory card password

Hello, my memory card asking password please send reply password. Configuration: / Opera 9.80

1 reply Last reply on 14 Jun 2011 by
bionik

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

Macro not working in shared work book

Hello everyone, my macro works fine, but when i share my work book it is throwing some error, Run-time error '1004': AdvancedFilter method of R...

5 replies Last reply on 13 Jun 2011 by
rizvisa1

Exact if not blank

Hello, I use the formula below to compare two values as long as they are not blank =IF(AND((A1""),(C1"")),EXACT(A1,C1),"-") However, I ne...

1 reply Last reply on 13 Jun 2011 by
rizvisa1

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

Forget my password of memorycard

Hello, I am used nokia 6600. I forgot my password of memory card. Please help me how can i open the memory card. Because I have put very importa...

1 reply Last reply on 12 Jun 2011 by
bionik

Update the value of excel files

Hello, i wanted to ask if there is a method so that i can keep other excel files updated when i make some changes in a particular file.....suppos...

1 reply Last reply on 12 Jun 2011 by
rizvisa1

Move rows to columns using macro

Hello, need help with macro to move rows to columns please E-Mail ID is removed for your security if you can help with this. thanks

1 reply Last reply on 12 Jun 2011 by
rizvisa1

Memory card password

Hello, Hello, I HAVE MMC CARD FOR N 70.i put password on memory card.after 2 days my mobile became dead.i know passward for memory card.but when i...

4 replies Last reply on 11 Jun 2011 by
qasim

How to delete everything under the name

Hello, I'm trying to make labels in excel I know how to transfer it to word to make them. My problem is I need the name on the top and everthing und...

1 reply Last reply on 10 Jun 2011 by
GM Madman

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

Vba transfering data to next sheet

Hello, I'm applying this code to transfer data from sheet 1(source) to sheet 2(destination). Sub TransferData() For Each cell In Range("B...

1 reply Last reply on 9 Jun 2011 by
RWomanizer

Lookup names within additional text

Hi, I got full names in one spreadsheet (A) and another speadsheet (B) with full names plus other text in the same cell. How can I run a lookup...

1 reply Last reply on 9 Jun 2011 by
RWomanizer

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

Macro help

 Closed

Hello, i use a macro for filering my data into another and macro code is Sub Extract1() ' ' Extract1 Macro ' extract ' ' Keyboard S...

Last reply on 8 Jun 2011 by
Ambucias

Excel 2007

Hello, I am a very novice/beginner Excel user. I have a table of Company information in a vertical column which I want to convert to a horizontal...

1 reply Last reply on 7 Jun 2011 by
rizvisa1

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

Excel move a1 to a2 in a formula

 Closed

Hello, I have a 9 digit zip code in column A. I need to phyically move the first 5 digits to column B cell by cell, i.e. A1 to B1, A2 to B2, e...

Last reply on 6 Jun 2011 by
bionik
Results 6201 - 6250 out of a total of 12,264