| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dynamic rows: cell value concatenation
In sheet1 x denotes rows which is dynamic and starts from 6 . so we have
D6,D7,D8... etc E6,E7.. etc under D6 i have ABC and under E6 i have XYZ . i have to concatenate the text in D6 with text in E6 (result shud be like ABC_XYZ) and put it into a column B3 of sheet2 in same work book here the rows in sheet 1 are are dynamic. so whenever an entry happens in sheet 1 , the text in the two columns should be concatenated and put into sheet 2 column. so wat VBA code do i write to concatenate and copy into sheet2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to apply concatenation to successive rows of data | Excel Worksheet Functions | |||
| NUMBER OF ROWS IN A DYNAMIC RANGE | Excel Worksheet Functions | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| How do I Concatenate these Dynamic Rows | Excel Worksheet Functions | |||
| Dynamic number of ROWS | Excel Worksheet Functions | |||
![deepika :excel help[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
