Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Input and copy macro code

    I am using Microsoft Excel XP

    Program purpose: Enter a text input such as SPEC100E in main worksheet, the macro in excel will grab and read this SPEC100E worksheet in the workbook and copies data here to the main worsheet. I have about 45 different spec worksheets. ie why I would like to just type the spec sheet no in main sheet and then data will appear right here in main sheet.

    Can you help me out, thanks!

    Jack

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Welcome to the Board!

    VLOOKUP immediately comes to mind, but with 45 different sheets you'll likely need a VBA approach. (Unless you have a summary sheet, which would greatly simplify things, but without seeing what you're working with...)

    Care to post you workbook, so we can take a look?

    Smitty

Posting Permissions

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