• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell referencing problem

N

Nicki

Member
Hi, Could you please help changing this working time sheet in a way that basic user can copy and paste template below the the next one without changing anything else. I know it is easy to do it by creating one sheet for each staff, but having so many staff it is not easy to have 100 tabs across. it has to be at least 10 staff in one sheet. nay redesign or using VBA will be appreciated.

1- Copy and paste is easy for adding new staff, currently copy and paste needs adjusting cell references for column J and K which connected to B and E.

2- Also avoid deleting cells containing formula I have to luck the cells but then it will not let user to add rows if needed

Any improvement formula please. Thanks indeed.
 

Attachments

  • Clerical TIL- V1.xls
    53.5 KB · Views: 11
Hi Nicky
I would recommend getting out of compatibility (xls) mode and using the Tables for more than the pretty stripes (using an xlsx format).

I have replaced your direct cell referencing with Structured References and the copy / paste operation then seems to work fine. I selected entire rows so that the row spacing was replicated and changed the table name to apply to the staff member once the table was copied.
 

Attachments

  • Clerical TIL- V1 (pb).xlsx
    27.8 KB · Views: 11
You must log in or register to reply here.
Back
Top