I have data in one worksheet (payroll) and I want to transfer data to another worksheet to create a receipt. I had used formulas to do this but since the data in the first worksheet is filtered, the cells change when the filter changes. How can I keep the same reference after filtering the data?
Thanks
Solved by F. S. in 11 mins