1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

macro for selecting and pasting

Discussion in 'Business Applications' started by JeffSchwartz, Feb 18, 2013.

Thread Status:
Not open for further replies.
  1. JeffSchwartz

    JeffSchwartz Thread Starter

    Joined:
    Jan 31, 2013
    Messages:
    56
    I am trying to record/write a macro that will capture the 258 rows of data in column B of a worksheet and paste it transposed into a row of another worksheet. Any ideas of how I should go about doing this.
     
  2. JeffSchwartz

    JeffSchwartz Thread Starter

    Joined:
    Jan 31, 2013
    Messages:
    56
    The first worksheet would be the active worksheet/document. The second worksheet would be 'SALES' in the workbook named MASTER REPORT DATA. It is primarily the selecting and copying of column B that I'm confused about.
     
  3. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    You can just copy and do a pastespecial > transpose
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1090105

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice