I have a worksheet with 929 rows of 26 columns. Appx 75% of the fields are populated but the other 25% are blank. I need to send this spreadsheet out to other offices to get them to fill in the blanks that they are responsible for. I have created drop down lists for each column that has blanks in it to help them enter their data easier. I want to copy the created drop down list cell and paste it into the blanks for each column. Is there a way to do this without scrolling down through each of the 929 rows and sticky selecting only the blank cells and then pasting? In other words, is there a way to copy and then paste into only the empty cells of a range?
Hook Em
Hook Em