+ Reply to Thread
Results 1 to 7 of 7

Moving raw data to a new sheet

  1. #1
    Registered User
    Join Date
    07-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    51

    Moving raw data to a new sheet

    I have a workbook that is fed its information from a database regarding customer information. I would like to marco that sperates the raw data onto different sheets by name.

    So Sheet 1 Column A is a customers name "J.Smith"
    Sheet 2 is named "J.Smith."

    I want all of J.Smith's data on the sheet with his name.

    How can i acomplish this?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Moving raw data to a new sheet

    1) It seems you got trouble to replying to forummembers who gave you an solution.

    For some of those topics see the links below.

    http://www.excelforum.com/excel-form...54#post3326254
    http://www.excelforum.com/excel-prog...19#post3326919
    http://www.excelforum.com/excel-form...41#post3321641
    http://www.excelforum.com/excel-char...10#post3321610

    2) you been asked several times, to add an excel file to your threat, still I don't see one by this threat
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    07-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Moving raw data to a new sheet

    First off let me start by saying that some on the questions that I have askedare for developmental projects that I am working on. That being the case I am not always able to test the responses given as I return to my development projects when time allows.

    Secondly, ALL and I mean ALL of the data that I work with is considered very sensitive data. The information is automatically pulled out of a database. Becuase of that I can not post my data sets. The question on this thread (compared to some of the other questions I have asked) is relatively strait forward. If Coulmn A = J.smith move all of the data to the sheet called J. Smith. If you need a sample sheet to asnewr that simple of a question perhaps I am on the wrong forum. Yes I have tried searching for the information on my own, but as I am rather new to Excel not knowing the proper terminaolgy for what I am trying to makes searches rather difficult. I also refuse to take the time to create a "Sample" sheet for a question as simple and strait forward as that.

    While I am appreciative of all of the help I have received on this forum this is not the correct one for me.

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Moving raw data to a new sheet

    Hi, Bremen22,

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Moving raw data to a new sheet

    Please Login or Register  to view this content.
    I can only speak for myself (so I will do that), but that's a wrong attitude.

    You don't feel the need to make an example for us, who are willing to help you.

    You think it's normal we will make this example for you, since you are to lazy for that.

    You are the one who needs help, so I think the best you can do is try to make it easier for the one's who are willing to help.

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Moving raw data to a new sheet

    Hi, oeldere,

    I strongly disagree - anybody has the choice to pass any thread if that person doesn´t feel able to help on what is asked or offered. Maybe just take that road?

    Ciao,
    Holger

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Moving raw data to a new sheet

    @HaHoBe,

    I know Bremen is in Germany, so that's why you think this way (joke).

    But once someones steps in, it's nice to know if the solution is working for the OP.

    Not replying on a answer is not a proper way of behaving (but as already said, that's my opinion).

+ 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: 2
    Last Post: 10-09-2012, 08:40 PM
  2. Replies: 1
    Last Post: 06-07-2012, 05:20 AM
  3. Moving data from one sheet to a new sheet based on value
    By learning_vba in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-27-2011, 02:27 PM
  4. Replies: 2
    Last Post: 03-23-2009, 10:17 AM
  5. formula for automatic moving of data from sheet to sheet
    By kdalton1964 in forum Excel General
    Replies: 0
    Last Post: 02-27-2005, 02:23 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