I'm trying to reformat a document which is set up to archive various values (i.e. plant's nat. gas usage, water usage etc.) by period and date (so for example, P1-1 is period 1 week 1), which occur on different rows in the blocks. The person set the data up so it occurs in blocks of 10 weeks followed by a space then another group of data. When I use the record macro tool, the first row values are changed perfectly to columns but the second columns that are transposed will always return #Value! (even though I've selected the use Relative Referencing)... HELP?