Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2016, 12:52 AM
plasma33 plasma33 is offline Macro for extracting data from multiple sheets if cell has text Windows 7 64bit Macro for extracting data from multiple sheets if cell has text Office 2010 32bit
Novice
Macro for extracting data from multiple sheets if cell has text
 
Join Date: Jul 2014
Posts: 2
plasma33 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Sample_plasma33_msoffice_forums.xlsx (13.2 KB, 11 views)
Reply With Quote
Reply

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
Macro for extracting data from multiple sheets if cell has text 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
Macro for extracting data from multiple sheets if cell has text Extracting data from a cell with multiple lines of text MMT Excel 9 02-12-2015 09:18 PM
Macro for extracting data from multiple sheets if cell has text Excel 2013 – need help extracting date and time from text cell plus more. Art Mann Excel 1 07-18-2014 09:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft