Hi,
I am looking for a code that will search for previous weeks date from current date in a word file and copy the data below that date.
Example: Word File
(14th January– 18th January)
Redemption
• Morgan Stanley .
(12th February – 19th February)
Redemption
• Landgrove Synthetic
(4th – 8th March)
Unwound
• Greylock Synthetic
(23rd-30th april)
Accelerated Repurchase
• Tiers Funding Trust Certificates
...............
So if today is 2nd May, the macro should look for previous weeks date (i.e (23rd-30th april)) and copy the data below that.
Bookmarks