Excel data entry form

%3CLINGO-SUB%20id%3D%22lingo-sub-1973319%22%20slang%3D%22en-US%22%3EExcel%20data%20entry%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1973319%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%3A%26nbsp%3B%20Any%20advice%20on%20how%20to%20setup%20an%20excel%20data%20input%20form%20where%20the%20first%209%20fields%20of%20each%20row%20are%20the%20same%20from%20record%20to%20record%20with%20only%20the%2010th%20field%20changing%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1973319%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1974297%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20data%20entry%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1974297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F896608%22%20target%3D%22_blank%22%3E%40gkowalke%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20explain%20a%20little%20bit%20more%20about%20the%20request%20-%20if%20the%20first%20nine%20fields%20for%20all%20rows%20are%20repeating%2C%20then%20why%20include%20them%3F%20Is%20there%20a%20column%2C%20aside%20from%20the%2010th%20field%2C%20that%20will%20set%20each%20row%20apart%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20can%20help%20provide%20a%20better%20solution.%20At%20the%20moment%2C%20the%20solution%20is%20to%20simply%20have%20each%20cell%20having%20a%20simple%20equal%20sign%20to%20the%20cell%20above%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good afternoon:  Any advice on how to setup an excel data input form where the first 9 fields of each row are the same from record to record with only the 10th field changing ?

1 Reply

@gkowalke 

Can you explain a little bit more about the request - if the first nine fields for all rows are repeating, then why include them? Is there a column, aside from the 10th field, that will set each row apart?

 

This can help provide a better solution. At the moment, the solution is to simply have each cell having a simple equal sign to the cell above it