Can I use a .bat file to copy the columns from an existing excel sheet into another? I’ve tried but the rows and columns become jumbled. I just want to copy data automatically in the existing template.
Copy data from one sheet to another using VBA
Copying and pasting a worksheet to a different excel workbook
Merge all CSV or TXT files in a folder in one worksheet
Hello, probably if you convert your excel sheet or column to CSV, XML or text(tab delimited) you could add that file to your batch file. Make sure to make a copy of your file. Work on the copy...not the main file.
-- open excel
-- open the excel sheet
-- once open click on save as
-- choose other format like any of the following:
XML Data (.xml)
CSV (comma delimited) (.csv)
Text (tab delimited) (.txt
-- add new file name to batch file
-- run it.