+ Reply to Thread
Results 1 to 5 of 5

Reversing an Add Data Macro

  1. #1
    Registered User
    Join Date
    09-02-2019
    Location
    Paris
    MS-Off Ver
    Mac Excel version 16.25
    Posts
    5

    Reversing an Add Data Macro

    Hi Everyone,

    Sorry, I'd need help again.

    So I have this code, which allows me to put data from several vertical cells into one single cell, while keeping the "vertical" aspect of the data, so that in the single cell, it looks exactly like when in several cells.... (I do hope that I am clear enough here)

    Dim v As Long, LastRoww As Long, str As String
    str = ""
    LastRoww = Sheets("Saisie").Range("B37").End(xlUp).Row

    For v = 6 To LastRoww
    str = str + Sheets("Saisie").Cells(v, 2).Value & vbCrLf
    Next v


    So my question is, is it possible to create a module to reverse this procedure? Transforming data in several lines but in a single cell, to data in several cells?

    Thank you so much in advance for your assistance.

    All the best

  2. #2
    Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    132

    Re: Reversing an Add Data Macro

    Hi
    May be
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    132

    Re: Reversing an Add Data Macro

    Put data from several vertical cells into one single cell
    How about
    Please Login or Register  to view this content.
    Just an idea

  4. #4
    Registered User
    Join Date
    09-02-2019
    Location
    Paris
    MS-Off Ver
    Mac Excel version 16.25
    Posts
    5

    Re: Reversing an Add Data Macro

    It works perfectly! Genius! Thank you so much!!!

  5. #5
    Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    132

    Re: Reversing an Add Data Macro

    You are well come
    Thank you for the feedback
    Be happy

+ 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