I have a question regarding copying contents of cells from different sheets.
for instance I type =sheet1!A3 and I drag to the right to =sheet1!N3. From here I need to copy 2000+ rows and from several sheets.
Is there a quick way I can automatically get the information of the cells that contain text/values? My thought was similar to double clicking on the solid square ont he bottom right corner used for formulas.