Results 1 to 6 of 6

Button click copy data to new sheet

Threaded View

MasterENT Button click copy data to new... 02-18-2009, 08:12 PM
mewingkitty Re: Button click copy data to... 02-18-2009, 08:19 PM
MasterENT Re: Button click copy data to... 02-19-2009, 09:29 AM
royUK Re: Button click copy data to... 02-19-2009, 09:34 AM
MasterENT Re: Button click copy data to... 02-19-2009, 07:09 PM
royUK Re: Button click copy data to... 02-20-2009, 03:35 AM
  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Button click copy data to new sheet

    I currently have a situation where information is entered on sheet1 on several rows. Example:
    A       B
    Name    x
    Date    y
    email   z
    I want to copy the information in column B to sheet2 and have the information transposed to a single row with multiple columns. Example:
    A          B           C
    Name     Date        Email
    x          y           z
    I know this can be done with the transpose function but I want to do it with a button click.

    Thanks in advance!
    Last edited by Leith Ross; 02-18-2009 at 08:56 PM. Reason: Added Code Tags for better formatting

Thread Information

Users Browsing this Thread

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

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