Hello,


I have a report generated on sheet1. I need to rearrange this data for evaluation purpose in sheet2. (See attachment).
Each time a report is generated it runs into over 100+ rows. All the row need to be captured in sheet2.
Sheet2 will have a template to capture the data from sheet1, rest of the rows to be copied in the similar format as the first set of data, the only way to do this is I believe is by creating a macro.

I would appreciate if someone could help me create a macro. I hope I have explained this well.
Thanks in advance.
FLDS

Attached Files

Requirement.xlsx (12.2 KB, 8 views)

hi flds,

You can do the entire thing with offset formulae. See attached. Simply copy the output block down as far as needed.

Attached Files

Requirement.xlsx (13.0 KB, 10 views)

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

Hi Paul,

Thank you so much for the formula. This is what I wanted.

One question is it possible, to have a blank row after every set of data?

Would appreciate you reply.

Thanks
FLDS

Simply do a Find/Replace with:
Find = /6
Replace = /7
and insert your spacer rows.

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

Thank You, Paul

Brilliant ! I salute you.

FLDS