Need VBA to update new emp through userform to sheet and table both

You mention "userform" but if you aleady have one, why is it not in your w/book?

A non_VBA example (but not what you want I suspect!)

in C3

Formula:

Please Login or Register  to view this content.

with named ranges for shifts / leave and new layout in "Tablex": no colour coding for "Leave" types

Having spare rows in Excel tables is pointless and can make solutions more complex.

And there is no obvious reason to separate out Shifts /Leave on separate rows .

Please Login or Register  to view this content.

Yes it could be changed but NOT with the current "TABLE format which is why I changed it in my solution : your layout is "pretty" but not "practical",

Input errors: there are entries in both employee lines for a given date so you need to address this. The easiest way is to have a SINGLE line per employee with a drop-down which has both Shifts+Leave in the list.

And what about the "Totals" which were in your original post? Better to be positioned in columns C:D followed by the dates in E onwards..

I await your response to these points before I do further work.

Please Login or Register  to view this content.

I wasted my time on a VBA solution so no more from me!!