+ Reply to Thread
Results 1 to 6 of 6

Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name

  1. 02-10-2016, 03:56 PM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name

    Dear expert

    I have rawdata with range of A:N which need to spllit rows values in D:D and move to corresponding sheet name which equal to row names
    becoz sheet names already existed so once run code it move to save into tab which name is equal to values in D:D column

    e.g if texas is value 12 rows move to texas tab

    find the attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-10-2016, 04:08 PM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 02-10-2016, 04:16 PM #3
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name

    Hi breadwinner

    I assume the Sheets already exist because of the other Code in your Workbook. Should those Sheets be cleared of Data before populating them with the new Code?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  4. 02-10-2016, 04:23 PM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name

    @ breadwinner - Sheets Michigan and Massachusetts do not exist so the code will Error Out.
    Reply With QuoteRegister To Reply
  5. 02-10-2016, 05:06 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name

    Hi breadwinner

    It appears your existing Code does just as you describe. I changed the Worksheet title for two reasons:
    1. Political appropriateness
    2. I like the way the Code creates and Filters on the Array...I've saved and I'll probably use it if you don't mind.

    The only two things I see missing are:
    1. The code does not Clear the State Worksheet before populating it.
    2. The Code is not assigned to the "Split Data..." Button.

    You'll note where I've added/modified two Lines of Code to accommodate that.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-11-2016, 01:18 AM #6
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need vba code to move unique rows of D:D to corresponding sheet depends upon sht name

    Dear experts

    i keep the all sheet ready once run code i want move data copy to correspond sheet apart from MIssipp & L&T becoz no source data in data sheet!!

    i want code to copy data and paste into sheet not create a sheet and paste
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] need vba to split data move to particular file sheet depends upon sheetname
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-06-2016, 03:05 AM
  2. [SOLVED] Need vba code to make sum and average of row depends upon unique names in col A
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2015, 02:54 AM
  3. [SOLVED] need vba code to condition dropdown list and move data depends upon week or month in comb
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-01-2014, 03:28 AM
  4. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  5. [SOLVED] Macro code to count number of unique rows in a sheet.
    By jsrakesh4u in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-02-2013, 06:44 AM
  6. [SOLVED] Copy all the rows from one sheet to another which depends on one parameter
    By S1n1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-25-2013, 03:05 PM
  7. VBA CODE to move rows from one sheet(1) to another sheet(2) based on data in cell
    By fozzieulo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 02:43 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1