none
Import Excel Spreadsheet from one workbook to another workbook RRS feed

  • Question

  • Hello,

    I would like to import from the workbook "Report 04.xlsx" the Worksheet "Audit 12042019" from A2 to Y239

    to the workbook "2019-12-04 Health.xlsx" worksheet "Hardware Inventory" from E5 to AB250

    with a condition of matching on Ax from "Report 04.xlsx"/Worksheet "Audit 12042019" to Dy in "2019-12-04 Health.xlsx"/worksheet "Hardware Inventory".

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    Thursday, December 5, 2019 8:29 PM

All replies

  • Hi,

    I cannot understand what is "Ax" and "Dy".

    Could you explain the meaning of "with a condition of matching on Ax from "Report 04.xlsx"/Worksheet "Audit 12042019" to Dy in "2019-12-04 Health.xlsx"/worksheet "Hardware Inventory"?

    Regards,

    Ashidacchi -- http://hokusosha.com

    Friday, December 6, 2019 1:18 AM
  • Hi,

    Could you provide a sample or please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Friday, December 6, 2019 9:53 AM
    Moderator
  • Hi,

    I cannot understand what is "Ax" and "Dy".

    Could you explain the meaning of "with a condition of matching on Ax from "Report 04.xlsx"/Worksheet "Audit 12042019" to Dy in "2019-12-04 Health.xlsx"/worksheet "Hardware Inventory"?

    Regards,

    Ashidacchi -- http://hokusosha.com

    Hello,

    Ax is the first field selected from the excel source workbook

    e.g.: A2 in this example

    Dy is the first field from the destination excel work book

    e.g.: D5 in this example

    If A2 matches D5 we import in the designation workbook the rest of the field on the same row...

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL


    • Edited by Felyjos Friday, December 6, 2019 2:52 PM
    Friday, December 6, 2019 2:50 PM
  • Hi,

    Could you provide a sample or please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Hello,

    from the source workbook/worksheet

    e.g.:

    Workbook:   IBM 04.xlsx

    Worksheet:  Audit

    Field:          A2

    to the workbook/worksheet destination

    e.g.:

    workbook:  2019-12 Audit.xlsx

    worksheet: Hardware

    field:          D5

    If A2 match D5 then I would like to import the full row

    e.g.: A2 = D5 ==> import/transfer A2:Y2 to D5:AC5

    and then

    A3 = D6 ==> import/transfer A3:Y3 to D6:AC6

    A4 not equal to any D column values so no transfer...

    A5 = D8 ==> import/transfer A5:Y5 to D8:AC8

    A6 = D9 ==> import/transfer A6:Y6 to D9:AC9

    etc...

    Thank you,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    Friday, December 6, 2019 3:03 PM
  • Hi,

    I hope you will share the files via cloud storage such as OneDrive, Dropbox, etc.
    To make a sample macro, it's a time-consuming task for us to input data from screenshots. 

    Regards,

    Ashidacchi -- http://hokusosha.com

    Sunday, December 8, 2019 12:41 AM
  • Hi, 

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to shareexplore and talk to experts about Microsoft Office 2019.

    Monday, December 16, 2019 2:02 AM
    Moderator