Moving data from one cell to another

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
 
A

abmorgan

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
 
C

Carim

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

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

HTH

Carim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Create if partial match then copy and paste data from one cell to another 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy from One Workbook to Another 9
Moving data to another sheet 1
Conditional format if difference in cell values greater than 0.50% 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Top