Autofill base on Active Cell and Autofill by row count of another sheet
Hi all,
I'm new to excel vba, need some help with the codes.
Information:
3 sheets -1,2,3
Need to count the number of row in sheet 3. Then in sheet 1, go all the way to the last row and autofill a range of cells (eg.A35 to G35 but row numbers may change, column remains the same). Auto fill all the way till the number of row in sheet 3 is the same.
Re: Autofill base on Active Cell and Autofill by row count of another sheet
Sorry it didnt.
In sheet 1 it suppose to start at A35 and autofill it downwards (data to be copied which is also the data of the last row = A35).
Instead it messes up A33 and A34.
Bookmarks