PDA

View Full Version : 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