VBA Code to copy values from two columns of a WS to two columns of another WS

Hi,

I am after a vba code that will copy any rows in sheet1 in range A10 to A30 and range X10 to X30 that have data in them and ignore blank cells in those ranges and copy them to the next available row down in sheet2 in columns C and E. I only want it to copy the values not any formats etc.

Is this possible please?

Any help that could be given would be very much appreciated.

Originally Posted by :) Sixthsense :)

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)

Please Login or Register  to view this content.

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

That works perfect thank you so much!!!

I wish i knew how to read and write all that like you guys do!

Very much appreciated thanks for the help!.