Copy data to other sheet + Loop to last record

Good Day,

Would require your assistance if you can help me out with the below inquiry as I'm unable to find a possible simple solution...

I have SQL data that I'm extracting and populating two sheets accordingly on daily basis. (This is done manually and sheets are refreshed with new data)

Name of tabs: (Peaked & Confirmed)

Each sheet consist obviously of different data but table extract contains the same name & number of columns.

Name & Number of Columns :

1. Org_province
2. Port_Of_Load
3. Port_Of_Discharge
4. BK_Client_Name
5. FF_BK_Name
6. VesselVoyage
7. GrossWeight
8. Export_Closing_Date_Yard
9. Sail_Date
10. SailWeek
11. SailMonth
12. Sailing_Year
13. RevenueTotal

Macro Requirement: (Need your help)

Data to be extracted based on the following existing Master sheets from same Excel file:

Example:

• Peak Data would move to MasterPeak
• Confirmed Data would move to MasterConfirmed

Now my concern is that Master sheets would have to keep all records. How can a I ensure that when macro is automatically populating sheets it doesn't override records already existing and loops only to the last empty cell and populates columns from the point on?

I would appreciate your assistance if possible.

This any good?

Please Login or Register  to view this content.

It assumes you have headings on both sheets. Just change the sheet names to work on the other sheets.

Dom