Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to prevent data from moving to a different cell | Excel Worksheet Functions | |||
moving all data to cell a1 | Excel Discussion (Misc queries) | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Force user to enter data in cell before moving to next cell | New Users to Excel | |||
Moving 1 Data Cell into A second Sheet? | Excel Programming |