PDA

View Full Version : [SLEEPER:] Merge few files with few sheets to one sheet



Growlithe
12-20-2018, 08:28 AM
I have this formula for combining many files from Excel (many files and 2-3 sheets):
https://pastebin.com/aZipQSNY

I already have the fact that it detects the same sheets and connects them but does not do it right, i.e. the data is mixed up as in 1 file in A1 the cell is empty and in A2 it overwrites the information from A1 to A2.
And I want it to look like this:

For example:

File 1
A1 = empty value
A2 = sun
A3 = empty value

File 2
A1 = 2
A2 = empty value
A3 = empty value

File 3
A1 = 2
A2 = empty value
A3 = excel

File 4 connected sheets
A1 = 2
A2 = sun
A3 = excel