## The discussions

Solved/Closed

Hello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do so...

Last reply on 13 Mar 2013 by
Pujdo

### Summing up data from groups & pasting it another column

Solved

Hello there, I need to write a macro for the following example: A 2 A 3 A 3 B 4 B 1 B 4 C 7 D 3 D 8 Etc. Basicallly i ne...

3 replies Last reply on 13 Mar 2013 by
rizvisa1

### Special sum of a column

Solved

Hello, In have some columns with plenty of data. And I need to make a column which will have ... D2=C2 D3=C2+C3 D4=C2+C3+C4 ....................

3 replies Last reply on 13 Mar 2013 by
rizvisa1

### Number to word

Hello, i want to covert number in to word like 1000(one thousands) 100 (one hundred) Plz help me to convert number to word in this format Conf...

rizvisa1

### Comparing data in multiple excel worksheets

Hello, For work, I was given an excel document with a different worksheet for each month in 2012. Clients can come to our food pantry one time in ...

Zohaib R

### Calculation of time

Hello friends Pls help me to calculate time in excel. Time value is A1 is 15:25. I have to subtract 11:30 hrs from A1 and doing calculation lik...

11 replies Last reply on 12 Mar 2013 by
Zohaib R

### Formula not opened new excle

Hi Dear All Really thanks for this and this function is working well but that working only in formula contained not in all if i opened newly , ple...

rizvisa1

### Increased size of an excel file

Solved

hi guys, I have come across an interesting issue. I redid some tables in an excel file and when done with it I see that the size of the file is at...

2 replies Last reply on 11 Mar 2013 by
Dg83

### Summary of two or more excel sheets

Hello, i want to do summary of two or more worksheets in a single worksheet to review the data and anlysis. is there any method to do this. pl...

6 replies Last reply on 11 Mar 2013 by
Zohaib R

### Formula for identifying letter with sum value

Hello, I am new to Excel and know very basic formulas. I have made a spreadsheet and have everything pretty much ok except for one part I need ...

4 replies Last reply on 11 Mar 2013 by
Zohaib R

### Macro code for sum of 3 rows

Hello, I have a problem. I have a data in which there is only 1 column but 1000 rows. I need a macro to get sum of 3 rows. can anyone help me...

### Conditional formatting on drop down list

Hello, Using Excel. The Data in column L is populated by a dropdown list of roughly 15 options, all of which are text. When certain options ar...

9 replies Last reply on 11 Mar 2013 by
rizvisa1

### Office excel & outlook

Hello jim, "I have a Excel Sheet in which details of member are recorded with there Date of Birth and e-mail id. and I want to wish them on there ...

3 replies Last reply on 11 Mar 2013 by
rizvisa1

### Problems with if-function...

Hello, I'm using Excel 2003 (yes, still) and I'm having trouble with the IF function. I have a 13-digit number in E2, and in F2 I want the funct...

2 replies Last reply on 11 Mar 2013 by

Hello, how does the software works? Configuration: Windows 7 / Internet Explorer 9.0

3 replies Last reply on 10 Mar 2013 by
xpcman

### Recording an outcome when no data in the field, how to stop?

Hello, I am making a basketball spreadsheet to record "Wins ATS Favorites", "Over/under", and "Wins SU". I use the If((b6-c6)>d6; 1), where "b6" i...

rizvisa1

Hello, I get raw data base from client, My first work is to insert two new columns in Column 6 & 7.....Is it possible to do it through macro ?...

rizvisa1

### Excel formatting

Hello, I am having trouble with a formula in Excel. I have 600 rows of financial data. Column A has numbers 1 thru 6, which correspond with differe...

### Need help with percentage please

Solved

Hello, I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason o...

5 replies Last reply on 9 Mar 2013 by
rizvisa1

### How to get the data while entering in the other cell

Hello, Thanks for your reply. But what i need is if i enter a student ID in a cell in sheet 1 it must open the student details of concerned id in...

rizvisa1

### High and lower case text in the "if" functions

Solved

Hello, I am working on a basketball spreadsheet. I am keep track of the home teams straight up(SU) wins. Home teams are capitalized(higher case), ...

2 replies Last reply on 8 Mar 2013 by
Joshte

### How to find the data by entering the data in one cell

Hello, we are dealing with projects of different colleges. there is a data of more than 1000 students. each time i have to click on the respective...

Zohaib R

### Copy rows to different spreadsheets based on 1 column

Hello, I have a spreadsheet where I track open orders for my company. We track this by multiple metrics and values. I currently manually copy and ...

rizvisa1

### Populate data in excel according with n

Solved

Hello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...

6 replies Last reply on 7 Mar 2013 by

### Can't send or receive email in outlook 2007

Hello, For some reason Outlook stopped sending and receiving messages. I have no connection problems but receive a message saying 'receiving repo...

2 replies Last reply on 7 Mar 2013 by
mariapeter

### Conditional formatting using dates in different cells

Solved

Hello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...

2 replies Last reply on 6 Mar 2013 by
rbarletta

### Percentage formula?

Hello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. Can anyone please tell me how do I find out how many Ye...

3 replies Last reply on 6 Mar 2013 by
rizvisa1

### Compare and count two columns

Hello, I am struggling with a fairly basic excely problem. I have 2 colums Feb 2012 and Feb 2013 each have a number of different crime types...

3 replies Last reply on 5 Mar 2013 by
Zohaib R

### Need a recovery software

Hello, plz send me recovery software for office file. E-Mail ID is deleted for your security Configuration: Windows 7 / Firefox 20.0

### Comparing data in two columns and setting a value

Hello, I'm comparing data in a very big database. and want to assign a value to matching data. For example A B ...

Hello, I would like to ask for help on where to find free microsoft office Configuration: Windows XP / Firefox 19.0

### Excel search words from a cell and assign txt in another cell

Hello, I am having data like whi below: A B 1. customer1 TV Fridge ...

### Macro - copy speciffic columns when value is x

Hello everyone, I've been having a problem for a while and seem to be unable to solve it. I am now trying to get it done with Macro's but run...

4 replies Last reply on 4 Mar 2013 by

### Percentage formula

Closed

Hello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. How do I find out how many Yes answers I have compared a...

Last reply on 4 Mar 2013 by
Bionik

### Excel macro copy/paste and insert rows

Hello, I am trying to write a macro that takes data from a filter and copy and pastes it into a template to create a standardized set of reports. ...

2 replies Last reply on 3 Mar 2013 by
Anonymous User

### Date formant in excel sheet

Hello, how to solve date formant in excel sheet Configuration: Windows 7 / Firefox 17.0

rizvisa1

### Pulling data from multiple cell's in a series of spreadsheets

Hello, I have already done some searches for help on this but I don't think I am coming up with the right way to say it to search for it probably. ...

3 replies Last reply on 2 Mar 2013 by
rizvisa1

### Excel macro

Hello, how can i create the alert excel macro when the cell is changed Configuration: Windows 7 / Firefox 18.0

rizvisa1

Solved

jamesfly

### Snding sms from excel sheet

Solved

Hello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...

4 replies Last reply on 28 Feb 2013 by
ramesh1974

### Transferring data from one excel to another

Hello, I am trying to transfer an array of data from several spreadsheets used by individuals to a "master" spreadsheet that will be stored on a shar...

3 replies Last reply on 28 Feb 2013 by
excelnovice

Hello, Thank you the community in this forum, this is my first day in this forum after joining. I am still learning and think will get the best out ...

Zohaib R

### Formula problem

Hello, I am trying to use a tracking number ex: WP 2013-0001 on excel. I want it to generate in the row automatically with WP 2013-0002 and so on....

rizvisa1

### Dropdown lists in excel 2007

Solved

Hello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...

33 replies Last reply on 27 Feb 2013 by
rizvisa1

### What is the most appropropriate way to recover pst file

Solved/Closed

Hello i m using MS Outlook my PST file was oversized which got corrupted after subsequent retrieval. Tell me what to use?? Inbox PST repair tool...

Last reply on 26 Feb 2013 by
ronwiselly

### I need to replace jpg description with a number

Hello, I have thousands of jpgs that are named by a product description, like Beltwayjacketblack.jpg, and I need to replace jpg description with a p...

rizvisa1

### Converting date to year and month text

Solved/Closed

Hello, I have a cell date entered as 8-Nov. Excel reads this date as 11/8/2010. The cell entry actually means Nov, 2008. I need to change that ...

Last reply on 25 Feb 2013 by
haha

### Conditional formatting

Hello, If cell P5 is greater than Q5, I need cell R5 to equal Q5. If P5 is less than Q5, I need cell R5 to equal P5. Any help would be appreci...

2 replies Last reply on 25 Feb 2013 by
Zohaib R

### Selection of data from multiple sheet

Hello, I am facing a problem, regarding selection of specific rows from multiple sheet in a single workbook. Details: I have a workbook with...

3 replies Last reply on 25 Feb 2013 by
rizvisa1

### Using vlookup to return insted of 00/01/1900

Solved

Hello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...

2 replies Last reply on 24 Feb 2013 by
tom9o
Results 4801 - 4850 out of a total of 12,265