Hi,
I have about 10 files of the same appearance. I would like to pick up certain information from each file and then combine that into a new file.
The program should search for a certain heading, in this case for instance "Capital employed". Copy the information under "Capital employed" and paste it into the new file.
The infomation under each heading is separated from a new heading by at least 2 blank lines.
Enclosed is a pick up from 3 files showing the general appearance.
Can someone help me with a suitable macro?
Best regards,
Jan
Bookmarks