First off I want to thank whoever upfront who can help me with this problem. I am trying to create a file that is very user friendly for some colleagues. I am manipulating data across 10 different "users" so using if(equals) statements to first isolate the data per user. Then I am taking this data and having it link to a worksheet per user. The problem that I am running into is that when I link the data over there are obviously some blank rows because the data has not been sorted and my if(equals) formula returns "" if false. My colleagues will struggle with data sorting each time this report comes out. In researching this problem it appears that the only way to solve this problem will be through a Visual Basic Editor formula. Prior to researching this issue I thought of myself as an excel wiz, but am being completely humbled trying to figure our VBE. If VBE is the way to go beyond help me with this problem I would truly appreciate a suggestion for how I could become proficient with VBE. Are there good tutorials or books to read up on to get the hand of this stuff? Thanks so much and appreciate the help.