Forum Discussion
Worksheet data import
I have developed a worksheet for creating a spread of banking activity using many formulas. I would like to reuse the sheet by clearing data only, and importing data from a new downloaded sheet by us...
=IFERROR(IF(INDEX(Tabelle1!$A$2:$H$19,ROW($I1),MATCH(Tabelle2!A$1,Tabelle1!$A$1:$H$1,0))="","",INDEX(Tabelle1!$A$2:$H$19,ROW($I1),MATCH(Tabelle2!A$1,Tabelle1!$A$1:$H$1,0))),"")You can try this formula. The headers are arranged in a different order in the original sheet and in the result sheet with the formula.
Thank you for the response!
I have used excel for many years, but I am not an expert.
I am not sure how you would use your formula for my purpose. Would you copy that formula into each cell that you want to copy over?
My assumption is that the new downloaded data is in sheet1 where the headers are sorted in ascending order header1, header2, header3 and so on. In sheet2 the formula is entered in cell A2 and filled across range A2:H19 with the fill handle. The formula can be filled down and across larger ranges as required. In other words i would copy that formula into each cell that i want to copy over by using the fill handle and not by selecting each cell and copying the formula into each cell separately.
