I have a workbook with several sheets. My first sheet has over 1000 products that is updated from a suppliers excel file. On the second sheet I reference each cell and apply a formula to create a csv file for uploading to our software. Sometimes the supplier may remove or add products. When the workbook is refreshed and the supplier sheet is imported the cell references on the second sheet sometimes come up as #REF so I have to copy the formula from the first line and paste it down. How can I automatically do this?
Bookmarks