creat a row in a spredsheet when a certain value is entered in a row in another spreadshee

Hi guys,

I'm new to the forum and most of the times i am able to find the formula I need to investigate, but in this case, no proper result are popping up in google. I don't think i am using the correct vocuabulary.

so here is my dilema:

I have made a spreadsheet to mark attendance, punches, tardies etc.
I have a tab for each month and in every month 2 tables for each 15 day period (in mexico they pay by forthnignt)

Now i have for each day and person th epossibility to choose form a list if it is OK (on time), EXT (excused tardy) UXT (unexcused tardy) ....

My hope, is to be able to, whenever i choose ext for instance, automatically create a line in another spreadsheet/tab in a table where automatically the name, date and duration of the tardy would populate.

I created a short table in the tab i named automatic table and this is where i would like the info to be populated.

I am attaching the thing, obviously.

I do apologise if it is not the right place to post.

Thanks in advance for your help.

Alex

With something like this

Please Login or Register  to view this content.

Kind regards
Leo

Hi, thank you very much for your help. It seems very complicated, I thought maybe it would be something easier. I don't really understand the code above and I don't find it in my workbook. Could you tel me where to find it please ?

It is not in any workbook, you have to copy and paste it

open VB Editor (Alt F11) and right click on ThisWorkBook

Kind regards
Leo

thanks you guys


so you would recomment to just put all my table one below the other ? it's not really an issue, that I can do The only thing is I am starting to notice that I'm playing beyond my league here. VBA sounds scary lol. I guess, if I manage to understand how it works for one event (EXT) then i could make work for the other events.

I understand what you're saying, Nevertheless, I would hae to re do everything, so I think I'm onna stick with it that way.
Neverthe less, could you briefly explain what the code refers too ? I mean what part refers to what exactly, so I can work out how to adapti to my need? :P

I know it's maybe too much to ask.

Just let me know

Thanks

to busy now, but something for tomorrow

Kind regards
Leo

you rock ! thanks man

Some explication in code

Alt F11
DubbleClick on ThisWorkBook


Kind regards
Leo