Macro which counts the number of cells in sheet 1& in sheet 2 this exact number is pasted

Hello,

I want to create a macro which counts the number of cells in one column (in spreadsheet 1) and then in spreadsheet 2, in columns A 2, B2 and C2 onwards the same count of cells with the exact number of values from the column in worksheet 1 are pasted.

The value in worksheet 1 would change; there is no defined range. So I would like the macro to find out how many cells have data in a column in sheet1 and then in the sheet2 in three columns to paste the same number of cells. I am not sure how to do this, does anyone have any suggestions?


Thank you

Are you asking to have the data in a column on Sheet 1 (no matter how large it is) copied and pasted to three columns in sheet 2 so that each column has the same data and is an exact copy of the column in sheet 1? If this is the case, it's not necessary to workout how many cells have values in them, you can just copy the column and paste it three times (effectively) with VBA. Please clarify.

Like so?

Please Login or Register  to view this content.

I don't want to copy the cells in the column in sheet 1, I want to find out the count of this and then in sheet 2 to have the same number of cells to be copied in a column

Originally Posted by Soneeka

I don't want to copy the cells in the column in sheet 1, I want to find out the count of this and then in sheet 2 to have the same number of cells to be copied in a column

It's still not really clear what you want.

This will count the number of used cells in column A on sheet 1 and then copy the same number of consecutive cells from columns A:C on sheet 2. Then they'd need to be pasted somewhere.

Please Login or Register  to view this content.

Thank you....I am finding this difficult to explain, sorry.

I want to create a macro which counts the number of cells in sheet1 column D and then for sheet 2 i want the exact number of cells found in sheet 1 column D to be pasted in columns D, E and F.

In the second sheet there is a macro which formulates the values in sheet 1 Column D, this is why i don't need to copy these values.

In sheet 2 in order to show these values, it has to be the same number in sheet 1 Column D , so i don't want to manually copy and paste, i would like a macro to find the number of values in sheet 1 column d and then in sheet 2 columns, d, e and f to have the same number of cells to be pasted.