Excel boffins - your needed!

1 watcher
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?
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
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
11,994 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
106,236 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 join the discussion, sign in or join us.

About This Thread

Maintained by FRU (KeepTheFaith)

Related Threads

  • excel

The Doctor K Cup

This year sees the fifth edition of our annual challenge in memory of the Fetchies who have sadly passed away. It's named after Doctor K, who died of pancreatic cancer in 2017

Are you doing the right training?

See typical mileage, pace and long run stats for every distance and goal. See a comparison with your own training.

Heart Rate Analysis

See your heart rate training data from the last 12 months broken down in technicolour.

Flat as a pancake?

We've collected thousands of your reviews from events, and worked out which races give you the best chance of a fast time!


Back To Top
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 109,069 Fetchies!
Already a Fetchie? Sign in here