Hello, i have a simlar querie,

i have two spreadsheets (spreadsheet1 + spreadsheet2) holdin
identical information but the two spreadsheets sort the informatio
into different workbooks depending on two different dates. i would lik
a vb that means i only have to put the information into spreadsheet1 an
it to put itself inthe corect workbook in spreadsheet2. is thi
possible?

in spread sheet 1 the information is put in order of the date w
recieve the file

in spread sheet 2 the information is put in order of the date we finis
with the file.

we have a workbook for each month. i need the info in spread sheet 1 t
put itself in the right month (workbook) in spreadsheet 2,

hope you can understand what i mean.

thank you

David

--
David
-----------------------------------------------------------------------
David M's Profile: http://www.excelforum.com/member.php...fo&userid=2655
View this thread: http://www.excelforum.com/showthread.php?threadid=40055