copy,paste,format,sort and merge

**excellentexcel** · 01-21-2009, 03:14 AM

hi all
i have 2 columns in sheet 2 that i transfer column d and g from
i copy and paste them into columns c and d on sheet 5
i then highlight column c and remove all duplicates
i then cut and paste this into column a ( sheet 5 )
i then do the same with column d
i have this code so far ( macro recorder )
what i need is for the macro to put column d into column a (sheet 5 ) but to put it at the next available cell underneath what i had already copy and pasted from column c
how would i go about this

**JBeaucaire** · 01-21-2009, 03:18 AM

Post up your code. (don't forget to put the [code] tags around it)

The guys here will take a recorded macro and reduce it to a tenth of it's length.

If you want to try it yourself, the syntax would be:

Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues

**excellentexcel** · 01-21-2009, 03:25 AM

this is the code
the last bit i need to complete is
cut and paste column c to cell a1
and then
cut and paste column d into the next available cell in column a

Please Login or Register  to view this content.

**JBeaucaire** · 01-21-2009, 04:18 AM

I think this does the same thing you want. The only thing I wasn't sure, are you trying to delete NOT import the first cell from source columns? Those are labels? I thought so, so this version copies from cell 2 in those columns.

Please Login or Register  to view this content.

**excellentexcel** · 01-21-2009, 05:31 AM

thanks jb
i am at work now but will have a look when i get home
thank you

**excellentexcel** · 01-21-2009, 06:02 PM

hi jb
thanks for your code
i have adapted it a little to do all that i need it to do which works fine but with one exception
there is a gap between where the two columns merge and there is no data between rows 790 and 873
i can see where in the code this affects it but not sure how to put it right

many thanks in advance

Please Login or Register  to view this content.

**JBeaucaire** · 01-21-2009, 06:07 PM

You'll have to explain more. There's a gap in the raw data? There's a gap in the copied data? A gap caused by the code somehow or a gap the code needs to take into account?

**excellentexcel** · 01-21-2009, 06:18 PM

its leaving a gap between the 2 columns when they merge in sheet players in 1

for some reason it stops at row 790 and starts again at 873

i would download it but its over a meg large

copy,paste,format,sort and merge

LinkBack

Thread Tools

Rate This Thread

Display

copy,paste,format,sort and merge

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions