Autofill Data based off current sheet lastrow not first sheet lastrow

I am trying to insert data "1" into cell K2 in Sheet2 and copy that data down to the last row that has data in it. I want the autofill end row to be based off of column "A" in that respective sheet. I also have to move to the next sheet and do the same... etc. etc.

What is happening is that the data is autofilled, however, it is basing the end row it copies to off of "Sheet1" column "A" instead of the sheet where I am trying to autofill. This, of course, makes the data autofill, but way past what the actual end row is in "sheet2" due to Sheet 1 having many more rows....

How do I Autofill each sheet based off the endrow "A" in the respective sheet?

Please Login or Register  to view this content.

Thanks for that, that helps if I am going to name each "K" column "Verified" and copy the cell data to the end for each sheet (all the same). (which I will be doing)

What if sheet2 column L1 will need to be named "Name" and in L2 i will have a value "Bob" that will be copied to the end (to the last row in column "A"). But the next sheet3 L2 will be named "Jimmy" that will be copied to the end (to the last row based off column A) etc. etc. for multiple sheets