how do I merge two worksheets and save as individually

G

Gabe

I know this is easy for someone that knows excel and macros. It is about
merging information from one worksheet to another.

I have two worksheets where one has a form like information and the other
contains the data. I need to insert three data fields into the form, “save
as†the form (active worksheet) to the hard disk with the unique name from
the identifier, and repeat until end of data.

Form name is TRIO VEHICLE WORKSHEET and has the following structure with
cells C1, C7 and H7 to be filled with info from data sheet (row 2 first row
with info)
where C1 = &A2&, C7 = &N2& and H7 = &P2&

| A | B | C | D | E | F | G | H |
1 Vehicle# &A2& Requirement (current/new):
2
3 AL:
4 Actual/expected annual mileage:
5
6 Worksheet completed by: Date: 12/24/2006
7 Contact number: &N2& e-mail: &P2&
8

Data sheet is named VehiclesID and has the following structure

| A | N | O | P
|
VEHICLE_Id PHONE RATE USERID
10-14972 5533193 (e-mail address removed)
10-4183A 5533030 260.8 (e-mail address removed)
10-4243A 5533000 260.8 (e-mail address removed)
10-4260A 5533842 260.8 (e-mail address removed)
12-20376 5242481 230.4 (e-mail address removed)
41-47534 5539013 (e-mail address removed)

Please help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top