+ Reply to Thread
Results 1 to 1 of 1

How to make Macros cause content to copy/paste to a single location in Excel or Word?

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Florida
    MS-Off Ver
    2011 (Mac)
    Posts
    3

    Talking How to make Macros cause content to copy/paste to a single location in Excel or Word?

    Hello,

    I'm creating a spreadsheet where I use Macro buttons to guide the user through specific questions or conditions. Basically, I want the end result to be a rough draft of a body of text representing the conditions that were previously clicked. I'll be creating the rough drafts piece by piece and want each section to be added to the draft as they are clicked. Ideally, this would go from Excel straight to a Word Doc, but I can't seem to figure out how that syncs.

    Can anyone provide me with the best way to accomplish this? Could this be accomplished through using filters for each condition? I do not know Excel coding but can record Macro's and assign them one at a time. Am I in over my head? Thanks in advance for your help.

    Below is a link to the sample sheet if that helps. (You'll have to download the file to see the Macro Buttons)

    https://drive.google.com/file/d/0BxI...ew?usp=sharing

    Thanks,

    JT
    Last edited by energyhill; 11-18-2014 at 01:12 PM. Reason: Corrected Link.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Make a copy of a word document and paste it in a different folder with a name 'Test'
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2013, 01:09 PM
  2. Seach, Copy, select paste location, paste using macros
    By helpdave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2010, 11:36 PM
  3. Macros to Copy Paste Special from Excel to Word
    By Aproveche in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2010, 09:21 AM
  4. Replies: 4
    Last Post: 12-17-2007, 08:11 AM
  5. [SOLVED] Copy Excel data content listed in 3 columns into a single column
    By mooorrona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2005, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1