Forum Discussion
AutoPopulation of fomulas by column help
Hi, I have 2 sheets in a workbook. I would like to pull data from sheet 2 into sheet 1. rather than manually referencing the cells I want, I would like to be able to pull down my reference formula, w...
Could you explain what each part of that formula does? I am trying to make it work with my actual spreadsheet (which is a little more complicated than the test file i attached screen shots of)
Here's a snip of my notes I added to the workbook. I've also attached the workbook.