for an ad-free Fetcheveryone experience!

Excel boffins - your needed!

1 watcher

FRU (KeepTheFaith) Aug 2018 11:54am, 30 Aug 2018 11,993 posts	Quote Pin 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	Quote Pin fetcheveryone Try this thread: fetcheveryone.com/viewtopic.php?id=47111
Aug 2018 12:20pm, 30 Aug 2018 First-time poster!!	Quote Pin [Removed by moderator]
oumaumau Aug 2018 12:22pm, 30 Aug 2018 979 posts	Quote Pin 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	Quote Pin oumaumau Pesky mobile typing on a train... Some, and the respectively
iRicey Aug 2018 12:26pm, 30 Aug 2018 235 posts	Quote Pin iRicey is it possible to report that spam member/post?
FRU (KeepTheFaith) Aug 2018 12:26pm, 30 Aug 2018 11,994 posts	Quote Pin 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	Quote Pin GregP Thanks for the signpost Fetch thumbsup
Sep 2018 1:47am, 29 Sep 2018 First-time poster!!	Quote Pin [Removed by moderator]