Merge cell with condition using MACRO for 2007

I am strugling in this concept. Kindly help me to sort this out.

I have a Excel with first row - Frist column with name - John

secoung column - First, Second and Third row contains values related to that name.

I need to move all the values into first row - second column . which is respective to Name John.


Kindly see the attahment for reference.

If you could solve this. It is much appreciatable.

Refer the attached file for details.

I have included a User Defined Function Called Clookup which is added in the Module of the attached workbook.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

fsdjkfhskldflskdlfksdlfjsl

Not sure what's happening there

I don't know what is the need of public sub for Function.

Public Sub is only for Macro Coding and not for worksheet functions like vlookup,count, counta like that I have created Clookup as one of the function. I named it as Clookup because in my term it means that ConcatenatedLookup.

Even general Sub and Public Sub both are equal. The word Public is just used to denote that the user wantedly created the macro needs to be shown in Public. But general sub is also the same as public sub. Both will show in the Macro List...

Oh! Sorry for that... I will ask someone for help for accomplishing your task.

Please wait I called for an help and surely someone will jump in and give solution to you.

Hi,

I have workd on a sample file. open the sheet named "result" and run the macro. let me know if its ok.

Hi Babu,

Its simply writing 0's in sheet 2. I need the macro to
1. check the A column for data(we can also give input to find the data cell)
2.If data is there till next data entry it have to take the cell range.eg., A1 contain data, A2& A3 are empty
3.It should copy B2&B3 cell values to B1 cell. B1 cell data should not be disturbed.
We should have B1,B2,B3 cells data in B1

OUTPUT should be like below
John a b c d
Edison d e f



Kindly do the needful.

Great work. Sorry I saw sheet 3. But in results sheet its perfect.

One small upgrade. Is it possible to enter the data's link by line in the same cell..

For eg., Now it display as abc in a cell
Is it possible to display as a
b
c

Or any seperator babu? and also there may be data is whole sheet. but right now it is fetching only 3 values.

Hi,
this is a reply for your previous post
pls check now. see the result in sheet "result".

yes, its possible.. give me a moment.

Hi,

Attached 2 types of file as per your need. one with comma seperator, and another with line breaks.
you can use any1 which ever u like. run the macro, see the sheet "result".

Sample 2 is fine Babu. But it is taking only till Row "A6". I need all the data because I have such datas till A150th row. Those data can be increased

For more details, I have attahced my "sample data" sheet with this. Sorry for missed details. In that sheet you can see details in Column B(ID) and Column C(Description). If we go with your concept of copy paste then all other columns will get deleted. i dont want that to happen

i have extnded it till 150th row. i have added sum datas to check. pls see attachment.

if you want to increase it further pls change the row number (instead for 150) in the below and paste it to ur module.

Please Login or Register  to view this content.

give me a moment. will revert back.

Hi,

i ve worked considering ur file. pls run the macro, and check in result sheet.

pls check this.

ur welcome. have a great day!!