Copying selected cells from multiple rows and columns from worksheet to worksheet

Hi!

So. I have this huge excel-file with many differet worksheets. What I want to be able to do is select several rows in column B (and which rows are selected varies from time to time - sometimes rows 4-5 another time perhaps 140-250 or 31-357) in Worksheet1 and then copy the information in the selected rows from column B, C and E to Worksheet2 where they end up in column A, B and C on the first row where there is no information.

Oh, and if the information in for instance row 149 in the 140-250 example above already exists in Workheet2 then that information should not be copied.

Is this doable? If so - how?

Backup your data.
Place code in a standard module.
Select rows to be copied.
Run: CopyBCE2Sheet2ABC

Please Login or Register  to view this content.

It worked great! Many thanks!

Of course I forgot to mention some other paramaters that where pretty important, but I managed to figure out how to incorporate that into your code. :D