Alternative copy & paste

Hi everyone,

I'm relatively new to vba so please bear with me!

I'm trying to write some code in vba that will copy and paste certain lines from various worksheets within the workbook and paste them into 2 sheets, in the same workbook.

I'm trying to attach the workbook or even screenshots but the network here is a bit slow so it is taking way too long.

Basically:

there are approximately 7-8 sheets from which i need data. to identify the lines that i need to copy across, it is simply whether or not all the columns (C-P) have values in them. IF they do have values in them, i need to copy them into another sheet in the same workbook.

i'm assuming it's some sort of If statement but i cannot figure out how to code it.

ANY help would be greatly appreciated.

many thanks,

mali

Originally Posted by royUK

Maybe your attachment exceeds the forum size limit, try zipping it

managed to do so this time, had to recreate the file without several parts of it so it would upload faster.

if you look at sheets "CT17_2" and "CT17_1", there are some lines that are empty in columns G and I. what i want to do is write a macro that picks up when there is data in all the columns C-P, when there is data (so for example it shouldn't pick up G20, 21, 25, 27, 32), and then copy that data into sheet "CT17".

is that clearer or am i still being a bit confusing?