what im tring to do is export certain fields of excell and importing
them to another datat base called fime maker pro.

So for the past 2 years i have set up 2 shhets per file,
Sheet 1 for the manager to enter data
Sheet 2 with only items that i need exported

now i need to go furtur back then 2 yrs, and the files from 2 yrs and
back, i never created sheet 2, only shhet one

basically what i was tring to do is create a sheet 2 on old files,

I copied sheet 2 from current file and pasted into sheet 2 old file,
hoping to get the data from sheet 1 of into sheet 2

After i did that, instead of taking the data from old file sheet 1 and
pasting into old file shhet 2,
Its taking the new file sheet 2 and pasting it into old file shhet 2

Thanks


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