Facing an issue to correctly autofill according to filtered data with macros

Hi all,

I am currently compiling my data into a separate sheet. My data contains 11 different names with varying number of rows of data of the projects they have worked on over the years. After filtering out their data into another sheet, i have 9 columns of formula that I want to display towards the right of the filtered data.

After typing in the formulas that I have, I autofill it downwards and this is where im facing the problem. During recording, the person that I autofilled the 9 working columns only had 8 rows of data, but the next person has 9 with a few of them with 13 rows of data. When running my macro again, it only autofills by 8 instead of the number of rows on the left of the working column which is the filtered data.

My current formula looks like this:

Please Login or Register  to view this content.

Try it now. We can refine it further if you supply a sample file, as per the yellow banner.

Please Login or Register  to view this content.