Hello All, I am stumped. I have textbox's from many files that I'm working on pulling into a single document, the only issue I have is this. I need to have some vba code to check if the textbox is empty. When completed the main file will pull in data from up to four workbooks. I do not want to pull in an empty textbox and waste space on the page that will be printed. This will obviously not be a good looking finished product. I have attached a single department sheet with dummy data in it. Each department sheet allows them to populate up to a month of data in one sheet and when my main file opens the department sheet it pulls the textbox for todays date to Linked Textbox Sheet and imports it into the main file.