Forum Discussion

Copper Contributor

Jun 11, 2021

Duplicated lines are being removed when I insert a new Row in Excel

Hi All, new to community so go easy on me. I have a spreadsheet which has a 1st sheet that is referenced from several other sheets within the doc (Column A of the receiving sheets references a un...

Bronze Contributor

Jun 13, 2021

Hi Nick174

It sounds like the sheet you are referencing was generated using power query, do you have a screenshot of the main sheet?

cheers

Nick174

Copper Contributor

Jun 13, 2021

Hi Yea_So

Thanks for the reply, I'm afraid I can't show the info on the sheet, but I think it may be because I have used Fill down rather than Autofill when I insert the lines. I will have a play with this tomorrow and will let you know if this fixes.

Many thanks

Nick