Search results

Excellent. This work fine. Thank you regards, Mahen

Hi, I am sure whether you didn't understand my question, or no answer to my question so far? regards, Mahen

Hi How do we move the tab to next entry by passing the formula. In the example Yellow heighted fields are user entry and blue are formulas. Once use enter entry on E4 the cursor should move to E7 rather than to E5. Then E8 to E11 on so..... If code needed , please someone give. Thanks Mahen

Let me know if anyone who didn't understand my question please.

I am need a help on copy or paste link. On summary tab in D4 & E4 I have copied and paste link from London tab one at a time. How do I fill the rest (F4 to I4) in summary tab from London tab. Thanks Mahen

Thank you. Excellent, worked perfectly. I didn't know hh:mm; exist. I only know about hh:mm Great, Mahen

I have a problem if anyone could sort out please. When the over time come to 0 hours (column I) then I am getting ###### overtime column. How do I resolve? file attached Thanks Mahen

Brian, Thats it great. Thank you. Mahen

Required a macro to change whats in D8 and L19 as cross way in like D21 and O29. Dates can be easily get cross way but the rest need to be. See attachment.

Brian, Perfect. Working now. I did sub and end. But had that error. Thanks you. Mahen

Thanks Brian. I am getting " Complier Error: Invalid outside prodecure". Not sure where you get sheet 3 from. Also not sure about why A5. Summary sheet contain a two table. Column B, name of the sheets and column C contain appropriate Names which should copy into the Name1 to Name4 in cell...

Thanks Brian for looking into. Information in Summary sheet is copy from another file physically. Only column C information is need to copy into appropriate sheet in C3.

Required a macro to copy Names from Summary tab to Rest of the appropriate tabs in c3 (highlighted in yellow). Physically copied in Name1 tab. Thanks. Mahen

Hi Goodspeed, Put some value in C18 AND D18, the result should come on H18 & I18? Why no result?

Required a macro to create following worksheets and copy Id Nos to appropriate worksheet in a cell position C3 on all sheets. Worksheet Name Id Name Name1 A001 Name3 C004 Name6 W042 These details are in the same...

automatic. see attached file. Column H and I are automatic.

When save the file after entering the figures, the formulas working. Why?

An excel workbook created in 2003 and modified in 2010. For some reason cannot get the result of the calculation. Formula was there before and still there. For some reason result is blank. What could be the reason? same problem for all work sheet in the work book.

Brian & CJ, I have about 100 worksheets in a workbook. All are same format created by create a copy. Just Name of the employees are differnt. User who has the password for this workbook should be able to unlock and enter the input daily. And should be able to lock the workbook(without doing one...

How do I protect more than one sheet (workbook) without anyone entering data. I can protect from Rename, hide, delete etc...