I am currently having to manually enter the dates that an employee has a meeting onto a central spreadsheet. I am looking for a way in which excel can do this for me automatically, probably via a vlookup of some kind.
I can download a spreadsheet of the data which will include the employee number (which the main sheet also uses) alongside the date of the meeting. This works fine when an employee has just the one meeting on the downloaded data sheet as a simple vlookup will automatically populate the 'Meeting 1' cell on the main sheet.
However my issue is when an employee has two or three meetings on the downloaded data sheet. I therefore need excel to populate the earliest date into 'Meeting 1' column on the main spreadsheet, the next date into 'Meeting 2' column on the main spreadsheet and so on etc.
Apologies if this does not format properly as this is the first time I'm attempting to use XLS2BB - here is a basic mock version of what the downloaded data sheet will look like:
Here is a mock version of what the main central spreadsheet will look like - this is where I would like the meeting dates to show:
I can download a spreadsheet of the data which will include the employee number (which the main sheet also uses) alongside the date of the meeting. This works fine when an employee has just the one meeting on the downloaded data sheet as a simple vlookup will automatically populate the 'Meeting 1' cell on the main sheet.
However my issue is when an employee has two or three meetings on the downloaded data sheet. I therefore need excel to populate the earliest date into 'Meeting 1' column on the main spreadsheet, the next date into 'Meeting 2' column on the main spreadsheet and so on etc.
Apologies if this does not format properly as this is the first time I'm attempting to use XLS2BB - here is a basic mock version of what the downloaded data sheet will look like:
| Book1 | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Emp. Number | Meeting Date | ||
| 2 | 123 | 1/1/22 | ||
| 3 | 234 | 5/10/22 | ||
| 4 | 345 | 9/20/22 | ||
| 5 | 123 | 5/15/23 | ||
| 6 | 234 | 12/8/23 | ||
| 7 | 345 | 4/29/23 | ||
Sheet2 | ||||
Here is a mock version of what the main central spreadsheet will look like - this is where I would like the meeting dates to show:
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Emp. Number | Meeting Date 1 | Meeting Date 2 | Meeting Date 3 | ||
| 2 | 123 | |||||
| 3 | 234 | |||||
| 4 | 345 | |||||
Sheet1 | ||||||
