+ Reply to Thread
Results 1 to 4 of 4

Macro Text To Row

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro Text To Row

    Hello everyone! I have looked at some of the posts in the forum and have been trying to get this all figured out but as I am a total macro newb I am at a loss I am exporting product files out of my website and attempting to import them into another. In order to do this I have to take the SKU ID that is in one column and row to stay in the same column but to expand rows down while not deleting the other values that are already there.

    Attachment: The main tab is an example of what I am able to export out of my system and the output is what I need it to look like when all is said and done.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Macro Text To Row

    Here try this
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor gsnidow's Avatar
    Join Date
    07-22-2010
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    150

    Re: Macro Text To Row

    mccoyver, here is another solution. I did not check JieJenns post, as I'm sure it is a good working solution. I would not normally post a different solution to a problem someone else had already addressed, but since you said you are a macro newbie, I thought I would take this opportunity to show you there are many ways to solve a problem with VBA. You will have to decide, through testing, which works best for you. I'm a brute force kind of guy, in that my tendancy is to load everything into an array, then I can make it do what ever I want. This is not always the most efficient approach, but it works for *me*. Anyhow, this should work for you, and it assumes the existence of your two sheets.

    Greg

    Please Login or Register  to view this content.
    Just a guy trying to make work stuff easier.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro Text To Row

    Yet another one!
    Attached Files Attached Files

+ 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. Replies: 0
    Last Post: 04-22-2013, 12:13 PM
  2. [SOLVED] macro assistance to automate text entry in selected row if another range has text
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-12-2013, 01:01 PM
  3. Replies: 13
    Last Post: 11-29-2012, 08:25 PM
  4. [SOLVED] "Run-time error '13': type mismatch when running macro to add text to end of text
    By nrjordan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2012, 10:34 PM
  5. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM

Tags for this Thread

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