Hi, I am looking for some excel macro when run it will look in column A for the value "DISCOUNTED SECURITIES" and "FIXED INTEREST" and cut all the cell values between these two words and place them in Column B starting from top. Sample file attached, needs the middle values to be placed in next column. kindly helpBook1.xlsx
Example
Column A
Val1
Val2
Val3
Val4
Val5
DISCOUNTED SECURITIES
ABG1711A
ABN1702B
ABN1805B
FIXED INTEREST
sdasda
ABG1711A
Hi, fasrose,
if both item only appear once like in your sample you may take an approach like
If there is more data in your real workbook and the items appear multiple times you should use Find/FindNext for a macro.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks a lot, its working. You are great
Hi, fasrose,
thanks for the feedback. Could you mark the thread as Solved via Thread Tools over the first post?
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks