Hello, im sure someone will have a very simple solution for me

This will be very tricky to explain, i will do my best

Im working on many old files from excell, so in the new files, i set up
2 sheets, one for the data entry person and the other for me to only see
what i really need, sheet 2 is only items that are copied from sheet one
that i need to see.
So what i need to do with out copy and past to old files, but when i do
that it is copy and pasting the curent file info instead of the old
sheet 1 info

Example (i copied this from one file to another and it also pasted the
file one info, instead of sheet 2 new file,
When pasting i want to get rid of the checkout blank.xls

='[Checkout Blank.xls]CHEKOUT5'!$B$3

Thanks for your help


--
zgclub
------------------------------------------------------------------------
zgclub's Profile: http://www.excelforum.com/member.php...o&userid=31350
View this thread: http://www.excelforum.com/showthread...hreadid=510472