Hi,

I would like to know whether my goal can be achieved with a macro instead of formula.

I did what I wanted with an array index match formula, however it literally took a week to calculate.

The spreadsheet is about 30mb currently

I reduced the data to only one month (1990) however it is still about 13mb.

I had to upload it to my outlook public folder but cannot post it here.

Sheet: Hours

- 12 different sources of data exist (columns C-N) per hour, per date between Jan 1990 and Dec 2016.
- Time/date rows where no data exists are missing and it is not a complete set of time/date rows (234,229 rows of data).
- Blanks and zeros exist in the data.

Sheet: Full-hours_1990-2016

- This is complete list of times/dates (236,688 rows of data)
- It is empty of data at the moment. This is where I want to place the data form the first sheet.

My goal is place the data from sheet 'Hours' to sheet 'Full-hours_1990-2016 into the relevant time/date rows.

Blanks need to show as blanks.

Zeros need to show as zeros.

Can this be achieved with a macro and will it be just as slow in calculating?

Thanks

## Bookmarks