Hello everyone!
This forum is great and I used it several times already! I hope you guys can help me with my problem. I will try and describe it as clearly as I can and what I need to achieve:
I have ONE excel file (lets call it MAIN.XLS). I use this excel file to create and list products for an ecommerce website. It’s a very simple sheet with some vlookup function. Nothing special really. You can consider it as a template of some sort.
Now, we have 2,000 different folders and inside each folder we have one .CSV file. Inside each .CSV file we have 6 cells with some numbers/data (different data for each file). The filename of the .CSV is the same on all folders (Data.csv) and the layout is also the same on all all files.
Before I will continue, its important to mention that I will copy the main template file (MAIN.XLS) to each for the folders in order for what I will write below will work.
Ok, now what I wanted to achieve was something simple, or so I thought – take the main file MAIN.XLS and on cell A7, I wanted to take data from cell A2 from the .CSV file (=[Data.csv]Data!$A$2). The problem its not working on other folders. My guess was because the link is broken due to location of file.
I have searched around and found that there is a formula for a file location - =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1) – so if I insert this formula it should give me the same folder as the .csv file (since I put both files on same folder). However it did not worked.
My English is not very good so I hope I explained it fine. If not clear please tell me and I will do my best to try and explain it again.
Thanks again for all the help!
Mod Edit: OP has redefined the issue with a new attachment in post #25.
Bookmarks