In one sheet I have a large set of data, I need to copy any column that contains "X" in row 21 and transpose that into the next available row in a separate workbook "PC OPP", Into the sheet "Cash". I have tried for a few days now, and the issue seems to be with the transpose section. Anybody have any ideas?
Bookmarks