kkmak13
January 27, 2022, 1:15am
#1
Hello all,
I was able to successfully combine my excel sheets from a folder into one workbook using this solution shared by @andrejz in this post Combine excel files into single workbook in sheets
From my understanding, columns read by Excel are usually in string/int format? Is it possible for me to combine these files into a workbook but retain the original formula.
Many thanks for your help!
Kenyx
January 27, 2022, 3:15am
#2
Hi @kkmak13
I have multiple Excel Workbooks (File 1, File 2,…), each of which has 2 common sheets - Sheet1 and Sheet2.
I want to merge Sheet1 from all Workbooks into a single Sheet1 (new Workbook)
(1) The column headers and sequence of all Shee1 are exactly the same.
(2) I only want to copy selected columns from all Sheet1 i.e. A, D, G, H, I,… into corresponding A D G H I… columns of combined Sheet1.
(3) I want to start from exactly the 7th row of each Sheet1 and then end with the row that has some data…
system
April 27, 2022, 3:16am
#3
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
