Moving data from one cell to another
 

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

Moving data from one cell to another
 

Anthony,

From what you are describing, concatenation would do the work ... you
don't a macro ...
e.g. =A1&" "&C1

HTH

Carim

Moving data from one cell to another
 

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

Moving data from one cell to another
 

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

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

HTH

Carim