The discussions

Clearing clipboard

 Solved

How to clear clipboard using macros?

2 replies Last reply on 17 Jun 2010 by
Saky

Sumif formula to sum between 2 dates...help

 Solved

Hello, I want a formula to sum the cells between 2 dates. For eg: Col A Col B Dates Total 3/2/2010 100...

3 replies Last reply on 16 Jun 2010 by
Chris

Excel macro to insert a new row

 Solved

Hello, I would like to create a macro in excel to automatically insert a new blank row immediately after the last row of filled-in data and for th...

4 replies Last reply on 16 Jun 2010 by
rizvisa1

Guyz...please help with this ...

 Solved

Hello, Thanks for giving your time to this. I want to get a help for the following thing. I am trying to calculate ticket fares between places. I w...

10 replies Last reply on 16 Jun 2010 by
rizvisa1

Memory card password

 Solved

Hello, Configuration: Windows XP / Safari 533.4 hi i want to ask how to set a password for only memory card i have tried every option please hel...

1 reply Last reply on 15 Jun 2010 by
closeup22

Help with if vba statement

 Solved

Hello, I have this code that i can not get to work all the way i get the error of "Too many local, nonstatic variables" i am new to this and all i...

2 replies Last reply on 15 Jun 2010 by
Boysenb

Automatic date population

 Solved

If i fill any data in cell A1 then automatically current date should get update in the next column B2. Can this be done? Pls assist.

4 replies Last reply on 15 Jun 2010 by
Krish

Trying to create a advanced control box

 Solved

Hello, I'm wondering how the control box in the attached sheet can be created in Excel 2007 - i want to create it in one of my sheets http://i...

7 replies Last reply on 15 Jun 2010 by
rizvisa1

Lookup word within text and provide cross-ref

 Solved

Hello, Excel V. 2003. First list contains Internal Account Numbers, Portfolio Names Second list contains External Account numbers, Portfolios ...

1 reply Last reply on 15 Jun 2010 by
rizvisa1

Excel function or macros

 Solved

Hello, I have a table in which every number from 1 to 52 expresses a specified text For example 1 = Sofia 2 = London ... I n...

2 replies Last reply on 15 Jun 2010 by
Philip

Password problem

 Solved

Hello, when ever i turn on my computer and i wana go to setup by pressing f2 it requirs password how can i remove it plz help!!! Configurati...

1 reply Last reply on 14 Jun 2010 by
jack4rall

Macros

 Solved

Hi, I need a macro coding for the below scenario. In column D(Application) i have created a validation in which i have included the list of appl...

18 replies Last reply on 14 Jun 2010 by
Saky

Excel help with percent calculations

 Solved

Hello, I use "=AVERAGE(B2:AR2)" to calculate percentages based on information from 40 sheets. Example, On one sheet that compiles the data from 40 she...

8 replies Last reply on 13 Jun 2010 by
rizvisa1

Forgotten the pnone lock password

 Solved

Hello, I have forgotten the phone lock password of my nokia 7210 supernova.can anyone help me to recover the password.plz help....

1 reply Last reply on 13 Jun 2010 by
closeup22

Converting time units to whole no.

 Solved/Closed

Hello, Example: start time is 8:00AM and end time is 8:30 AM= total time :30 (cell is formated to time units)... How do I convert :30 to show ...

6 replies Last reply on 12 Jun 2010 by
eyji

If function in data range

 Solved

Hello, does anyone know how to solve this: In a data range of say A1:A10, if all entries are "YES", give me "YES"; otherwise give me "No"

5 replies Last reply on 12 Jun 2010 by
eyji

Can't open ms word 2007

 Solved

Hello, Whenever I try opening MS Word 2007 - I get this message "Windows cannot find C:\Users\User\Desktop\...............file.doc. Make sure y...

1 reply Last reply on 12 Jun 2010 by
closeup22

Delete entire content if cell a1 value change

 Solved

Hello, I have been enriching high value support in excel programing, its great upto you guys, I have a another chanllange to answer, hope you sol...

7 replies Last reply on 12 Jun 2010 by
Nitin

Vba language for a range of cells

 Solved

Hello, I created a calendar cell pop-up and I wanted to include it in a range of cells. However I can't figure out how to include an entire range of c...

1 reply Last reply on 11 Jun 2010 by
rizvisa1

Compare multiple cells and return other value

 Solved

Hello, a problematic case, when comparing values in multiple cells (rows) in Excel. In a single cell , "A1" I would need an answer depending on...

4 replies Last reply on 11 Jun 2010 by
Vince

Cell changing color if updated within the las

 Solved

Hello, Can I set a cell to change background color if I have updated that cell during the last 10 days? Meaning that, if I update a cell it will r...

10 replies Last reply on 11 Jun 2010 by
rizvisa1

Create a form to modify existing records

 Solved

Hi, My name is Lucy, I was wondering if any person here could help me. I am having this trouble, i have a form where I enter the name of client...

7 replies Last reply on 10 Jun 2010 by
Corina

If cell is a,b or c then 1,2 or 3

 Solved

Hello, I am trying to get a formula that will let my put a numerical value in one cell dependant on the word in another cell for example a1="word1...

2 replies Last reply on 10 Jun 2010 by
mltplyn

Need excel percentage!! help

 Solved

Hello, I am having diffficulty writing a formula to calculate a percentage. I need to calculate 25% of $ 3,100 - I thought I had it figured ...

2 replies Last reply on 9 Jun 2010 by
Deanna

Copy row to different sheet based on cell

 Solved

Hello, I am need to have a script run each time a cell changes to a date in column O, line 12 and after. I have a spreadsheet that has one tab ca...

8 replies Last reply on 9 Jun 2010 by
gregoryps

Tabs not showing

 Solved

Hello, A few days ago somebody very kind gave a hand with this, but I am having a problem: every time I use combo box it should be showing tabs "...

2 replies Last reply on 8 Jun 2010 by
Mary

Calculating exact percentages in excel

 Solved

Hello, I'm trying to add exact percentages like 99.54%, 84.23% in six cells then calculate the average. I've tried =AVERAGE(A1:B1:C1) but it only ...

2 replies Last reply on 8 Jun 2010 by
rizvisa1

Recover card password

 Solved

Hello, I have the card which has password to open it. but I forgot the password. and I have no data cable , now how can I recover the password. ...

1 reply Last reply on 8 Jun 2010 by
closeup22

Excel: partial cell matches in dfrnt sheets

 Solved

Hello, I searched a lot and found quite some useful results about searching Partial Cell matches. But if the cells belong to different sheets how ...

2 replies Last reply on 8 Jun 2010 by
fairooz

I forgote memorycard password

 Solved

Hello, how to unloke(delete) my memory card password?

1 reply Last reply on 8 Jun 2010 by
ash_perez01

Please help to set print area automatically

 Solved

Hello, I have an issue with print areas. I have a worksheet with equations in it up to cell # 5000. However, most of the time, the equations usual...

3 replies Last reply on 7 Jun 2010 by
rizvisa1

Please help - run macro when switching sheets

 Solved

Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...

2 replies Last reply on 7 Jun 2010 by
D

Undoing a macro to retrieve info back

 Solved

Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...

2 replies Last reply on 7 Jun 2010 by
kat

Macro to blank out filtered columns

 Solved

Hello, I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can yo...

2 replies Last reply on 7 Jun 2010 by
kat

Excel conditional formatting

 Solved

Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0

4 replies Last reply on 7 Jun 2010 by
G

Return a value from a data set

 Solved

The problem is I have number 1 to 10 in A2:A11 and number 10,20,30....100 in B1,C1,D1..... K1 and there are corresponding values in the cells under th...

4 replies Last reply on 7 Jun 2010 by
Surya

Default password for china moblie x.e88 mob ?

 Solved

Hello, i need default password for china moblie X.E88 mobile ohone.. pls some one help me..

2 replies Last reply on 7 Jun 2010 by
surya

3 dropdownlists

 Solved

Hello, Please help I want to make 3 dropdown lists in Column B2,3,4 and all must work together. In B2 i must have a selection of e.g Building,Person...

1 reply Last reply on 7 Jun 2010 by
rizvisa1

Code to open a tabs from combox excel

 Solved

Hello, I'm looking for a code, i can put in a combo box to show up different tabs located in my spreasheet. example: I have four tabs called tab1,...

6 replies Last reply on 6 Jun 2010 by
Mary

Excel 2007 days and dates issue?

 Solved

Hello, I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the...

3 replies Last reply on 5 Jun 2010 by
rizvisa1

Look for a value into different ranges

 Solved

Hello, PLeas take a look on the following data A B C D E Range 1 Range 2 NAME 81000...

5 replies Last reply on 4 Jun 2010 by
rizvisa1

Forget my phone password

 Solved

Hello, sir i forget my phone password please help me

2 replies Last reply on 4 Jun 2010 by
Ambucias

Excel formula

 Solved

Hello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...

4 replies Last reply on 4 Jun 2010 by
djb

Matching columns

 Solved

Hello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...

2 replies Last reply on 3 Jun 2010 by
KJFin

If statement required please

 Solved

Hello, Date 1 Date 2 Days varience Status 04/05/2010 29/04/2010 -5 On Time 04/05/2010 06/05/2010...

8 replies Last reply on 2 Jun 2010 by
Ant

Macro that takes multiple csv files and puts

 Solved

Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...

3 replies Last reply on 1 Jun 2010 by
jrog

Ms office 2007 opens files as read only

 Solved

Hello, I installed Office 2007. Each time I open a file in Excel, it opens it as Read Only and won't let me save with the same file name and thus...

2 replies Last reply on 1 Jun 2010 by
AVISUR

Excel 2007 "if....then select row and move&qu

 Solved

Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...

11 replies Last reply on 1 Jun 2010 by
rizvisa1

Copying data in a dfrnt sheet w/ condition

 Solved

Hello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...

5 replies Last reply on 29 May 2010 by
fairooz

Label name protected

 Solved

Hello, I was wondering if someone can help me. I want to know in this file at this address: https://authentification.site/files/22686748/Mac...

6 replies Last reply on 29 May 2010 by
Clara
Results 2151 - 2200 out of a total of 2,599