Apr 30 2020 02:19 PM
Hi! I want to link data (not cells) that I have in a table to another worksheet. Making a reference to a cell in the source table does not work because if I manipulate the table by using filters the destination worksheet keeps pointing to the same original cell that is displaying a different value now.
I have a table with oil output values from different fields and for different years. I need to work with a particular oil field in a worksheet using output values of that particular field. So, I want to link my worksheet to the database table rather than duplicate the data by copying and pasting from the table to the worksheet.
Apr 30 2020 03:38 PM
Apr 30 2020 04:09 PM