How to load data from various sheets into one master sheet?

Natasha - Nov 5, 2017 at 02:59 AM - Latest reply: vcoolio 1184 Posts Thursday July 24, 2014Registration dateModeratorStatus August 11, 2018 Last seen
- Nov 12, 2017 at 01:28 AM
Hi Guys,
Hope for an expert in excel who can help!!!

I have a spread sheet that contains:

1st sheet is master file with the number plate number on first column, date of first notice in second column, date of 2nd offence in 3 rd column and so on until 6th notice.

I have other sheets named by month that contain: 1st column Number plate, 2nd column 1st day of the month and so on until the last day of the month.

When the bridging of car park law is noticed, the security guy puts "x" in the day it happened column. There are thousands of number plates and only some of them perform the offence. All the time different number plate, different date...

What I need to get my head around is how to make the data from those monthly sheets flow into my Master sheet. 1 st offence is considered any within 7 days from Wednesday to Wednesday.

Can't get anywhere as its too much data and I am not an expert in Excel. I can build pivot table, do a v-look up but non of these seems to be working :( Will greatly appreciate any help!!!! Thank you in advance!
See more 

Your reply

1 reply

vcoolio 1184 Posts Thursday July 24, 2014Registration dateModeratorStatus August 11, 2018 Last seen - Nov 12, 2017 at 01:28 AM
0
Thank you
Hello Natasha,

Have you sorted this one out or do you still need help with it?

Cheerio,
vcoolio.
Respond to vcoolio