Copy cell values (range) from a table in worksheetB to cells in worksheetA
I have a flow that creates an excel file, from a template, on creation of an item in a Sharepoint list. The items from the list are then inserted to a table in a (hidden) worksheet - worksheetB, Once the item values are added to the worksheet table, I want them to be copied to another worksheet - worksheetA.
The direct lookup (=worksheetB!I4) pre-inserted in worksheetA does not seem to return any values as creating the table range seems to change the cell in the lookup in worksheetA. So, rather thank looking in "worksheetB!I4" it changes the lookup to "worksheetB!I6" and thus returning 0 values.
Any ideas how I can get round this, to pull the values direct from the table range? Is this even possible?
Any help would be great appreciated as I've tearing my hair out with this.