let say i have 2 workbooks. i just want to manage my data on one workbook but i need specific data to populate on a separate entire workbook. i have heard that it is posible as long as you open the 2nd workbook and then close it. is this possible? if so how? i am tired of copying and pasting all this data.