+ Reply to Thread
Results 1 to 3 of 3

Copying and Pasting. My head hurts :(

  1. #1
    Registered User
    Join Date
    08-13-2015
    Location
    Houston, Texas
    MS-Off Ver
    2010
    Posts
    61

    Lightbulb Copying and Pasting. My head hurts :(

    Morning all!

    I am having trouble with some coding, and would love some advice and help.

    In the worksheet I am attaching, what I am trying to do is extract info from cells A:E and transposing them into columns G:J. For the purpose of what I want it to eventually look like, I basically copied and pasted the info in to cells M:P to illustrate.

    This is the code I have come up with so far:

    Please Login or Register  to view this content.
    It gives me the information I need up to row 101, but I need it loop and gather the rest of the data for me. The biggest problem I am having is with rows 105, 125, 145, 165, etc. The purpose of those rows is to tell me the issueage and duration, that's it. How do I create a continuous working loop to have it look like columns M:P?TerminalReserveMacro.xlsm

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,128

    Re: Copying and Pasting. My head hurts :(

    Get the rows from the used cells.

    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Copying and Pasting. My head hurts :(

    Duplicate thread. See http://www.excelforum.com/excel-prog...y-looping.html

+ 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. Intro as head hurts from so much info
    By Noobie2data in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-26-2014, 09:21 PM
  2. Formatting Chart (My Head Hurts)
    By KCKuhns92 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-20-2013, 11:35 AM
  3. [SOLVED] Calculate forecast revenue
    By andyking40 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-30-2013, 03:38 AM
  4. My head hurts
    By bfee317 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2009, 05:21 AM
  5. Head hurts...please help.
    By Lythande in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 08:02 PM
  6. Some Advice Please....My head hurts
    By test1986 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2006, 05:49 PM
  7. Some Advice Please....My head hurts
    By test1986 in forum Excel General
    Replies: 1
    Last Post: 10-24-2006, 09:46 AM
  8. Arrays Take too long. VERY HARD QUESTION. my head hurts : /
    By Peo Sjoblom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM

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