Copy data from the next row after specific word

vikkaaa1

New Member
Joined
Jan 12, 2021
Messages
2
Office Version
  1. 365
Platform
  1. MacOS
Hello,
I need to copy the text from the next row after some specific word in a previous row and put all the copied data into a new sheet. Basically, I have many rows with different things, and there are some rows where are some key words like "Values" and in the next row is the needed text, and I need all those rows with texts in a different sheet.

I really need help with this, so I hope someone can help me!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
It helps others to understand if you can upload workbook or at least a sample capture of how your worksheet looks like
 
Upvote 0
Welcome to MrExcel Message Board.
Please upload your Example file & Desired results with XL2BB ADDIN (Preferable) or upload at free hosting site e.g. www.dropbox.com , GoogleDrive or OneDrive and Insert link here.
 
Upvote 0
Sorry. I don't access the link because I don't account on rtucloud-my.sharepoint.com, Please upload at the other site.
 
Upvote 0

Forum statistics

Threads
1,214,853
Messages
6,121,935
Members
449,056
Latest member
denissimo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top