Quote Originally Posted by kroz
Let me see if I understand this correctly.
You have a workbook called "house1" (by the way, what's the name of the sheet you are working in) and you have some data here.
After you finish inserting the data you want to open another workbook.. but you don't really know where it is? That's what i understood from your post.
I now where is, but dont now how Vba can find it, workbook is "house1", i did not change name of sheet, but let call him "green".
For me its so complicated to made this macros, I spend more then 10 days and make big nothing.