- Joined
- Mar 25, 2009
- Messages
- 1
- Reaction score
- 0
Hi,
I'm halfway through compiling a macro in excel2003 to copy and paste data from a questionnaire to the answer page.
I have where i would like each paste to start referenced in a cell but how do i get the range to paste to match the reference in that cell?
E.g. Cell c2 is currently reading "b5" and will change to "b6" once the first set of data is pasted in. If only i could get the data to paste to b5 in the first place
Many thanks
I'm halfway through compiling a macro in excel2003 to copy and paste data from a questionnaire to the answer page.
I have where i would like each paste to start referenced in a cell but how do i get the range to paste to match the reference in that cell?
E.g. Cell c2 is currently reading "b5" and will change to "b6" once the first set of data is pasted in. If only i could get the data to paste to b5 in the first place
Many thanks
Last edited: