Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding Columns with additional information (2003)

    Hi all. I have a problem that I hope can be easily solved.
    I have a workbook that contains two worksheets. The worksheets are called Master and RadioReplacement. There is common specific information in each workbook which is vehicle registration numbers, besides blank cells, each Rego No is individual. The columns with common information in each workbook are both called Reg No.
    What I am trying to do is to get excel to do is where there is a common registration number between the two workbooks, I am trying to get excel to copy and paste the data from the RadioReplacement spreadsheet along with the currently existing data in the Master workbook.
    Hope I explained that OK.
    Any advice appreciated.

    Bill

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Columns with additional information (2003)

    I suggest you to have a look at the VLOOKUP worksheet function.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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