Moving data from one cell to another

  • Thread starter Thread starter abmorgan
  • Start date Start date
A

abmorgan

Hi all.

It is the first time I have posetd in here and am very interested in
learning more about VB for Excel.
Firstly, anyone know the best way to start learning? Are there any
books you could recommend? or websites even?

Secondly, I am wondering how to do the following,

I need a macro to move data from one cell to a cell two to the right,
but rather than copy and pasting over the top of the cell the data from
the cell on the left gets added onto the end of the destination cell

For example

[red][][book] >>>>>>>> [ ][][red book]

I am looking for it to work with over areas of cells or just single
cells?

Is it possible?
I don't really know where to start.

Any help appreciated

Anthony
 
Hiya,

Yeah I have just started getting to grips with concatenation, but I
want to avoid inputting a formula everytime. I don't know how to get a
macro to give the value of that formula. Also I am looking to replace
[book] by [red book] so i can't input into this cell

Ant
 
If you really need a macro, to take contents from C3 and D3 into F3 :

Range("F3").FormulaR1C1 = "=RC[-4]&RC[-3]"

HTH

Carim
 
Back
Top