-
Merge few files with few sheets to one sheet
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules