I have a very basic issue in excel and I can't for the life of me find the
solution. I have a dense worksheet of data and I want to distill some of the
information into a much shorter list. The data is ordered and the
information I want to pull out from the big sheet and put in the little sheet
occurs in the same column in every 30th cell. In my new sheet, I want my
column of information to refer to every 30th cell. In other words, I want
h28, h58, h88, h118, etc. Unfortunately, I don't know how to make excel
automate this process (there's too much info for me to do it by hand). Does
anyone know how to do this? Thanks.