+ Reply to Thread
Results 1 to 7 of 7

Trouble getting data to transfer properly

  1. #1
    Registered User
    Join Date
    08-24-2019
    Location
    Tokyo, Japan
    MS-Off Ver
    0365
    Posts
    4

    Trouble getting data to transfer properly

    Hello,
    I am trying to get his code to work properly. Basically I am trying to get columns labeled in blue labeled 'Key' to be split into two and that works, but where the issue comes in is i want the rest of them to just copy to the appropriate column and row. When Data changes in the 'Key' column it messes up and does not copy everything properly. It has to work on thousands of lines so it's not an easy thing to just manually adjust. Please help and let me know if you need any more information.

    I did post to a different forum at first before I found this one, but I really need help asap. I am not allowed to post the link yet.

    Basically to clarify I am trying to get the 'File' Column to put the data in the appropriate corresponding output in the Cvt Sheet ABC data goes under Preservation, Ales data goes under Ales, and Rice data goes under Rice.
    Attached Files Attached Files
    Last edited by ensabahnur; 08-24-2019 at 01:16 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Trouble getting data to transfer properly

    I don't think everything is alright:

    1) See image - row for "Ales" is in row for "Rice"
    2) Why are the first two rows for "Rice" combined into one ? Should it be like that ?
    Attached Images Attached Images

  3. #3
    Registered User
    Join Date
    08-24-2019
    Location
    Tokyo, Japan
    MS-Off Ver
    0365
    Posts
    4

    Re: Trouble getting data to transfer properly

    Quote Originally Posted by porucha vevrku View Post
    I don't think everything is alright:

    1) See image - row for "Ales" is in row for "Rice"
    2) Why are the first two rows for "Rice" combined into one ? Should it be like that ?
    No, that is what I am struggling with. If the value in the 'File' column says 'Ales' then it should copy the data in the same row in the columns after 'File' related to 'Ales' to the 'Ales' section on the Cvt sheet same with 'Rice' to the 'Rice' section and 'ABC' in the 'Preservation' section.
    Last edited by ensabahnur; 08-24-2019 at 07:16 PM.

  4. #4
    Registered User
    Join Date
    08-24-2019
    Location
    Tokyo, Japan
    MS-Off Ver
    0365
    Posts
    4

    Re: Trouble getting data to transfer properly

    Taking the image you put as an example Row 3 & 4 in the top portion should only have the "rice" portion populated with data on the lower part of the image in Row 3 & 4.

    Row 5 should only have the "ales" portion populated
    Row 6 should only have the "preservation" portion populated

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Trouble getting data to transfer properly

    Hello ensabahnur and Welcome to Excel Forum.
    I know that you are looking for a VBA solution, however after four days I thought you might be interested in seeing a formula based alternative.
    1. Columns A:B are populated using: =files!B3
    2. Columns C:J are populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Note cell C1 is changed to read "ABC".
    Conditional formatting is applied to columns C:J to hide zero values.
    For future reference it is more helpful to show us manually produced correct outcomes than formula/code produced incorrect outcomes.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  6. #6
    Registered User
    Join Date
    08-24-2019
    Location
    Tokyo, Japan
    MS-Off Ver
    0365
    Posts
    4
    Quote Originally Posted by JeteMc View Post
    Hello ensabahnur and Welcome to Excel Forum.
    I know that you are looking for a VBA solution, however after four days I thought you might be interested in seeing a formula based alternative.
    1. Columns A:B are populated using: =files!B3
    2. Columns C:J are populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Note cell C1 is changed to read "ABC".
    Conditional formatting is applied to columns C:J to hide zero values.
    For future reference it is more helpful to show us manually produced correct outcomes than formula/code produced incorrect outcomes.
    Let us know if you have any questions.
    Thanks so much for your help and noted! This was great!

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Trouble getting data to transfer properly

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. Trouble with syntax, either with the If/Then funcition or in properly using CVErr
    By FZappa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2019, 03:50 PM
  2. [SOLVED] Trouble making to sources of time compare properly.
    By Jocamo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2015, 06:10 PM
  3. Transfer from WS to WS range not working properly
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2014, 12:39 PM
  4. Replies: 4
    Last Post: 07-11-2011, 02:40 PM
  5. Transfer Market Creation. Trouble with Excel 2003 programming. Help??
    By Chris2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2009, 11:13 AM
  6. Trouble with combining 2 macros to loop properly
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2008, 10:17 AM
  7. [SOLVED] Trouble getting new toolbar buttons to work properly in Excel 2003
    By Dave in Nashville in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2006, 12:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1