Excel boffins - your needed!

1 watcher

FRU (KeepTheFaith) Aug 2018 11:54am, 30 Aug 2018 11,993 posts	0 FRU (KeepTheFaith) Ok... I think this may be either a Vlookup or a "IF" Statement I have a sheet of data where the headings can change daily (it's basically a CSV file generated by a product using their own form of data lookup) - we need to structure this so that we only see data from 4 constant headers (they come in a different column each day dependent on what other data is added or subtracted each day SO... what I need to do is create a second sheet - and in that sheet say "please go to sheet one and if you see "THIS" Header being it and all data underneath it into this sheet please"- I can record that into a Macro but I'm not sure how to set the formula for the looking & bringing into sheet 2 Any ideas?
fetcheveryone Aug 2018 11:55am, 30 Aug 2018 19,756 posts	0 fetcheveryone Try this thread: fetcheveryone.com/viewtopic.php?id=47111
Aug 2018 12:20pm, 30 Aug 2018 First-time poster!!	0 [Removed by moderator]
oumaumau Aug 2018 12:22pm, 30 Aug 2018 979 posts	0 oumaumau It'll be done form of hlookup for the column heading you want, then copy to me sheet in order. Hth
oumaumau Aug 2018 12:23pm, 30 Aug 2018 980 posts	0 oumaumau Pesky mobile typing on a train... Some, and the respectively
iRicey Aug 2018 12:26pm, 30 Aug 2018 235 posts	0 iRicey is it possible to report that spam member/post?
FRU (KeepTheFaith) Aug 2018 12:26pm, 30 Aug 2018 11,994 posts	0 FRU (KeepTheFaith) Cool - thank you! Exactly what we needed.. onto it now I knew one of you would know!
GregP Aug 2018 12:36pm, 30 Aug 2018 106,236 posts	0 GregP Thanks for the signpost Fetch thumbsup
Sep 2018 1:47am, 29 Sep 2018 First-time poster!!	0 [Removed by moderator]