I am hoping to use Vlookup to retreave an entire row of values from the previous sheet. The workbook is based on Projects (records) from month to month. I have data from Column A - Z and Row data to 300. Each row is a record and the record number (Vlookup Value) is in column "D". The idea is to show the user in row 1 of the active sheet, the whole record from the previous month based on the selected active cell in the active sheet (current month). The cells in Row 1 will have the Vlookup formula and be returning the previous record values from the previous sheet. The column headers in Row 1 (Vlookup Row) match the column headers for all 300 records. Row 1 is simply used to show previous months data for the selected cell/record.

When the user puts his curser in cell S3 (Active Sheet), Vlookup in S1 (Active Sheet) will show the data from that record# "D3 Active Sheet" from the previous sheet in S1. I'm thinking maybe a Vlookup formula in each cell for Row 1 might do it. I need help with the "Active Cell" portion of the formula. I would also be able to use VBA if more appropriate.

Thank you for any ideas to get me started.