Finding Specific Columns from Large File

[mcorydon]

Hello, Every morning I download a large file and delete all but 4 columns, I made a macro to delete the columns that are unnecessary but lately the file I download has had the columns in different orders so my macro is no longer working. Is there a formula I can use that I can then record a macro from that will essentially search through row2 and find the 4 relevant columns regardless of where they are located? For example if row 2 had all of the letters of the alphabet scrambled up ( "f" "d" "s" "k" "l" "w" etc...) the formula would pull "r" "u" "p" "n" and all data in their respective columns. Really hope that makes sense

 

[hiker95]

mcorydon,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


1. Do the 4 columns contain unique titles?

2. What row contains the titles?


So that we can get it right on the first try:

Can you post a screenshot of one the actual raw data worksheets?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot try one of the following:

Excel Jeanie
Download

MrExcel HTML Maker
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here