Imdabaum
05-05-2010, 09:51 AM
Can I add a little dynamic to this post? I have an excel spreadsheet that goes to AD on sheet1, and AL on sheet2. I've copied the headers and pasted them transposed in A(sheet2 headers) B(sheet1 headers), and used a VLookup on C to find all common headers.
I have been instructed to create a table based on the common fields, but rather than hunting from A:AL I'd like to just hide all the columns that don't appear in sheet3!C. Hope that makes sense, but I've dealt with Access for a while... I'd like to learn how to maximize my usability with Excel and this seems like a good training exercise.
I have been instructed to create a table based on the common fields, but rather than hunting from A:AL I'd like to just hide all the columns that don't appear in sheet3!C. Hope that makes sense, but I've dealt with Access for a while... I'd like to learn how to maximize my usability with Excel and this seems like a good training exercise.