Can this be done using VBA?
Ok - I have a spreadsheet that is exported from an application I use at work. It formats the data in a manner that makes it really difficult to manipulate but I think I've worked out a solution that gets me what I need; only it is very tedious.
The data starts in row 16 of the sheet. There is a name in row 16 and in every 10th row after that. Then there is a correpsponding value for each name that is 6 rows beneath the name and in a different column (because the application merges cells, etc. the values aren't on the same row as the name and trying to unmerge things creates more problems).
So, name1 begins in cell A16 and its corresponding value is in cell D22. The next name value is in A26 and its corresponding value is in cell D32, etc. etc. What I would like to do is to put the corresponding value on the same row as the name in column J. Now I have 1600 rows of data so going one by one through each would be exceptionally tedious.
What I would like to do is beginning in cell J16, return the corresponding name value for name1 there and go every 10th row until the end of the data set. But I wouldn't want to do that manually using an offset formula because I'd have to do that 1600 times.