Welcome To Fetcheveryone

Our awesome training log doesn't hide its best features behind a paywall. Search thousands of events, get advice, play games, measure routes, and more! Join our friendly community of runners, cyclists, and swimmers.
Click here to get started
Already a Fetchie? Sign in here

Excel boffins - your needed!

1 watcher
Aug 2018
11:54am, 30 Aug 2018
11993 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?
Aug 2018
11:55am, 30 Aug 2018
19756 posts
  • 0
fetcheveryone
Try this thread:
fetcheveryone.com/viewtopic.php?id=47111
Aug 2018
12:20pm, 30 Aug 2018
First-time poster!!
  • 0
BLOCKED
[Removed by moderator]
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
Aug 2018
12:23pm, 30 Aug 2018
980 posts
  • 0
oumaumau
Pesky mobile typing on a train... Some, and the respectively
Aug 2018
12:26pm, 30 Aug 2018
235 posts
  • 0
iRicey
is it possible to report that spam member/post?
Aug 2018
12:26pm, 30 Aug 2018
11994 posts
  • 0
FRU (KeepTheFaith)
Cool - thank you! :-)

Exactly what we needed.. onto it now

I knew one of you would know!
Aug 2018
12:36pm, 30 Aug 2018
106236 posts
  • 0
GregP
Thanks for the signpost Fetch *thumbsup*
Sep 2018
1:47am, 29 Sep 2018
First-time poster!!
  • 0
BLOCKED
[Removed by moderator]

Got something to say?

To contribute to the discussion, you need to either sign in or register as a user.

About This Thread

Maintained by FRU (KeepTheFaith)

Back To Top

Close