VBA to have Modified by and Modified on column for all rows

Hi,

I have a tracker worksheet where our team tracks all complaints from customer.
We need columns to know Modified by and last modified columns.
Starting row is 2. Last row need to be identified by VBA I suppose.

I used below below code for range 2 - 1000 but this is not showing any results in Column P and Q.
This 1000 is not upper cap so can we make it dynamic.

Please Login or Register  to view this content.

Another problem is with Auto fill dropdown macro which is working for D, E and L columns but not for the drop down in Column G.

File is attached for your investigation.

Regards,
Gaurav

Hello,

Thanks a lot for your help and it solved my problem.
However, once I add this macro 'undo' function doesn't work. Is it possible to have undo function along with this macro.
If not that is also ok.

Regards,
Gaurav

I don't think so, but there are those much more experienced than I... ask in a new thread.

ok, thanks

However with code you have shared it doesn't exclude header rows. If modify any of column header in Row 1, it modifies the Column P and Q header names with date and name.
Can we start this range from Row 2 to End of Row.

Please Login or Register  to view this content.