The discussions

Entering value for column at once, displaying in all sheets

 Solved

Hello, I have a workbook with multiple sheets(1,2,3) , each sheet has list of items randomly placed, the same items are repeated in other sheets ran...

1 reply Last reply on 20 Mar 2013 by
Zohaib R

Help combining worksheets in excel 2007

 Solved/Closed

We use excel 2007 to store information about our products and have a different worksheet for each range. Is there any way of combining all these wo...

12 replies Last reply on 19 Mar 2013 by
rizvisa1

Conditional formatting

 Solved

Hello, I need a help on Conditional formatting: I have a data in A2:E5 (Sheet 1), and in Sheet 2 i have reference data in Column A. i need to...

2 replies Last reply on 19 Mar 2013 by
Matheswaran

Inventory

 Solved

Hello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...

6 replies Last reply on 17 Mar 2013 by
Ashley

Vba how to create new worksheet and move value

 Solved

Hello there, I am zero in vba, can anyone please assist me what code to be used given following conditon Given,(I have data converted from csv t...

5 replies Last reply on 17 Mar 2013 by
rizvisa1

Excel macro; adding password

 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...

13 replies 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

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

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

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

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
TrowaD

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

Problem for creating ms word on tablet

 Solved

Hello, I find very difficult downloading MS word, Excel and VZO video chat.

1 reply Last reply on 1 Mar 2013 by
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

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...

4 replies Last reply on 26 Feb 2013 by
ronwiselly

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 ...

6 replies Last reply on 25 Feb 2013 by
haha

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

Formula for between to dates

 Solved

Hello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...

2 replies Last reply on 23 Feb 2013 by
Tom9o

Stop #n/a appearing after a vlookup

 Solved/Closed

Hello, I need to stop #N/A appearing after doing vlookup. I Understand that this happens because it refers to no value. Anyway I can make it ap...

2 replies Last reply on 20 Feb 2013 by
Ragav

One cell will turn green when the two other cells match

 Solved

Hello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...

13 replies Last reply on 20 Feb 2013 by
diestra123

=month(d2)

 Solved

Hello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...

5 replies Last reply on 20 Feb 2013 by
ramlalmeena

Macro to email picking up email address in one cell using lookup

 Solved

Hi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...

6 replies Last reply on 19 Feb 2013 by
Tom9o

Returning value from column b in column c, in a cell ajacent to

 Solved

Hello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...

3 replies Last reply on 19 Feb 2013 by
lawrencen

Recovery my work and restart microsoft excel

 Solved/Closed

Hello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...

21 replies Last reply on 18 Feb 2013 by
Sridhar L

Compare data in seperate columns to find likely matches

 Solved

Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...

4 replies Last reply on 18 Feb 2013 by
Spraoi

No tool bars or address bar on my browser

 Solved/Closed

Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...

175 replies Last reply on 17 Feb 2013 by
Paddy

Code for macro that conditionally inserts rows

 Solved

Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...

4 replies Last reply on 15 Feb 2013 by
bfleming

Excel for mac opens all files on desktop

 Solved/Closed

Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...

10 replies Last reply on 14 Feb 2013 by
Dan

Can't open excel file

 Solved/Closed

Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...

6 replies Last reply on 13 Feb 2013 by
yolooo

If statement errors and using multiple if statements.

 Solved

Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...

3 replies Last reply on 12 Feb 2013 by
jsav

Merging more cells into one cell

 Solved

Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...

10 replies Last reply on 6 Feb 2013 by
markswan20

How can calculate days between twodates

 Solved

Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...

2 replies Last reply on 6 Feb 2013 by
Kevin@Radstock

Transferring data from one sheet to another

 Solved

Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...

15 replies Last reply on 3 Feb 2013 by
Cuffy70

Time calculations on a 24-hr clock

 Solved

Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...

1 reply Last reply on 2 Feb 2013 by
Zohaib R

Auto notify or mail when excel sheet updated.

 Solved/Closed

Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...

20 replies Last reply on 1 Feb 2013 by
cdb2013

I have a problem with microsoft office starter?

 Solved

Hello, I would respctfully ask anyone to help me with this problem which is: someday I have open the Microsoft Office starter and then I have been ...

2 replies Last reply on 31 Jan 2013 by
a cooperator

Excel 2007 resetting cells to date format

 Solved/Closed

Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...

11 replies Last reply on 30 Jan 2013 by
Archit Badwe

Conditional formatting

 Solved

Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...

4 replies Last reply on 27 Jan 2013 by
Harters

Simply cannot find an answer

 Solved

Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...

8 replies Last reply on 25 Jan 2013 by
mona3

Vb issue with delete rows with specific values

 Solved

Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...

8 replies Last reply on 23 Jan 2013 by
rizvisa1

Macro help: copy data from a range of sheets to a master sheet

 Solved

Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...

7 replies Last reply on 23 Jan 2013 by
supermate

Tagalog

 Solved

Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...

2 replies Last reply on 21 Jan 2013 by
flower_girl

How to convert number into text in excel

 Solved/Closed

Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"

9 replies Last reply on 21 Jan 2013 by
Raj

Adding a new entry into a list - excel 2007

 Solved/Closed

Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...

12 replies Last reply on 18 Jan 2013 by
confused

Vlookup range question

 Solved

Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...

1 reply Last reply on 17 Jan 2013 by
mjaybee

Outlook - "unknown error" ox800ccc81

 Solved

Hello, re https://ccm.net/faq/5929-outlook-unknown-error-ox800ccc81 would you have a fix for this with Outlook Express? thanks Configuration:...

1 reply Last reply on 15 Jan 2013 by
marshalhubs

Adding the same action to every second line

 Solved

hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...

8 replies Last reply on 15 Jan 2013 by
Dg83

If, then formula

 Solved

Hello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...

2 replies Last reply on 14 Jan 2013 by
eaglewings1983
Results 1301 - 1350 out of a total of 2,606