Search for Cell and Copy row below
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone and thank you right away for your help.
Currently I am facing the following problem:
I want to find a specific cell (here B-Area in Column 3) and cut the entire column 5 (starting in the row where i found the String "B-Area") and paste it in Column 7.
It is pretty difficult to explain therefore attached two screenshots:
Thats how it looks rn:
Thats how it currently looks:
And that is the format I need to move on:
I would really appreciate your help.
Best regards
manfredkarl
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi!
If you could attach the sample data that would be great!
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Ben,
of course. I'm sorry.
Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'd use something along these lines:
The Multi-Row Formula tool checks to see which row 'B-Area' starts on, then flags that row and all rows below it. The Formula tool then copies the contents for every row that is flagged and empties out the cells where the data was prior. The Select tool at the end is just to drop the flag column I created with the Multi-Row.
Good luck, hope it helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much. Worked perfectly this way.
