skamatiCopper ContributorNov 01, 2024Quick question How can I lock data to copy from same row but different columns?
wumoladIron ContributorNov 01, 2024Hi skamatiYou can use this A$1. Here the assumption is that you are referencing cell A1, when you copy the formula to column B, anywhere in the row, it changes to B$1 i.e. the row does not change.
