Results 1 to 5 of 5

Transpose to the next available line

Threaded View

gherzberg Transpose to the next... 08-23-2012, 12:13 PM
MarvinP Re: Transpose to the next... 08-23-2012, 12:21 PM
gherzberg Re: Transpose to the next... 08-23-2012, 01:15 PM
MarvinP Re: Transpose to the next... 08-23-2012, 03:04 PM
Cutter Re: Transpose to the next... 08-23-2012, 02:43 PM
  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Utah
    MS-Off Ver
    Excel 2007
    Posts
    74

    Transpose to the next available line

    I have to create an automatic push from one workbook as a column to another workbook as a row. The second book is our overall blotter so the data needs to go to the bottom of the sheet. I have tried several different methods to get it to paste to the next available row, but always come up with errors. anyone have any ideas.


    Sub Push()
        Sheets("DaY").Range("B1:M38").Copy
        Workbooks("BLOTTER.xlsm").Sheets("Blotter").Range("A2").PasteSpecial Transpose:=True
         
    End Sub
    Last edited by Cutter; 08-23-2012 at 02:41 PM. Reason: Added code tags

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