strange error with the code vs worksheet

Office

Question:ActiveCell.FormulaR1C1 = _"" "" "" = IF (AND (MONTH(RC[-2]) = MONTH(R[1]C[-2]), YEAR(RC[-2]) = YEAR(R[1]C[-2])))"" "", text (RC-[2] "," ""dddd mmmm"" ") &" "(" "&" ""Yvonne"" & FIXED (SUMPRODUCT (-(MONTH(R3C10:R40C10) = MONTH(RC[-2])),-(YEAR(R3C10:R40C10) = YEAR(RC[-2])),--(R3C2:R40C2=""x""),(R3C6:R40C6)), 0) "&" "" ") (" "&" ""Jack"" & FIXED (SUMPRODUCT (-(MONTH(R3C10...Read More

Posted: 06 May 2012

Tags: strange error with the code vs worksheet strange error with the code worksheet

The Importance of time sheet software in the day today and the age

Software

We still find many companies following the former followed days of methods such as Excel or other bulky tools. Although these methods are now replaced by advanced smart and easy to use time tracking techniques, some companies do not realize the importance of such developments.What are the benefits of these modern times, followed by solutions? And how can companies acquire them?The answer is simple...Read More

Posted: 28 Apr 2012

Tags: The Importance of time sheet software in the day today and the age The Importance time sheet software the day today and age

Display totals with reference to another worksheet

Office

Question:I know I can calculate sales per day on the same worksheet using something like= SUMIF(A:A,N1,H:H) where: A is the research of dates corresponding to the cell no. 1 and adding the values in cell h on the applicable lines.But what happens if... A: A and H: H are on another worksheet than the N1?My goal is to have a worksheet that displays totals for daily sales of my worksheet TotalSales which...Read More

Posted: 21 Apr 2012

Tags: Display totals with reference to another worksheet Display totals with reference another worksheet

Protection of all but a few cells on a sheet

Mac

Question:I cannot operate. When I try to lock a single cell via the format cells - > protection, I am informed that a lock on a cell has no effect unless the worksheet is not protected. When protect the entire sheet, I no longer have the possibility of changing the status of protection of a cell. What I am missing? I have, in passing, has studied and followed the entry "Protect sheet" help, without...Read More

Posted: 21 Apr 2012

Tags: Protection of all but a few cells on a sheet Protection all but few cells sheet

In MS Excel 2010 Starter, how to password protect my worksheet?

Office

Question:Just try to password protect documents that I create in Excel Starter edition. How what to do? Interesting that I can simply see this response in the section of the application itself help. No answer was provided it y.Answer:Just try to password protect documents that I create in Excel Starter edition. How what to do? Interesting that I can simply see this response in the section of the application...Read More

Posted: 16 Apr 2012

Tags: In MS Excel 2010 Starter how to password protect my worksheet Excel 2010 Starter how password protect worksheet