+ Reply to Thread
Results 1 to 3 of 3

Multi functional macro- insert rows, copy data- but never sure how many rows it will

  1. #1
    Registered User
    Join Date
    04-21-2011
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Multi functional macro- insert rows, copy data- but never sure how many rows it will

    Okay this may sound a bit out there, but I really think its doable in a loop type macro... i just can't get it to work. I've put together what I have working, but is has row references and I can't have that.

    What I am trying to do.
    I have an extract file that can have 3 rows of data or 50 rows or who knows... it is based on an extract from a new plant sales.
    I need to populate a new worksheet which now copies the first row off extracted data to as many rows as we currently have plants. (in my example I am attaching I believe I used 17 plants, but we are actually up to 48)- so each row would be copied to 47 addtional rows (at this time- basedon number of plants).
    Then once the rows have been inserted and copied down I need to copy in the same purchasing org in column c <A300> and the list of plants (to column d) from a separate tab, to each row/part.

    I am attaching what I pulled together, but as I said the macro has row references and I can't have that as I don't know if it will have 3 rows one day, 50, 75 or ???

    Anybody want to take a look at it?

    My macro should show you what I've done to provide an example on small scale of what I need done.

    Thanks!
    Kjp2u
    Attached Files Attached Files

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Multi functional macro- insert rows, copy data- but never sure how many rows it w

    kjp2u,

    The following macro should accomplish what you're looking for:
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar

  3. #3
    Registered User
    Join Date
    04-21-2011
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Multi functional macro- insert rows, copy data- but never sure how many rows it w

    Thanks tigeravatar! Looks like this will work like a charm! I will test it out next week!
    Thanks for taking a look and helping out!
    Regards,
    kjp2u

+ Reply to Thread

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