danovkos
02-10-2010, 05:38 AM
Hi all,
a few days ago, some greate guys help me with problem about filling all data in sheet. http://www.vbaexpress.com/forum/showthread.php?t=30112
Now i try to do folowing.
I want always if user in sheet KRIZ and DE fill any value in column B, macro fill actual date in the same row in column K before save wb. I mean, when he will save wb, it fill this date and then save wb.
I try it with other words - if i fill some data to B in row 20, then row 21 and 23, when i will save the wb, it fill in each filled row (20-23) in column K actual date - as value of course and after this it save wb.
edit: sorry and if it is possible to column L it write user name.
Pls. how can i do this?
thx a lot
a few days ago, some greate guys help me with problem about filling all data in sheet. http://www.vbaexpress.com/forum/showthread.php?t=30112
Now i try to do folowing.
I want always if user in sheet KRIZ and DE fill any value in column B, macro fill actual date in the same row in column K before save wb. I mean, when he will save wb, it fill this date and then save wb.
I try it with other words - if i fill some data to B in row 20, then row 21 and 23, when i will save the wb, it fill in each filled row (20-23) in column K actual date - as value of course and after this it save wb.
edit: sorry and if it is possible to column L it write user name.
Pls. how can i do this?
thx a lot