column's and rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2877377%22%20slang%3D%22en-US%22%3Ecolumn's%20and%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2877377%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20i%20automatically%20change%20the%20data%20of%20a%20Column%20to%20data%20based%20on%20a%20row%20in%20an%20other%20sheet%20bye%20only%20changing%20one%20cell%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20how%20do%20i%20put%20that%20in%20a%20formula%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2877377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2877401%22%20slang%3D%22en-US%22%3ERe%3A%20column's%20and%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2877401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1194018%22%20target%3D%22_blank%22%3E%40Kuje1971%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ftranspose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETRANSPOSE%20function%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Can i automatically change the data of a Column to data based on a row in an other sheet bye only changing one cell   

and how do i put that in a formula

3 Replies
Thx bye changing the direction of the tablet in a copy i was able to use the =if(column ($A1),"") function and use the pull down option
Let me explain the goal more detailed: on the job we taken on weakly basis the water and energy meters one weak is in one row and van be viewed bye multipal people.that means i can't change the order of that sheet.every time we fill in a weak, we need to make a printable backup.up till now we put in those numbers two times.there for i want to automise the backup bye automaticly filling in the backup,when you enter a number in the original sheet