Hey, I wanted to copy the values of a coloumn. The coloumn has following formula "=INDEX('Planungsakte (2)'!E:E;VERGLEICH(C3;'Planungsakte (2)'!C:C;0))". VERGLEICH is the german term for MATCH. I just wanted to copy the values and paste it somewhere else in excel because i will delete the excel sheet with the relation coloumn for my formula. This will give me an error, so is there a vba code for this problem? Bc my coloumn has over 1000 values. There is an extra condition: A filter will always be on cause in my sheet there are two types of links. one is leadin to folders the other one to elements. And i dont want to see all elements so Folder filter. Side note: The excel spreadsheet is a query linked to Sharepoint.
Thx in advance
Thx in advance
