Hi,
This could require a very long code but I only have a basic knowledge of VBA.
I have a worksheet called "Day". In this sheet in Column A I have log numbers. This log number is used as the Vlookup reference to r other fields in the row.
The sheet that the data is taken from is called 'Database'. This sheet contains thousands of records and is sorted by log number. There can be numerous records with the same log number as each log number represents a different part of a consignment.
I would like a macro uses the log numbers in the 'Day' sheet to look up log numbers in the database and return every row of data with that log number in Column A in a new sheet.
E.G Log 45678 has 5 different rows in the Database sheet.
The macro would copy these 5 rows of data from the Databse sheet into a new sheet. It would then repeat this for every different log number.
Hope someone can help. Hope it makes sense....
This could require a very long code but I only have a basic knowledge of VBA.
I have a worksheet called "Day". In this sheet in Column A I have log numbers. This log number is used as the Vlookup reference to r other fields in the row.
The sheet that the data is taken from is called 'Database'. This sheet contains thousands of records and is sorted by log number. There can be numerous records with the same log number as each log number represents a different part of a consignment.
I would like a macro uses the log numbers in the 'Day' sheet to look up log numbers in the database and return every row of data with that log number in Column A in a new sheet.
E.G Log 45678 has 5 different rows in the Database sheet.
The macro would copy these 5 rows of data from the Databse sheet into a new sheet. It would then repeat this for every different log number.
Hope someone can help. Hope it makes sense....