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!!!
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!!!