Secon sheet has a list.
Please, add a formula to sum up or cout values.
Click the button
References do expand. The file name in first column is just a give-away
And what does that mean for the specific question here, which was “I need the data to be IMPORTED (not opened in a new instance) into the current TAB in the existing spreadsheet for use”? As I said, you decided to focus on some specific thing that one approach does differently than another, and which wasn’t the topic from start.
Well, the OP never answered. I guess, he’s back to XL. In the past 23 years, I noticed that there is a need to insert new csv data into existing lists (I think this is what XL “tables” are about) without adjusting each and every reference to that list. It’s not my business anymore, because I found my way to use databases with LibreOffice.
1 Like