The discussions

Need macro excel net to zero

Good Morning All, I would love to hear from all the experts on this forum. I have a set of data that consists of many rows and columns. All the tr...

3 replies Last reply on 27 Aug 2010 by
Ray

Lookup a value

Hello all, In Excel, I'd like to be able to return a value from sheet2:c1 into sheet1:B1 where a date in sheet1:A1 is between a date in sheet2:A1...

3 replies Last reply on 27 Aug 2010 by
Ray

Creating email on a samsung star phome

Hello, I want to know what to type on incoming server and out going server,and give me an example to write an email address. i.e mlu.dludlu@............

2 replies Last reply on 27 Aug 2010 by
Tebza

I need a password for dell latitude d630

 Solved

Hello, my tag # is 3civwd1-595b service code is 7259109013 any help would be greatly appreciated Thanx cds Configuration: Mac OS X / Safari 533....

3 replies Last reply on 27 Aug 2010 by
Ambucias

Dell d830 latitude password needed

 Solved

Hello, I forgot my passowrd administrator and can not do nothing is laptop dell d830 latitude how to fix it that help my servis tag is d9lvnd1 thanks

3 replies Last reply on 27 Aug 2010 by
Ambucias

Bois password

 Solved

Hi, I have the same problem I have Dell inspiron 1440 and my sister blocked the bios by mistake and I cant make it boot again with anything it shows a...

2 replies Last reply on 27 Aug 2010 by
Ambucias

V-lookup only picking up some of the data

Hello, Im having problems with V-Lookup, this has happened before... It only brings back some of the data and not all. When doing my sensor c...

1 reply Last reply on 27 Aug 2010 by
Game Start Now

Problem sending the command to the programme

Hello, when i open my save file of office 2007... i m faceing this problem " There was a problem sending the command to the programme " ...

3 replies Last reply on 27 Aug 2010 by
Ambucias

Format cell with text and number

 Solved

Hello, I want to format certain cell into first letter "alpha" then dash (i.e "-") and then three digit number. Example: A-001, ...

4 replies Last reply on 26 Aug 2010 by
KKK

Macro to copy row in new sheet if text found

Hello, I need help in creating a macro that will copy all rows of a sheet into a new sheet if a text is found. The sheet with the data is ca...

1 reply Last reply on 26 Aug 2010 by
edz

Windows password

 Solved

Hello, i forget my window xp password and the operating system are not open.Please give me simple solution for change the password or open the wind...

3 replies Last reply on 26 Aug 2010 by
Ambucias

Complicated lookup in excel

 Solved

For me at least..... I have two spreadsheets that I am trying to use a lookup on. It's a little more than a VLookup. PTCI and TECI are the names ...

5 replies Last reply on 26 Aug 2010 by
DCecil07

How to reset forgotten micrsd card password??

 Solved

Hello, I've lost my nokia memory card's password.. please help me in retriving it!!! Configuration: Windows XP / Firefox 3.6.8

1 reply Last reply on 26 Aug 2010 by
netsa77

Conversion

Hello, please tell me how we can store data of excel into sql database Configuration: Windows 7 / Firefox G3.6.6

1 reply Last reply on 26 Aug 2010 by
netsa77

Outlook 2007 problem: retrieves all messages

Hello, My Outlook 2007 client retrieves ALL of the messages from my AT&T Yahoo! POP3 account instead of just retrieving the Unread or new ones. I h...

2 replies Last reply on 26 Aug 2010 by
jesabel

Excel problem.

Hello, i am having a worksheet (excel 2003)with the details as bellow: coloum a: stock name coloum b: high coloum c: low coloumc...

5 replies Last reply on 26 Aug 2010 by
rizvisa1

Dell d620 -595b password issue

 Solved

Hello, I have spent the last 2 days trying to recover a password-ed laptop system and have so far managed to reset my bios by tearing down my s...

4 replies Last reply on 26 Aug 2010 by
robbiej251

Current time by clicking comm button in excel

Hello, how to get the current time by clicking command button for any active cell

5 replies Last reply on 26 Aug 2010 by
venkat1926

Word and outlook icons

Hello, I just installed Office Professional 2010 and the icons for Word and Outlook do not show the logo. I went into properties to change the ic...

1 reply Last reply on 26 Aug 2010 by
greentech07

Software

Hello, I want to download quick office for nokia 5800 xpressmusic and also pdf reader. Where do I get these software

1 reply Last reply on 26 Aug 2010 by
greentech07

Video files are not shown in powerpoint 2007

 Solved

Hello, I recently held a presentation using the PowerPoint 2007 software. I had inserted a video file (.avi) captured from an unregistered Hypercam2. ...

6 replies Last reply on 25 Aug 2010 by
Ambucias

Copying data from one worksheet to another

 Solved

Hello, I have created a worksheet with 1000 rows of information that has 12 columns that vary with input information. Each row could have 1 or up ...

1 reply Last reply on 25 Aug 2010 by
TopherPUSA

Microsoft outlook and iphone

Hello, Every time i open an email in microsoft outlook it will delete the email on my iphone. please help Configuration: Windows 7 / Firef...

1 reply Last reply on 25 Aug 2010 by
netsa77

Pdf files problem

Hello, When I open the pdf files from the email and save it to the local disk, it saves in the word format. I have Adobe Reader installed as well. C...

1 reply Last reply on 25 Aug 2010 by
netsa77

To remove password

Hello, i hav 2 gb card nd i forgot its password can u halp me to remove my password Configuration: Windows 7 / Firefox 3.5.11

2 replies Last reply on 25 Aug 2010 by
666

Excel date format

Hello, i have got an excel sheet which is prepared by some tool having two columns with custom and the format is mm-dd-yyyy hh:mm:ss. when i am r...

2 replies Last reply on 25 Aug 2010 by
goodscoolxh

Hacking password

Hello, I have pc which is secured by password and now ut can't be login in any account so pls give me the solution to hack its password.

3 replies Last reply on 25 Aug 2010 by
rapper

Macro for a range

Hello, I have this macro below that works only on single cell. How can I change the coding from just singl cell to a range of cell (a1:a30). Thanks....

2 replies Last reply on 24 Aug 2010 by
dzrdw0

I had forgot the password of 6058

 Solved

Hello, I had forgot the password of 6058 i cannot able to restore factory settings please help me. Configuration: / Opera 9.80

1 reply Last reply on 24 Aug 2010 by
Ambucias

Split number

 Solved

Hello, Can you help me, I want to split a number in one cell into columns For example I have the following: A1 = 12345 and I want the follo...

2 replies Last reply on 24 Aug 2010 by
Issa

Finding my sever address

Hello l would like to know what my sever address is please!

1 reply Last reply on 24 Aug 2010 by
netsa77

Find the % value

Hello, if column a1=200, column b1=10%+3 , i want to get a data like 200+200*10% thanks ashraf Configuration: Windows XP / Firefox 3.6....

1 reply Last reply on 24 Aug 2010 by
netsa77

Excel macros cut and paste keyword

Hello, I am new to excel macros, but would like to use it. I have a list of 100,000 addresses. I need to find addresses with the name "BOX", then ...

9 replies Last reply on 24 Aug 2010 by
rizvisa1

Collating payroll

Hello, I'm looking for a formula to analyse a payroll spreadsheet. On the spreadsheet there are a number of names and then it lists a breakdown o...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

Mac excel

Hello, I have had my macbook pro since April and without issue. Now all of the sudden my excel software will not open I get the following message:...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

Restricting drop down box values to filtered

Hello, How do I format a drop down list box that captures only filtered values and changes the values depending the filters? I have a spreadsheet t...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

Trouble with functions in excel

Hello, I'm currently making a spreadsheet which is designed to take the start and end time of a staff members shift and use conditional formattin...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

What is the format of outlook file?

 Solved

Hi there, I have a doubt regarding Outlook files. I mean, for example, if we use outlook at home, to access mails, and save important mails...all t...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

Find the average of results 2 cell types

Hello, Hi all, Please help me. 1. find out the results average, mean, highest and lowest score from the Overall marks. 2. Match these same ...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

Macro to divide column into multiple columns

Hello, I have a monthly report which is run and exported to Excel. I have one column of data which may be between 5K-10K rows depending on number...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

Comparing 2 columns and returning an answer

Hello, I'm trying to figure out a formula. If Column D = X then I want to return the value in Column B from the same row. Does that make sense? I...

1 reply Last reply on 24 Aug 2010 by
rizvisa1

Mail.com outlook outgoing server issues

Hello, So I'm trying to use Outlook for my mail.com account. I'm able to receive incoming emails, but I cannot send or forward, even to myself. ...

1 reply Last reply on 24 Aug 2010 by
jaunglia

Convert worksheet_change event to macro

Hello, How can I convert WorkSheet_change event becomes a macro. Please see code below. thanks. Private Sub Worksheet_Change(ByVal Target As Ex...

4 replies Last reply on 24 Aug 2010 by
rizvisa1

What is the incoming mail server for comcast

Hello, How do I find my incoming mail service for Comcast mail? Configuration: Mac OS X / Safari 533.17.8

1 reply Last reply on 24 Aug 2010 by
cha_mps

How to merge an excel file to database?

 Solved

Could someone please instruct me how to merge an excel file to database (MS Access/FoxPro/Oracle)?

10 replies Last reply on 24 Aug 2010 by
satya

Find string/date, copy row to another sheet

Hello, I'm new to VBA and currently working on a macro wherein I wanted to search for a specific date (e.g. 08/17/2010) then copy the entire row f...

7 replies Last reply on 23 Aug 2010 by
venkat1926

Microsorftword is failing to read word e-mail

Hello, my computer can not read e-mail that is word document as an attachment i am using microsoft word 2003, what could be a problem please help ...

2 replies Last reply on 23 Aug 2010 by
Deep

Macro to round up (ceiling function)

Hello, I have a bunch of raw data [in cell range $B$2:L499] I want a macro which will read each of the cells and re-populate with Integers. I'v...

5 replies Last reply on 23 Aug 2010 by
Netscur

Excel formulas

 Solved

Hello, I am having difficulty copying fromulas on excell from different sheets to form an analysis page. I have 52 different sheets and need to ...

30 replies Last reply on 23 Aug 2010 by
rizvisa1

Compare two excel columns

Hello, I have two excel sheets. One has Server Names only. Second has server names with other columns with more data like OS,Supplier,Application...

1 reply Last reply on 23 Aug 2010 by
Game Start Now
Results 7401 - 7450 out of a total of 12,267