vba code to determine last row containing data and copy the data to another sheet

Dear All

It's great to be back to this wonderful forum after a long absence.

Please, I should be grateful for your kind help with a vba code that will help me copy data from one excel worksheet to another.

I have attached a sample file containing three worksheets, namely LISTING, REC and CUSTOMER.

1. The code should be able to determine the last row containing data on the worksheet named 'Listing'.

2. Then some of the data on that row should be copied to certain cells in the worksheet named 'Rec' - as follows:

a) The data in col. A (Listing worksheet) copied to Cell C18 of Rec worksheet.
b) The data in col. B (Listing worksheet) copied to Cell C13 of Rec worksheet.
c) The data in col. C (Listing worksheet) copied to Cell C3 of Rec worksheet.
d) The data in col. H (Listing worksheet) copied to Cell I15 of Rec worksheet.
e) The data in col. F (Listing worksheet) copied to Cell I17 of Rec worksheet

I also would like to have a 'PRINT' code to enable me to Print out the ‘Rec’ sheet (the Print Area is A1:I29).

I wish to add that the data in column A of ‘Listing’ worksheet is ‘name of customer’ which is selected by using Data Validation drop down list. I am mentioning this in case it may be necessary to adjust the code that will copy that column’s data from the drop down list to another worksheet. As mentioned in (a) above, the data in this column is copied to Cell C18 of Rec worksheet.

I have a bit of knowledge on how to create a data validation drop-down list. So creating the drop list would not be a problem for me.

I’ll appreciate your help.

Buddy8

Hello Buddy8,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.