Tag Archives: reference

Let’s assume, you got 12 worksheets named with year and month. Each sheet contains several values for every day. To put them all together I recommend a combination of the Excel functions CONCATENATE and INDIRECT (the real dynamic duo if there wasn’t one before).

Continue reading

Posted in Excel | Tagged , , , , , | 2 Comments