I have documents that I need certain pieces of information copied into an excel spread sheet. The documents may vary on length, but most of 20 - 30 pages log. If I do a good old copy paste into excel The data is all over the place, but it is grouped (somewhat) so that I know what goes with what.



Attached is a small scale sample of my data. The sheet named "Raw" is exactly how my data looks. The sheet named "Desired Format" is how i would like it to look at the end of the day.

Is what I'm looking for possible?

Attached Files

Sample Book.xlsx (10.7 KB, 16 views)

In A2 put: =OFFSET(Raw!$B$3,(ROW()-2)*8,,)
In B2 put: =OFFSET(Raw!$G$6,(ROW()-2)*8,,)
In C2 put: =OFFSET(Raw!$E$6,(ROW()-2)*8,,)
In D2 put: =OFFSET(Raw!$D$6,(ROW()-2)*8,,)
In E2 put: =OFFSET(Raw!$C$3,(ROW()-2)*8,,)
Copy all formulae down as far as needed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

My apologies for taking so long to respond. Thank you for that formula. It was exactly what I needed. Worked like a charm