Lookup Field

[Legacy 436357]

Hello,

Is it possible to have a field on a worksheet that can serve as a lookup for an ID that I can pull the related data from another sheet? If so can that data be protected when the data is completed like in an invoice situation?

I appreciate any advice or help,
XJ

 

[Gerald Higgins]

Is it possible to have a field on a worksheet that can serve as a lookup for an ID that I can pull the related data from another sheet?

Yes.

If so can that data be protected when the data is completed like in an invoice situation?

That data can be protected.

What do you mean by "...an invoice situation".

It's difficult to provide more specific advice as your request is pretty vague.

 

[Legacy 436357]

Hi,

Thanks for the reply. I want to create an invoice workbook for service. I thought each invoice could have all of the information on a row in a table like Customer Info, parts, labor, etc. and pull that data from the ID or vice versa submit the data to that table on the other sheet.

 

[Gerald Higgins]

I thought each invoice could have all of the information on a row in a table like Customer Info, parts, labor, etc. and pull that data from the ID or vice versa submit the data to that table on the other sheet.

Well, I imagine that probably could be done.

But for me, this is still all far too vague to provide more specific answers.

What exactly do you need help with ?

 

[Legacy 436357]

For the ID I want it to be a lookup but also be able to put new ID. This is where I need the help please. Also to be able to lock that record with perhaps a macro?

 

[Legacy 436357]

I have to leave for a little while now but will return with some more specific information thanks.

 

[Legacy 436357]

Maybe like this?

Excel Workbook
	A	B	C	D	E	F	G	H	I
1		Closed
2
3		AFR Number		Sales Order			Received Date
4
5	Entered By
6
7	Customer
8
9	Description
10
11	Part Number						Old Part Number
12
13	Serial Number						Old Serial Number
14
15	Customer Complaint						Test Equipment
16
17							(TEL Number)
18
19
20
21	Preliminary Inspection						Repair Manual
22
23							12A Spec
24
25							91A Spec
26
27	Progressive Inspection						93A Spec
28
29							Temperature		?
30
31							Humidity		% RH
32
33							Pressure		Hg
34
35	Repair Detail						Technician
36
37							Repairman
38
39							Disposition
40
41							Finished Date
42
43							Labor Hours
AFR Form

 

[Gerald Higgins]

OK so that's your form, what do you want to do with it ?

 

[Legacy 436357]

The AFR number field will be the ID.
1: I want to be able to enter an AFR number and have all the fields filled from the table on the other sheet
2: Create a new AFR and fill in all of the info that gets stored on the table on the other sheet
3: Be able to lock that record and show it in the Closed field.

There will be more to do but these will get me started.

Thank you very much,
XJ

 

[Legacy 436357]

please bump