move rows to another worksheet
On a stock control sheet once an item has been logged out (by date) I would like the entire row automatically moved to another worksheet. This would then collate all items logged out on a history worksheet and leave a current available list on the original worksheet. Thanks for any help on this. ... 1 Jun 2010 08:39
MSN MoneyCentral stock quote
I have changed my pc in april. I have windows 7 pro and Office 2007. I would like download MSN MoneyCentral stock quote for Excel 2007 but it is not possible to find it. Where I can find this pack ? Thank you ... 1 Jun 2010 08:39
Deleting invisible range names - how?
Excel 2007 I have pasted a list of all range names (368 of them in all) and I find a few that have been obsoleted through their location being cut out (eg "=#REF!$H$1 "). These show ikn the pasted list but not in the range names editing dialogue box. Is there a way to delete them? "Edit" and "Delete" in F... 2 Jun 2010 02:16
More on saving as binary.
OK, so I started the experiment and soon got pulled up. I'm saving my .xls file as a binary .xlsb, and the darned thing wants to put an underscore in front of range names. I dunno if it applies to all, but the first one not acceptable was Bal001. Aah yes, would this be because Bal001 is now an actual cell withi... 3 Jun 2010 02:25
I am attempting to create a pie chart with 2 lists of data, in column A I have a list of occupations and in B I have a recent test scoring. I want a chart that shows me a comparison of occupation and scores, I have been using the chart wizard however I am getting a seperate result showing in the chart for each... 1 Jun 2010 11:59
how do i switch off template help in microsoft excel?
template help stays open on the right side of the screen. If I close it...it opens again when I open another page. ... 1 Jun 2010 10:52
Formula to average last 25 entries in a column?
Guess I have a duel question. First, I have numerous columns of data, all numerical. New entries are entered at the end of the column. Is there a formula to average just the last 25 entries in the column? (Bottom of column up) Second question pertains to the ability to "auto populate". I have a column of n... 2 Jun 2010 06:34
Leading Zero as value not appearance
When i use formatting cell custom with 0000 i manage to add leading zero but the problem is the leading zero only as appearance. Is it possible to make it as value in the cell ... 1 Jun 2010 10:52
Count of cells since first purchase
Hi, Looking for a bit of help with the below. I want to calculate how many weeks have passed since a customer first purchased from me. So for example see below. I want to calculate in cell E2 how many weeks have passed since Account 1 first purchased from me. In cell E3 i want to calculate how many weeks i... 2 Jun 2010 02:16
Split report for email
I have a report that contains a number of columns - and where the report contains a number of lines for a range of 'cost centres'. The report has the cost centre title in one column (say B) and then a number of rows below that containing various data in the columns. At the moment the cost centre is only identifie... 6 Jun 2010 07:16