I have a SQL query that generates a table of information. I save this output as Sheet 1.
I have a Wizard in Excel, which I am using to extract the information generated from Sheet 1. I save this as Sheet 2.
So, imagine Excel document, with 2 tabs = Sheet 1 & Sheet 2. Sheet 1 is the output from the SQL, Sheet 2 is the Invoice Wizard, where the data comes from Sheet 1.
Now, the data is as such that, Column A has the employee's names. And Column B has employee's travel expense.
In Sheet 1, generated from SQL, the SUMMARY of these reimbursements for EACH employee is at the anywhere in the list of expenses for that particular employee.
Wherelse, I would like to have it at the top of the list.
Meaning,
If column A (employee name) same value, then col B (employee expense) beginning with SUMMARY OFFSET associated with col A, moves to the top row.
I have attached an image for review.
I don't think I can use VLOOKUP for this. Any suggestions?
Bookmarks