Lookup Field

L

Legacy 436357

Guest
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
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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.
 
L

Legacy 436357

Guest
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.
 
Last edited by a moderator:

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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 ?
 
L

Legacy 436357

Guest

ADVERTISEMENT

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?
 
L

Legacy 436357

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

Legacy 436357

Guest

ADVERTISEMENT

Maybe like this?

Excel Workbook
ABCDEFGHI
1Closed
2
3AFR NumberSales OrderReceived Date
4
5Entered By
6
7Customer
8
9Description
10
11Part NumberOld Part Number
12
13Serial NumberOld Serial Number
14
15Customer ComplaintTest Equipment
16
17(TEL Number)
18
19
20
21Preliminary InspectionRepair Manual
22
2312A Spec
24
2591A Spec
26
27Progressive Inspection93A Spec
28
29Temperature?
30
31Humidity% RH
32
33PressureHg
34
35Repair DetailTechnician
36
37Repairman
38
39Disposition
40
41Finished Date
42
43Labor Hours
AFR Form
 
L

Legacy 436357

Guest
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,360
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top