I have never used macros before and I'm not sure if they can accomplish what I would like them too. I have a very large spreadsheet that I am trying to get information out of. Right now I custom filter a column to narrow down the data to a specific range and then collect data from multiple cells that have formula that I have set up. I then further sort the data by other columns and collect data from the same cells again. Is there a way to set up a macro that would complete this as I have a spreadsheet in the same workbook to populate that has 24 rows and this process would be iterated 16 times per row. In the future I would like to be able to use this in the future on a new spreadsheet of data as it comes in. Is this even possible? If so how hard is it to set up?
