+ Reply to Thread
Results 1 to 9 of 9

need vba to split data move to particular file sheet depends upon sheetname

  1. 02-08-2016, 03:47 PM #1
    julielara
    julielara is offline
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    need vba to split data move to particular file sheet depends upon sheetname

    Dear experts

    I have master_file saved in local folder and splited club sheet file in another location


    i have more than 100 sheets in Club_sheets file with multiple of Co_Code where it meets in column H in Master_File copy to particular sheet.

    e.g 010F,0009,004T,010U,010B,010T,006B,005F name of sheet existed in Club_sheets file i want rows of data move to correspondence sheet where tab name is meet similar through H:H at end 010V rows should not copy to sheet because sheet name not exit in club file

    C:\Users\Admin\Desktop\Oracle

    find the attachment
    Attached Files Attached Files
    Last edited by julielara; 02-09-2016 at 01:21 AM. Reason: reason
    Reply With QuoteRegister To Reply
  2. 02-09-2016, 01:21 AM #2
    julielara
    julielara is offline
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    Re: need vba to split data move to particular file sheet depends upon sheetname

    experts Need help?
    Reply With QuoteRegister To Reply
  3. 02-13-2016, 10:22 AM #3
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: need vba to split data move to particular file sheet depends upon sheetname

    This should do it. Change the path to the club sheets workbook

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  4. 02-15-2016, 04:52 AM #4
    julielara
    julielara is offline
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    Re: need vba to split data move to particular file sheet depends upon sheetname

    Wow works really amazing i dont have words to thank you
    Reply With QuoteRegister To Reply
  5. 02-17-2016, 10:00 AM #5
    julielara
    julielara is offline
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    Re: need vba to split data move to particular file sheet depends upon sheetname

    Dear sir

    I have two question on code?

    how to extent the column now its till13 i want add more column till 18.
    and how to change column Co_code 8 to 2 column. and run code if i keep in 2 column its not run
    Reply With QuoteRegister To Reply
  6. 02-27-2016, 08:49 AM #6
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: need vba to split data move to particular file sheet depends upon sheetname

    Try this

    Just add the column header names in the order you want the output file results to look like.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-05-2016, 10:41 AM #7
    julielara
    julielara is offline
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    Re: need vba to split data move to particular file sheet depends upon sheetname

    Dear sir

    I added the column names like as how code treat the header values from sSQL= "col 1,2,3,....17] and run but i am getting error like "Run-time error '-2147217904(80040e10)': No value given for one or more required parameter.

    find the attachment with new column header result as it is.

    thanks sir
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 03-05-2016, 07:39 PM #8
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: need vba to split data move to particular file sheet depends upon sheetname

    You didn't have the SQL with correct header/field names. Give this a try.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 03-06-2016, 03:05 AM #9
    julielara
    julielara is offline
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    Re: need vba to split data move to particular file sheet depends upon sheetname

    Ya sir its working amazing!! thanks sir keep helping me
    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 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
  2. Move data depends upon selection of yr & wk or month from textbox userform vba
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2014, 02:26 PM
  3. Vba macro to split the data to three sheets depends upon single & repeats
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2013, 10:54 AM
  4. Data Move to Master from sheet1,sheet2 vba depends upon column heading value
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2013, 03:21 AM
  5. [SOLVED] VBA Split Data and Move to targeted named file from master file
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2013, 01:06 PM
  6. Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 04:21 AM
  7. How to move the chartsheet(leaving the raw data sheet in the orig file) to a new file
    By cloud9 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2012, 06:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1