Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2014, 10:21 PM
macropod's Avatar
macropod macropod is offline need VBA to Transpose the Data from excel to word based on given criteria(status) Windows 7 64bit need VBA to Transpose the Data from excel to word based on given criteria(status) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


Your description and data suggest a mailmerge from Word. No macros required. All you need do once you've created the mailmerge main document is to apply filtering there to restrict the output to the particular records you're interested in - filtering in Excel has no effect on a mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
need VBA to Transpose the Data from excel to word based on given criteria(status) Excel VBA Macro - Deleting Specific Data based on criteria MD011 Excel Programming 3 12-10-2014 02:15 AM
transpose values based on mulitple criteria mlttkw Excel 1 12-06-2013 02:00 AM
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 AM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM
need VBA to Transpose the Data from excel to word based on given criteria(status) Checking ref # status based on sheet2 ref #. aligahk06 Excel 1 04-26-2010 11:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 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