Hello again people!
So - I have the following.
Sheet 1 has columns A to Q with headers and simple data associated (like name, dob, car make, etc) that has all been inputted manually. Column header cell E is a date column (date of vehicle hire). Only a few people have data in this column.
Sheet 2 has some of the same column headers as sheet 1 (Same titles but less of them, like a subset)
If someone populates column E in sheet 1 with a date, say at row 25, I want to automatically bring over the data associated with that row to sheet 2 to match the subset of columns.
Is this possible with formula, or do I have to resort to VBA?
Either way, does anyone know of a method?
I don’t have office 365.
Thank you.
So - I have the following.
Sheet 1 has columns A to Q with headers and simple data associated (like name, dob, car make, etc) that has all been inputted manually. Column header cell E is a date column (date of vehicle hire). Only a few people have data in this column.
Sheet 2 has some of the same column headers as sheet 1 (Same titles but less of them, like a subset)
If someone populates column E in sheet 1 with a date, say at row 25, I want to automatically bring over the data associated with that row to sheet 2 to match the subset of columns.
Is this possible with formula, or do I have to resort to VBA?
Either way, does anyone know of a method?
I don’t have office 365.
Thank you.