Results 1 to 7 of 7

Thread: Excel Data population from one sheet two another

  1. #1

    Excel Data population from one sheet two another



    Register for a FREE account, and/
    or Log in to avoid these ads!

    At the moment i am working two tabs in excels and i have to update of the tab manually.


    I am looking for way a that if work in sheet 1 it updates sheet two automatically but with conditions. The updates should only take place if the D1 cell is marked "X".
    If the D1 cell is marked "X" then in sheet two the A1 cell should be updated with the cell value B1 mentioned in sheet one

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Is it only copying Sheet1!A1 to Sheet2!B1 or is there something else that needs to happen as well? I'm just curious if there is more to this.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Yes there is more to happen i am actually working with X, L and P characters so i just want that sheet 2 should only be updated in case there is and X mark in cell

  4. #4

    Excel Data population from one sheet two another

    At the moment i am working two tabs in excels and i have to update of the tab manually.


    I am looking for way a that if work in sheet 1 it updates sheet two automatically but with conditions. The updates should only take place if the D1 cell is marked "X".
    If the D1 cell is marked "X" then in sheet two the A1 cell should be updated with the cell value B1 mentioned in sheet one

    Futhermore i am actually working with X, L and P characters so i just want that sheet 2 should only be updated in case there is and X mark in cell

  5. #5

    Is there a way in macro or excel formula where in if a certain cell has value, the other cells will be automatically populated?

    I am making an exceptional log for the control that have failed to meet the criteria. The failed controls are mentioned in Testing Sheet. For every pass there is a tick and for every fail there is "cross" against each sample. Now my requirement is that if there a cross against a control for the selected sample then automatically exceptional log is updated with the sample number and the control

    Example:
    Testing Sheet (Format)

    Control Sample 1 Sample 2
    1.1 " X" "X"

    Exceptional Log (Format)

    Sample Control
    1 1.1

    2 1.1


    Please help me out

  6. #6
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi there,

    I've merged these two threads together, as they are the same question.

    You know what would be really helpful here is a sample workbook with about 10 rows of data, and a step by step of what you'd want to see happen when each row/column is checked.

    I'm getting the impression that you have multiple columns that need to be evaluated, as well as multiple "states" (X,L,P)

    A sample would really help clarify things for us. To post one, double click the "Reply to Thread" button and you can upload a workbook there.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  7. #7

    Reply urgnet

    Hi there
    i have uploaded the file now what i exactly want is as follow
    1. the data mentioned in sheet name "Testing Sheet" represent testing
    2. the data mentioned in sheet name "Exceptional Log" represent improvement areas.

    Requirement
    I want the Exceptional log sheet cell c12 to get auto populate with B11 cell in testing sheet furthermore i want Exceptional log a12 to get auto populated in case there is mark X in any sample number in testing sheet.

    In short i want the exceptional log to get auto populated with control id and sample number in case there is mark (X) against any sample. Refer the attachment.





    Quote Originally Posted by Ken Puls View Post
    Hi there,

    I've merged these two threads together, as they are the same question.

    You know what would be really helpful here is a sample workbook with about 10 rows of data, and a step by step of what you'd want to see happen when each row/column is checked.

    I'm getting the impression that you have multiple columns that need to be evaluated, as well as multiple "states" (X,L,P)

    A sample would really help clarify things for us. To post one, double click the "Reply to Thread" button and you can upload a workbook there.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •