Recording Macro using relative reference.... need to have a ROWS function unchanged

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...

Hi Davis,

Thanks....Pls find.

Please Login or Register  to view this content.

Hi, bmbalamurali,

maybe something like this:

Please Login or Register  to view this content.

Ciao,
Holger

Hi HaHoBe,

I tried your macro its giving wrong values in formulas ie: its not allocating persons name correctly...

request your support in my other post which same as this one....
http://www.excelforum.com/excel-prog...r-of-data.html

Hi, bmbalamurali,

I tried your macro its giving wrong values in formulas ie: its not allocating persons name correctly...

You didnīt supply a sample workbook, the code was doing fine in the book I created for this.

Regarding your link:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. You may continue in your other thread.

Ciao,
Holger

Thanks HaHoBe,

Regret for violating forum rules... Have found solution with my other post... Solved..