link filters to auto fill in row in calc?

asked 2018-11-16 00:40:40 +0200

clos911 gravatar image

updated 2018-11-16 00:41:11 +0200

Hello friends, in my spreadsheet I have column "A" as the product name, column "B" as weight, "C" as location "D" as description and so on.. a product name may be in the spreadsheet multiple times but will always have the same weight and description, but the location will vary. When I use auto filter on a specific product's name all fields are identical with the exception of location.

In a new row I use Alt+Down when inserting a product's name in column "A" all the time, it's easy for me.. is it possible to have just the weight and description fields auto filled with that particular product's data once i select the product's name?

thank you!

edit retag flag offensive close merge delete