Input and copy macro code

jackliew · #1 (**permalink**) 02-25-04, 21:55

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

Smitty · #2 (**permalink**) 02-26-04, 00:16

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

Internet Services

Web Development

Digital Marketing

Consumer Tech