I have a summary sheet that is based on what the user puts in the first column to populate the rest of the columns.
so if user puts in 6, the rest of the columns will be populated by data from another portion of the sheet.
The only way I know how to do this is to put =if(a16=6,$K$2,if(a16=7,$K$3,if(a16=8,$K$4,if(a16=9,$K$5....etc)
I can copy and paste the chunks but then I have to manually change the a16=**,$K$** where ** are the numbers I am manually entering.