macro to copy data range from sheet and past to specific other sheets

Hi,

I have a data in sheet "List". Data range is from Cell A1 to till the last cell in row 1 which contains data and from A1 to till end of the last cell in column A which contains data.

Need code to copy the whole data range and past only on those sheets which sheet name are matching with names exist in 1st row of sheet "names".

for e.g data to pasted only in sheets "Aditya_Birla", "Apollo_Munich", "ICICI_Lombard", "Bajaj_Allianz", "Bharti_Axa" and "Reliance_Capital". Because only these name are exist in first row of "Names". Ignore all other sheets

Hi saravanan

maybe you could use something like this?

Please Login or Register  to view this content.

above code is coping only Column A.

Entire data range is not copies.

Originally Posted by saravanan1981

above code is coping only Column A.

Entire data range is not copies.

there is only data in Col A in the "List" sheet. Do you mean all columns and rows with data in the "List" sheet?

yes. entire data range.

what will be the last column in the sheet?

need to find last non blank cell in 1st row. copy till that. here last column is W.

in that case, define the last row and column:

Please Login or Register  to view this content.