Dear Experts
I have rawdata emp info where stored emp info
i have userform to fill details once fill details i submit i want update details into emp info as well simultaneously include in table under corresponding team
please find the attachment
Dear Experts
I have rawdata emp info where stored emp info
i have userform to fill details once fill details i submit i want update details into emp info as well simultaneously include in table under corresponding team
please find the attachment
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 .
Last edited by JohnTopley; 07-04-2023 at 12:24 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Please Login or Register to view this content.
Thanks expert!! Its solved i have one small requirement
if i extent the table for month year, i want code run till date where it end then fill total of workingdays & absent
is it possible add on it
thanks
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.
Last edited by JohnTopley; 07-05-2023 at 03:18 AM.
Please Login or Register to view this content.
Last edited by JohnTopley; 07-05-2023 at 07:44 AM.
Hi sir i have facing small issue, i just extent table sheet and renamed got error,
can u make so simple fill your formula in vba code across row 2:2 till Total working days met , and column 2:2 till meet blank cell
Formula:Please Login or Register to view this content.
find the
I wasted my time on a VBA solution so no more from me!!
Last edited by JohnTopley; 07-05-2023 at 09:33 AM.
hi sir , sorry for annoying you, thanks for your code its solved i just need it for third option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks