.: Oxborrow.biz :.


.: Supermarket Phone No. Data :.


Recently I was approached so solve a problem for a supermarket store which concerned their mobile phone system. A list of mobile phone numbers and length of time the phone was used needed to be cross referenced with a list of stores numbers to understand if the mobile phones were being used correctly.

The easiest way for me to accomplish this was to create a macro within Microsoft Excel which would allow the user to paste their data straight into a sheet and process this against the list of store numbers.


Mobile Numbers 1

Store phone numbers

This is where the user maintains a list of store numbers which the macro will check against.

Mobile Numbers 2

RAW data

The user adds their data directly from their system into this sheet. The macro will then cross reference this data against the mobile numbers supplied.

Mobile Numbers 3

Summary Output

The macro produces a new sheet with all the data combined and also a summary sheet as seen here.