Hi all,
I wonder if someone could help me please?
I have a large list of data (often 30,000+ rows) and I have to make sure that for each month there is a row of data for each name and for each daypart segment. If a daypart segment if missing for a name then I need to add it by inserting a row in the appropiate place, enter the missing data and put 0 as a total figure. Attached is a workbook which I hope will help to understand!
For example, in the attached workbook the first problem is on row 33 (highlighted in yellow). There is a missing daypart segment, Name2 has no 06:00:00 - 08:59:59 data.
In my head I was thinking of a code like this:
There are several problems with this.
First of all it doesn't work!
Second I am worried as it is using a loop on several throusand rows and this may take a very long time(?)
The daypart segments change and the number of daypart segments but are always defined in the next sheet, the heading names are always the same and in the same position and the data is always in the order as the daypart segments in the next sheet.
This a big problem which I often come across in my new role so would REALLY appreciate any help that can be given!
Thank you!
Bookmarks