I am setting up a a shared workbook that will have a different user populating each of the different worksheets (6 worksheets in all). The first worksheet will contain at least two of its columns that will need to be replicated in the other worksheets so that the other users can then add extra data associated with their specific area of responsibility. Is there a way of replicating an entire column from one worksheet into another. I have tried using the =Sheet1! function in sheet2 but if I use this I need to paste the formula down across vacant cells in sheet2 so that when an new entry is made in sheet1 it appears automatically in sheet2. However when I paste the formula down through the cells in sheet2 I get zero entries on the rows where there are no related entries in sheet1. I can't therefore use this method because I will need to import the Excel sheets into Access at the end of each month and the zero entries will generate unnecessary records in the database.

Is there another way of replicating columns in multiple sheets which won't invoke additional blank records in the additional worksheets?

Any advice would be appreciated