excel automation to copy and paste values within a column where the first row equals a data value specified on a different worksheet
Is there a way to get an automate scrip to read a value in a given cell on one worksheet, and then find that value in row 1 of a second worksheet and then copy & paste values for all cells in that column?