Recent content by mahen

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