#1
|
|||
|
|||
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 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 |
Tags |
data extraction, macro, vba macro |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving cell data between sheets in a workbook | Little Mike | Excel | 5 | 05-05-2016 06:22 AM |
Need Macro to Convert Text To Numbers in Multiple Sheets | rsrasc | Excel Programming | 4 | 04-11-2016 06:21 AM |
Extracting multiple words from one cell into individual rows while copying all other data | randyaserve | Excel Programming | 4 | 10-05-2015 09:52 AM |
Extracting data from a cell with multiple lines of text | MMT | Excel | 9 | 02-12-2015 09:18 PM |
Excel 2013 – need help extracting date and time from text cell plus more. | Art Mann | Excel | 1 | 07-18-2014 09:55 PM |