Hi All,

I have a complex formula to retrieve data as i desired, the formula contains ROWS funtion Ex: Rows($1:1) to get 1,2,3,..... when i autofill it in below rows...

My question is i clicked relative reference button and started recording macro from cell A2.. with rows($1:1) and dragged down and got answer...
why i used relative refernce is wherever i click and run the macro it should do the steps without cell specifications...

but here when i run this macro in some other cell, Ex: in H6 its not working that is its not giving me the answer 1,2,3... its giving 6,7,8....

How can i make a macro without this wrong answer... i need the maro to give me answer as 1,2,3.... wherever i clivked and run it...

hope i explained clearly... am not able to upload example excel.... If my question is not clarifiable without example excel.. please let me know...

Thanks...