How to select a particular cell using macros?

[aadeshgandhi]

Hello,
I am trying to recorded a macro to copy the value from a cell. This cell will always be two cells to the right of a cell which has "Purchased" typed into it. I tried to record a macro but it actually assigns a fixed cell value. See the code below, cell Q10 n Q11 are being assinged whereas I want the selection to be 2 cells to the right of the cell having "Purchased" word. How can I edit this bit of code?

Please Login or Register  to view this content.

Thanks,
Aadesh

[AlphaFrog]

Please Login or Register  to view this content.

[benishiryo]

hi aadesh. just to share how you can do it with recording, this is what you did:
1. click on A1
2. CTRL + F & find "Purchased"
3. go to the "Developer" tab & press "Use Relative References".
4. click on 2 cells to the right. this time, what it does is not select Q10:Q11 but relatively 2 cells to the right
5. Copy

[aadeshgandhi]

It worked, thanks!