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