Hopefully the title is specific enough....
So I'm trying to write code to search through a file I've loaded, which will never be the same in terms of data (width, length, whats actually in it). I want it to find the title of a column of data, copy the title all the way to the last row of data for that column and then paste it into another sheet of the workbook. I've tried many different ways of searching, copying, pasting but I can never get it to go past just finding the title and copying/pasting only the title into the next spreadsheet. In the following code I've specified a column to pull the data from but I am unsure if it will always be the same column. This is my nth time of rewriting multiple different codes, unfortunately I haven't saved any of my previous attempts (you live and learn) so this one is just basic....anyone have any ideas?
Please Login or Register to view this content.
Bookmarks