I am importing a spreadsheet that has multiple columns (# of columns changes every time i import it). I would like to find a specific title i.e. 'Item Total" within row A and have this entire column transferred into a different sheet. I've played with Exact,Match and lookup... but just can't seem to get anything to work. Please help!!