Demtro
New member
Hi everybody,
I have attached 2 dummy spreadsheets to give you an idea of how i need stuff moved...
Spreadsheet A Contains thet data that I need moved into spreadsheet B...
In spreadsheet A are Dates, names, offices, sales, and commiussions...
In spreadsheet B is a worksheet for one date, a second worksheet for the second date and a 3rd worksheet for the 3rd date. I also have the names of all 3 people in spreadsheet B worksheet 1, 2 and 3.
basically what i need is this..I need a function that I can place in the Office, Sales and Commisions cell and have it copy over that employees office, sales and commisions for the date specifies in the worksheet.
spreadsheets are attached, I have researched this for a couple weeks, on my own and need some help
thanks
Demtro
I have attached 2 dummy spreadsheets to give you an idea of how i need stuff moved...
Spreadsheet A Contains thet data that I need moved into spreadsheet B...
In spreadsheet A are Dates, names, offices, sales, and commiussions...
In spreadsheet B is a worksheet for one date, a second worksheet for the second date and a 3rd worksheet for the 3rd date. I also have the names of all 3 people in spreadsheet B worksheet 1, 2 and 3.
basically what i need is this..I need a function that I can place in the Office, Sales and Commisions cell and have it copy over that employees office, sales and commisions for the date specifies in the worksheet.
spreadsheets are attached, I have researched this for a couple weeks, on my own and need some help
thanks
Demtro