I have a worksheet in excel which would have different number of rows on almost every update. How can I paste it in Powerpoint so the powerpoint would reduce and increase the number of rows until the end of the worksheet please ?
I have googled and some are recommending to use Dynamic Named Ranges called 'Actions' which I have created as " =OFFSET('Action Tracker'!$A$2, 0, 0, COUNTA('Action Tracker'!$A:$A,1))"
The number of columns in my worksheet dont change.
I then select the sheet - Ctrl A, ctrl C and Paste special - Paste link the worksheet but it doesnt copy the named range
I am sure I am doing soemthing wrong in copy and pasting but unsure what ?