Hi, i'm somewhat new at excel, i know the basics, and i've tried a few macro codes. I am trying to have multiple workbooks linked together so that when i enter a new row of information in my master inventory list, it is automatically entered into the other workbooks, in the very next row that is empty (at the bottom of the list). Each workbook has the same layout (same column headings) i just don't need every item in my inventory list to be on every other workbok (ex. Sold list,bought list,) is this possible?