Jun 11 2021 06:28 AM
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 unique code from the 1st sheet and these run in sequence in the follow on sheets).
Some of the follow on sheets need to duplicate a row from the 1st sheet and I can run some vba to do this no problem.
If I want to Insert a new line on Sheet 1, I run some vba to insert the same line in the follow on sheets. However what seems to be happening is that if the line I am inserting is above the lines in the follow on sheets (i.e a lower Row number) then the subsequent duplicates that I have created in the follow on sheets are deleted and I don't want this to happen. It seems as though there is a refresh rolling down the sheet from the point of insertion to the bottom of the data and this is removing the duplicates.
Any one know how I can stop this happening?
Many thanks in advance
Nick
Jun 13 2021 12:36 AM
Jun 13 2021 05:26 AM
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