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