+ Reply to Thread
Results 1 to 7 of 7

Plot Data from 1 sheet to another

  1. #1
    Registered User
    Join Date
    07-24-2017
    Location
    xxxx
    MS-Off Ver
    2007
    Posts
    13

    Plot Data from 1 sheet to another

    Hello guys need your assistance badly on this on how i can auto plot the data from one sheet to another
    I have a VBA code on the module portion of the VBA but it seems that it is not working. See below VBA.

    Please Login or Register  to view this content.
    Last edited by jeanemik; 12-13-2017 at 04:17 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: Plot Data from 1 sheet to another

    deleted .....code tagged
    Last edited by protonLeah; 12-13-2017 at 11:53 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-24-2017
    Location
    xxxx
    MS-Off Ver
    2007
    Posts
    13

    Re: Plot Data from 1 sheet to another

    My apologies for not following the forum rules already edited my first post.
    Last edited by jeanemik; 12-13-2017 at 04:18 PM.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: Plot Data from 1 sheet to another

    Column C names on Cycle_x sheets will never match column A names in Leave sheet.
    The line: If mWs.Cells(rowctr2, 1).Value = Sheets("Leave_Raw").Cells(rowctr, 3).Value Then..., will always return FALSE.

    WARNING: you seem to have posted actual names and e-mails in the wb, which is not allowed.

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: Plot Data from 1 sheet to another

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    07-24-2017
    Location
    xxxx
    MS-Off Ver
    2007
    Posts
    13

    Re: Plot Data from 1 sheet to another

    thanks ProtonLeah will have this code checked!

  7. #7
    Registered User
    Join Date
    07-24-2017
    Location
    xxxx
    MS-Off Ver
    2007
    Posts
    13

    Re: Plot Data from 1 sheet to another

    Thanks for the help Leah is there anyway that this post can be deleted.

+ 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: 03-10-2016, 06:41 AM
  2. [SOLVED] How to plot data in one sheet into another sheet
    By Conair1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-04-2013, 02:22 PM
  3. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  4. How can I plot multiple data set on a single contour plot
    By hafziebone in forum Excel General
    Replies: 0
    Last Post: 02-11-2012, 02:02 PM
  5. How can I plot multiple data set on a single contour plot
    By hafziebone in forum Excel General
    Replies: 0
    Last Post: 02-10-2012, 11:27 PM
  6. how do i plot data consisting of 1000 lines in excel sheet
    By novice in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-29-2005, 09:55 AM
  7. Can I copy x-y scatter plot data direct from one plot to another?
    By Chris in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-03-2005, 09:05 AM

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