Thread: Moving Data between spreadsheets

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

MarvinP,

I appreciate the suggestion however, I need this to be as automated as possible...Spreadsheet A will actually be an export from a website, and Spreadsheet B actually contains a lot of other data that is gotten from other locations...so doing the filter really is not an option...

I really need a function that will find the data and move it based on the 2 criteria...

Thanks though MarvinP I like the idea, just not going to work this situation.

Demtro