Hi there,

I have a workbook with multiple sheets each containing prices (and other information) for certain products. You can call this workbook as a price book. 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

Attached Files

Sample_plasma33_msoffice_forums.xlsx (13.2 KB, 13 views)