Macro for extracting data from multiple sheets if cell has text

Hi there,

I have a workbook with multiple sheets each containing prices (and other information) for certain items. I need to extract data from multiple sheets onto one sheet called "master". But the issue that I have is I need the data to be extracted from only the specific cells that have text in it from multiple sheets. I am attaching a workbook for your reference. In that worksheet, Price1 and Price2 are the sheets from which I need to extract the information. "master" is the sheet where I need the data to be extracted. Sample data is provided within the attached worksheet. Can I get VBA code for the requested, please?

Thanks in advance.

Plasma33

Maybe :

Please Login or Register  to view this content.

Do you change your data layout ? I don't get any error :

Hi karedog,

Thank you for clarifying this for me. It's working as it should but it doesn't work when I input some new texts. The code doesn't update the new ones apart from the ones that we already have. Also, can you please automate the price category section (i.e. Field 1) too. At the moment it's static. Can you please make sure that the code works for any dynamic data and not just for the data that I provided. I have attached the excel file for your reference. Thanks heaps.

Plasma33

You are welcome, thanks for the rep.points.

Please check the attached file.

Because that is what on your manual calculation on your original file on post #1.
In your original file, for Product Category 2 there are 2 data matched(row 8 and 12), but on your manual calculation on sheet master, you only list one, so I assume that you only want to display only the first matched item.

Please Login or Register  to view this content.