merging one columns data to the bottom of another

[excellentexcel]

hi guys could anyone give me the code to attached one column of data to the bottom of another?
ie the next available cell

so column a has 250 lines of data the data from another column will then go diectly into 251

thats not the number i want but the next available

thanks

[davesexcel]

This Will find the address of the said cell

Please Login or Register  to view this content.

This will paste to the first empty cell

Please Login or Register  to view this content.

[excellentexcel]

thanks dave
will try it out

[excellentexcel]

dave just as an add on
what code would you to select all cells with data in
lets say
all cells in column c with any cell that has data in it and cut

[davesexcel]

dave just as an add on
what code would you to select all cells with data in
lets say
all cells in column c with any cell that has data in it and cut

Is there a specific row to start?

Please Login or Register  to view this content.

[excellentexcel]

c1 is fine
thanks

[excellentexcel]

hi guys i have the code below but i get a message box come up that says
microsoft excel $A$2 with an ok button
it then proceeds to only copy cell c1 to a2 then i get them same thing again but it puts d1 into a3
where as it should be all the data in column c that got to a1 then it should find the next available free cell and input all the data from column d

Please Login or Register  to view this content.

[davesexcel]

I don't know what you are doing, Maybe supply a sample workbook showing what's up.

[excellentexcel]

dave
the code i have attached includes getting all the data from 1 sheet
leave unique records then sort , then does the same for column d

i then need d and c to merge and then again remove unique records and sort what is left

[davesexcel]

dave
the code i have attached includes getting all the data from 1 sheet
leave unique records then sort , then does the same for column d

i then need d and c to merge and then again remove unique records and sort what is left

It's doable of course, though can't see what you are doing, can you supply a sample workbook? showing what the end results should be?

[excellentexcel]

hi dave
its linked exactly to this
http://www.excelforum.com/excel-prog...to-vanish.html
i have tried all i can to get this going and im stuck

[excellentexcel]

apologies i thought i had already linked the page
i thought i might be able to get round this on my won with a few short cuts and recorded macros but doesnt seem i can

[davesexcel]

apologies i thought i had already linked the page
i thought i might be able to get round this on my won with a few short cuts and recorded macros but doesnt seem i can

Sorry I don't Use xl'07 yet,
I have looked at the workbook....
It would be easier for others if you made the sample just 100 rows deep and explain on the sample what you are trying to achieve, your workbook does not have any details of what your end result should be.
Attach the workbook to your post, if you do not know how to do that, the forum rules explain it.
You need to make it as easy as possible for others to help you....

[excellentexcel]

hi dave i have posted toe work book on this thread
http://www.excelforum.com/excel-prog...to-vanish.html
thanks for your interest/help