AutoFill Error 1004

Hi Excel Forum,

Me again

This is probably really simple but it has blown my mind and I know why it is failing but I just don't know how to fix it

I have a sheet that extracts data from another sheet after criteria has been met. It is then copied onto another sheet, allocated to a colleague via a autofill and then pasted back into the masterfile.

The issue I am facing is that the data changes all the time as the results from the criteria can return different rows of data so the allocation autofill fails as I may have more colleagues than data to autofill

The example I have added you will see two lines of data on the magic tab, on the staff tab I have two colleagues so when the staff data is pasted over it fails with a Run Time error 1004 and am assuming that it has nowhere to autofill to. There could be times where I have 30 lines of data on the magic tab and the macro works perfectly well, but there could be a time when I have only one line of data and it will fail again.

This is where I am stuck as I don't know how to fix it?

Any help would be greatly appreciated as I am dumbfounded

It looks like you need to count the rows in column X after you paste not before.

The error you get is when the rows count for Column B is not greater than the rows count for column X,
so autofill only if B row count is greater than X row count.

Please Login or Register  to view this content.