Macro to Find and go to a cell with refernace of cell name box

[elginaksoy]

Hello excelforum,
I faced a problem when recording a macro that enables me to copy paste values in the cells which are chosen by the criteria of "A1". My aim is to search the value of cell A1 (in my sheet it is "2012-11") and find in the range A4:Z4 (which the row name is "CUGR on Revenue"). Then copy and paste value the cell below matched up cell (in my sheet it is "31.84%". I used a macro below, however when I used Find fuction the macro hit the value of "2012-11" but my A1 cell will change constantly. How can I pass this hurdle?
please be noted that I'm very beginner user of macro and I use macro recorder. Thanks in advance.

2012-11

Realized Realized Realized
CUGR on Revenue 2012-10 2012-11 2012-12
Total Services 13.72% 31.84% 56.23%
Food Services 11.98% 25.33% 12.232%
Non-Food Services 19.05% 28.35% 45.34%


KPI Macro

Please Login or Register  to view this content.

[Cutter]

@ elginaksoy

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules (Rule #3) require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. Please read the rule below.
Thanks.

RULE 3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[elginaksoy]

Hi again,
I really didn't know that and of course I'll be careful next time.
Thanks for your help...