How can I transfer information from sheet 1 to sheet 2. For example: Sheet 1 shows Column B as "Employee #" and Column C as "Name" and Column D as "Sales Amount". I would like to input the unique employee # in Sheet 2 A2 and have the information auto fill B2 (Name) and B3 (sum Total Sales).
Please help!!
Please help!!