Extract text from different tabs?

[BRguy]

I have a file with 92 tabs and I need to extract text from some of them.

All of the tabs have certain references, something like this:
GL Period Properties XLF PageTitle
GL Period Properties XLD GLPeriodLabel
GL Period Properties ZLD GLPeriodNumberLabel
GL Period Properties ZLD PropertiesLabel
GL Period Properties ZLD DescriptionLabel
GL Period Properties ZLD CurrentPeriodLabel
GL Period Properties XLO YearLabel
GL Period Properties FLP DateFromLabel


I only need the text of the cells that are in the same row of "ZLD".

Is there any way to do this?

[queuesef]

Yes. Post an example (upload - under GO ADVANCED) ~ I don't visualize what you're attempting to show....a concrete example would surely help!!

[BRguy]

Yes. Post an example (upload - under GO ADVANCED) ~ I don't visualize what you're attempting to show....a concrete example would surely help!!

sorry, I can't upload it, but this is the layout:
A-------------------------B---------C
GL Period Properties----XLD-------PageTitle
GL Period Properties----XLD-------GLPeriodLabel
GL Period Properties----XLD-------GLPeriodNumberLabel
GL Period Properties----DLP-------PropertiesLabel
GL Period Properties----PAL-------DescriptionLabel
GL Period Properties----IAA-------CurrentPeriodLabel
GL Period Properties----JAK-------YearLabel
GL Period Properties----IAO-------DateFromLabel
GL Period Properties----LKA-------DateToLabel
GL Period Properties----IAO-------DateClosedLabel


I need to extract only the text after XLD (for instance, PageTitle, GlPeriodLabel) in many different sheets.

Is there any to do this?

[AliGW]

Yes, you can upload it (or a sample that resembles it - we don't need or want to see sensitive data).

Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[alansidman]

When you say extract, what does this mean? Will the data be copied and pasted somewhere? highlighted in Yellow? Help us to help you by being explicit in your requirements. We are experts here in excel but do not do mind reading very well if at all.

[BRguy]

Yes, you can upload it (or a sample that resembles it - we don't need or want to see sensitive data).

Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Thanks Ali, but I'm still concerned as this is a file from a client for which I'm working with an NDA.

When you say extract, what does this mean? Will the data be copied and pasted somewhere? highlighted in Yellow? Help us to help you by being explicit in your requirements. We are experts here in excel but do not do mind reading very well if at all.

English is not my first language, I apologise. However, as far as I know, to extract means to remove something, so, yes, I need to extract the content into a different file.

[alansidman]

Deleted as I misread your needs. Will repost with correct solution.

[BRguy]

Deleted as I misread your needs. Will repost with correct solution.

I did that, but I get a prompt with the text that should be searched "XLD" and a blank area to type. I tried inserting anything and pressing OK but nothing happens. What should I look for here?

[alansidman]

Here is the correct updated VBA. Make sure that you create a sheet named "Result"

Please Login or Register  to view this content.

How to install your new code

• Copy the Excel VBA code
• Select the workbook in which you want to store the Excel VBA code
• Press Alt+F11 to open the Visual Basic Editor
• Choose Insert > Module
• Edit > Paste the macro into the module that appeared
• Close the VBEditor
• Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

• Press Alt-F8 to open the macro list
• Select a macro in the list
• Click the Run button

[BRguy]

Didn't work either. I'll give up and do it manually.

Thank you and everyone else for your time and patience.

[alansidman]

Here is the sample workbook I developed using your abbreviate data.

[queuesef]

'alansidman's logic works!!! 1) I believe there is a typo in the original request (you ask for ZLD, when later you mention XLD in your example file). 2) The macro search works - BUT type in the EXACT letters you want (including capital letters ~ ZLD and NOT zld.). If needed after macro, you can delete duplicates. Please give alansidman credit as that solution works