General

Adding data from multiple worksheets of the same type
Hi, Please can you advise? I have created an order form to send to clients each week. They type the number of each product that they want to buy into the Quantity column, cell 1,2,3 etc. according to which item they want. How can I total all the clients ' weekly orders, from each cell in the Quantity col... 4 Mar 2010 05:37

Compile error in hidden module Excel 2007
Just contact your service provider. Also you must get the best web develop process for your site process.. I got this 'The Web Pole.com : Affordable, full service web hosting packages.' (http://www.thewebpole.com/) for my web developing process @ reliable costs. -- srikannan ---------------------------------... 4 Mar 2010 04:31

Tracking textual Data changes beween 2 columns & highlight diff nu
Hi there OK I am tracking Students BTEC grades and am going round on circles The Data Range is the same in both columns A&B. This is arrayed order below Dist* Dist Merit Pass Fail Column A is students Targeted grade and column B is Students current Progress I want to compare the 2 and in column C wan... 3 Mar 2010 20:55

Tracking textual Data changes beween 2 columns & highlight diff nu
Hi there OK I am tracking Students BTEC grades and am going round on circles The Data Range is the same in both columns A&B. This is arrayed order below Dist* Dist Merit Pass Fail Column A is students Targeted grade and column B is Students current Progress I want to compare the 2 and in column C wan... 3 Mar 2010 19:48

How do I calculate interest?
I want to create a spreadsheet that shows my kids the power of compounded interest. I want to show them what regular deposits against a specific monthly interest rate results in, at the end of the year. I want to have the interest rate in cell A1 and starting in row 5, in column A I have the date of deposit and i... 3 Mar 2010 20:55

Previewer error??
Excel 2007 When I have the dialog open to select a file for opening I want to preview the file in the preview pane on the right. No matter which Excel file I have highlighted I get the following error message in the preview pane: "this file can't be previewed because of an error in the Microsoft Office Excel ... 3 Mar 2010 19:48

amend a VB code please
hi, is there any chance of someone amending this code to have cell X25 form a list down column K on the 'graphs' sheet, i basically want to duplicate what this code does but add in one more cell, thank you Private Sub Worksheet_Calculate() Dim Dest As Range With Sheets("graphs") Set Dest = .Ra... 3 Mar 2010 18:41

shared workbook - shared workbook options grayed out
I have a shared workbook. Once in a while, I cannot uncheck the allow changes by more than one user at the same time. This option in the shared workbook under the tools menu is grayed out. Other times this option is available. Can someone please tell me why this option becomes unavailable. ... 3 Mar 2010 18:41

Number to time conversion
I'm sure the answers here, but I can't sort it out. I have data entered as general number with no punctuation that needs to be converted to military time. How do I convert it without losing the time entered? ... 3 Mar 2010 19:48

Add same formula to every cell in the range
I notice that when the below rounding macro is used on a formula instead of a number, it converts the formula to its calculated number. Is there a macro that will add the +ROUND() to cells while preserving the formula within the cell? Thanks in advance for your help! "Gary''s Student" wrote: Select the... 3 Mar 2010 16:26