Automatically Sort Data - Visual Basic Editor

[halcott]

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.

 

[pbornemeier]

When I started working with VBA in Excel 2003 I found these books to be useful:

Excel 2003 Power Programming with VBA (Excel Power Programming With Vba) by John Walkenbach
Professional Excel Development by Stephen/ Bovey, Rob/ Green, John Bullen (Paperback - Feb 11, 2005)
Excel 2002 VBA: Programmers Reference by Rob Bovey, Stephen Bullen, John Green, and Robert Rosenberg (Paperback - Sep 26, 2001)

I still recommend them, but would also have you consider this book:

VBA and Macros for Microsoft Excel

which would seem to fit your needs.

Check out the store: The MrExcel Store - Welcome to The MrExcel Store
for mor books and bundles.