Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2015, 09:37 PM
PRA007's Avatar
PRA007 PRA007 is offline Extract data based on pattern with respect to specific column Windows 7 32bit Extract data based on pattern with respect to specific column Office 2010 32bit
Competent Performer
Extract data based on pattern with respect to specific column
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

Sorry for not making it clear

I want data to be replaced in main.xlsx to make it final.xlsx, can be found at:

Final.xlsx should look like this.



Code:
4984887	19950115	Patent Expired for Failure to Pay Maintenance Fees.
4984887	19940823	Maintenance Fee Reminder Mailed.
4984887	19910506	Payor Number Assigned.
4998743	19950312	Patent Expired for Failure to Pay Maintenance Fees.
trimmed final file can be found at:
https://sites.google.com/site/rtsk2015/excelforum
file name. Final.xlsx
Reply With Quote
Reply

Tags
excel vba, excel vba xml import loop



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract data based on pattern with respect to specific column Extract Data From Text file based on Pattern PRA007 Word VBA 13 11-01-2015 11:20 PM
Powerpoint show specific data based on selection Christov PowerPoint 1 05-14-2015 09:35 PM
Extract data based on pattern with respect to specific column How to Extract Data from table based on pattern. PRA007 Word Tables 4 03-17-2015 11:05 PM
Extract data based on pattern with respect to specific column Excel VBA Macro - Deleting Specific Data based on criteria MD011 Excel Programming 3 12-10-2014 02:15 AM
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values bolandk Excel 1 05-15-2014 08:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:43 PM.


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