I have a sheet with lots of data. I need it to look up a certain text in A:A. when found it needs to copy it to sheet 2. But it also needs to copy some other cells of sheet 1 to sheet 2. I added a excel sheet showing how the data is provided and on sheet 2 is showing how it needs to be arranged/ converted to. Only noted two items but sheet is in real has many many many more items/lines.
On attached file is stated untill empty cell, but that should be untill no more found.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Works like a charm. Thank you so much.
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks