Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2010
    Location
    Brisbane
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Row from Worksheet A = Row from Worksheet B

    Looking for advice on how to set formula so that

    WorkBook B Worksheet B Row 1 = WorkBook A Worksheet A Row 1
    WorkBook B Worksheet B Row 2 = WorkBook A Worksheet A Row 2
    WorkBook B Worksheet B Row 3 = WorkBook A Worksheet A Row 3
    WorkBook B Worksheet B Row 4 = WorkBook A Worksheet A Row 4

    and so on....

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In WorkBook B Worksheet B Cell A1 enter the formula
    ='[Workbook A.xls]Worksheet A'!A1

    Copy this to as many cells as desired in the rows and columns

    Steve

Posting Permissions

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