The discussions

Copy / paste specfic date to other worksheet.

 Solved

Hello, I've got a few columns of data in which 3 columns contain dates (in date format : dd/mm/yyyy) . Now, I want excel to seperate the entire row ...

11 replies Last reply on 22 Aug 2010 by
carman

How to open mobile 6630 password

 Solved

how can I break my forgetting password of mobile 6630 thanks

4 replies Last reply on 22 Aug 2010 by
Ambucias

Need password for dell d620

 Solved

The origanal hard drive stopped working. I bought a new one and when I turn it on it asks me for a system or administator password. I have no idea. Sy...

3 replies Last reply on 22 Aug 2010 by
cha_mps

Find and replace cell value macro help pls

 Solved

Hello, i have these 20 formulas (1 per stock code) in my spreadsheet that come from etrade =PROStaticData(2, "mqg.ASX", "2010/08/10;2010/08...

6 replies Last reply on 21 Aug 2010 by
jonny

Read:phone lock password for samsung gt-s5230

 Solved/Closed

Hello, i have forgotten my phone lock password for my phone and I dont have a clue how im going to unlock it again... if you could help me I would b...

Last reply on 21 Aug 2010 by
Ambucias

If one cell contains a name then?..help.help.

 Solved

Hello, I have a 2 columns in (Worksheet 1) . One with Names (A1) and the other with Numbers (B1) corresponding to the names. On (Worksheet 2) (C1...

2 replies Last reply on 21 Aug 2010 by
Neil

Filtering problems

 Solved

Hello, I have a microsoft database access and I'm trying to filter some records. This is what I do: 1. I have a form for query purposes, in tha...

4 replies Last reply on 21 Aug 2010 by
Cindy

Macro: watch a cell and copy if changed

 Solved

Hello, The problem in a nutshell is that I have 5 pivot tables on one worksheet, each with a field called "date" above the main text. Each day the...

4 replies Last reply on 20 Aug 2010 by
JayHerring

Create a macro to format a column

 Solved

Greetings, I am not a programmer but I know how to create basic macros that would perform simple repeated tasks in a fixed range within a sheet. ...

3 replies Last reply on 20 Aug 2010 by
Vivian

Macro to delete duplicate items -help please

 Solved

Hello, I'm trying to create a macro to delete the row that has a word at the biginnig and the same word at the end. Example: MIA/SFO/MIA ...

5 replies Last reply on 20 Aug 2010 by
rizvisa1

Technics to unlock administrative passwords

 Solved

Hello, Can you help by showing me how to unlock a computers with an administrative passwords if theres no unlocking software? Configuration: Wi...

1 reply Last reply on 20 Aug 2010 by
Ambucias

Sum with conditions but look at date

 Solved

Hello, I want to sum the conditions in a certain month. Say for June from the 1st to30th or July 1 to 31. The formula that is used without the date ...

2 replies Last reply on 19 Aug 2010 by
Gouws

Word - print preview vs page location

 Solved

Hello, I like to edit my documents in Print Preview, and at 100% zoom. However, when I do that the page is being displayed on the left hand side ...

1 reply Last reply on 18 Aug 2010 by
zaph

Help to adjust this code slightly!

 Solved

Hello, I have this code, Sub IMPORT() Dim NextRow As Long Sheets("New & Renewals").Range("A4:D4").Copy NextRow = Sheets(...

4 replies Last reply on 18 Aug 2010 by
Nicklt

To get password of g-five u-909

 Solved

Hello, i have forgten my security or password of my mobile so how can I open the my mobile. please help me Configuration: Windows XP / Internet...

1 reply Last reply on 18 Aug 2010 by
Ambucias

Textbox date value max

 Solved

Hello, My english is not good so sorry in advance need to get the maximum and minimum value of date in excel userform . i m use these code ...

20 replies Last reply on 18 Aug 2010 by
rizvisa1

Formula help

 Solved

Hello, I need a formula to calculate overtime. I have this spredsheet that tracks everyones time, a regular day is 8 hours, anything above that is...

18 replies Last reply on 17 Aug 2010 by
rizvisa1

Forgotten its password

 Solved

Hello, Hello, i have21GB micro sd card & i have forgotten its password now it is blocked so help me in opening Configuration: Windows XP / ...

2 replies Last reply on 17 Aug 2010 by
wyaat

Excel, filling in cell values automatically

 Solved

Hello, I have two worksheets in Excel 2007 and am trying to automatically fill in cells in worksheet two based on values in the first worksheet. A...

4 replies Last reply on 16 Aug 2010 by
venkat1926

Text help in excel

 Solved

Hello, i need to get 2 text cells on sheet 1 to list in 1 cell on page 2 any help would be cool with me since i am new to this neet thing called e...

3 replies Last reply on 16 Aug 2010 by
larry

Lessthan or =,greater than and sum

 Solved

Hello, I have the following values in Excel 2007: A1(38)B1(26)C1(20)D1(80)E1(75)F1(50)G1(3) In H1 the formula =IF(AND(A1=C1,D1>E1,SUMPRODUCT(F1-G1)...

2 replies Last reply on 16 Aug 2010 by
jack4rall

Web cam problem

 Solved

Hello, web cam of my note book doesnt work where i have to download free driver for webcam Configuration: Windows 7 / Internet Explorer ...

1 reply Last reply on 15 Aug 2010 by
jack4rall

One cell two formulas

 Solved

I have a cell that can change from "USD" to "PESO". When this cell is changed i need another cell to calculate appropriately. I have these two formula...

2 replies Last reply on 15 Aug 2010 by
jack4rall

Vlookup in other worksheet (date)

 Solved

Hello, Attached please find the reference file. https://authentification.site/files/23765947/sort.xls I am doing a VLOOKUP from sheet 1 to she...

1 reply Last reply on 13 Aug 2010 by
carman

Vlookup tool

 Solved

Hello, Configuration: Windows XP / Internet Explorer 8.0 I am using Excel2003.Plz let me know how can i use vlookup tool. Step by step met...

1 reply Last reply on 12 Aug 2010 by
drlootle

Help with excel please

 Solved

Hi I have an excel spreadsheet with two columns in A is a list of codes, and in B a list of names containing the codes in a string A ...

4 replies Last reply on 12 Aug 2010 by
Bob

Copy entry from each worksheet to new sheet

 Solved

Hello friends, After reading some very useful suggestions. I thought of posting my problem, hoping i'll find a solution I have a workbook which...

9 replies Last reply on 12 Aug 2010 by
ishi

My new computer does not recognize my printer

 Solved

Hello, I just bought a new computer with Wndows Vista. I have a HP Laserjet 1200 seires printer that my computer cannot seem to recognize. The pr...

5 replies Last reply on 12 Aug 2010 by
Shujjat

Administrator password in ragistray

 Solved

Hello, dear all pls tele mi wich location save the administrator password or user password in ragistry

1 reply Last reply on 11 Aug 2010 by
drlootle

Excel absolute reference?

 Solved

Hello, Configuration: Windows XP / Firefox 3.6.7 I have cells A1:A5 as "5, 10, 15, 20, 25" respectively. I want to make cells C1:G1, ref...

4 replies Last reply on 11 Aug 2010 by
gr

To find the max value +

 Solved

Hello, Hi need to get the maximum value for certain range of cells. and the value of the cell next to that max cell. can any one help ...

14 replies Last reply on 11 Aug 2010 by
Manish Bakde

Browsers all stop. router is fine.

 Solved/Closed

Hello, Recently, without installing any new software, my browsers all eventually stop. Firefox is my main, and would be the first to fall after abo...

Last reply on 10 Aug 2010 by
onejohn512

Data validation formula

 Solved

Hello, I have a spread sheet that tracks attendance. What i want to do is to alert the user whenever 3 OR MORE CELLS IN SEQUENCE CONTAIN THE SAME D...

35 replies Last reply on 10 Aug 2010 by
rizvisa1

Find last time text entered and return value

 Solved

Hello, I've got text in column D and a value for it in column G. I want to lookup/find the last time "Bolt 'was entered and return it's value.(the...

5 replies Last reply on 10 Aug 2010 by
Gouws

Copy and paste to other file.

 Solved

Hello, Can anyone tell me what's wrong with this code? I record it using macro.. Columns("G:M").Select Selection.Copy Workbooks.Open ...

2 replies Last reply on 9 Aug 2010 by
carman

Vlookup according to location not name

 Solved

Hello, i put the name of the files i want to perform in some cells and wrote a maco for excel to call up the file according to the location. (lets s...

14 replies Last reply on 9 Aug 2010 by
rizvisa1

Help with a conditional macro?

 Solved

Hello, I am trying to use VBA to check whether an M appears in column B and then, if it does, paste the information from that row (Columns A thr...

4 replies Last reply on 7 Aug 2010 by
Steve

Go to next page in word doc using vba code

 Solved/Closed

Hello, Can any one tell me how go to next page in microsoft word doc using Excel Vba + macro code

Last reply on 6 Aug 2010 by
VBA guru

Outlook connect to your incoming (pop3)

 Solved

Hello, At the time of setting my email account in indiatimes the following error showing sending & revived box.plz suggest Task 'umakanta200...

1 reply Last reply on 6 Aug 2010 by
Ambucias

Copy rows until meet given line

 Solved

Hello, I'm trying to split one spreadsheet into several spreadsheets. The splitting has to be done when a certain value is found. I need to mo...

2 replies Last reply on 6 Aug 2010 by
Stix

Ms office 2003 product key

 Solved

Hello, i am rajesh i want to install the ms office 2003 but i have no product key please arrange the product key Configuration: Windows ...

2 replies Last reply on 5 Aug 2010 by
aquarelle

Forgot my corby password

 Solved

Hello, i had a password for phonebook and messages ..i reset the password anforgot..now how will i unlock it?? Configuration: Windows Vista / F...

1 reply Last reply on 5 Aug 2010 by
drlootle

Insert 2 rows, copy the formula.vba help pls

 Solved

Hello, I have a huge file to work on. Please help me with a VBA that does the following for the entire sheet (until the last row) 1) Whenever y...

3 replies Last reply on 5 Aug 2010 by
rizvisa1

Changing font colour

 Solved

Hi, I've looked at some posts on your site and followed the advice, however I can't get this to work. I'd like to change the font colour of a range ...

5 replies Last reply on 5 Aug 2010 by
rizvisa1

Do not count if date not entered

 Solved

Hello, I have a date in C3(30/06/2010) and sometimes a date in C4 (01/02/2010).In C5 i got a formula =((C3-C4)-I3)+1)*24. I3 will have the amount ...

3 replies Last reply on 5 Aug 2010 by
Gouws

Found and paste

 Solved

Hello, i have two files, one is excel which contains few articles like 111230, 111412, 552136 etc and other file is notepad which contains hundreds o...

18 replies Last reply on 4 Aug 2010 by
shehla

Vba macro-move to cell underneath the button

 Solved

Hello, I want my VBA macro to move to the cell 'underneath' the particular button that is being pressed. (I have a series of buttons down the page, e...

9 replies Last reply on 4 Aug 2010 by
Liam

Forgot my login password

 Solved

Hello, Configuration: Mac OS X / Safari 531.22.7i can not get in to my laptop it is a dell forgot my login password

1 reply Last reply on 2 Aug 2010 by
jaunglia

Width & merge cells

 Solved

Hello, I Have 1 WorkSheet In Which There Are Too Many Sub Sheets. I Want The Width & Merge Cells Of Sheet1 In To All Sheets. But I Dont Need The ...

15 replies Last reply on 2 Aug 2010 by
Game Start Now

Matching 2 columns in excel

 Solved

Hello, I've got 2 columns of data- I'm trying to see if there's a match between the data in Column A with Column B- if the data is in Column B somewhe...

2 replies Last reply on 2 Aug 2010 by
alaisa
Results 2001 - 2050 out of a total of 2,608