[URGENT] Split Excel sheets into different workbook without changing format in each Sheet

Question

Hi All,

I want split Excel sheets in a single workbook in Excel Format into Different Excel sheets with changing the format in the Main Workbook, but Formula will go off(i.e. save as values) in this case. Please see the example input files and output files i want to understand the problem statement.

Please Give me Any suggestion. Any suggestion will  be appreciable.

Thank you Everyone

Input_Example.xlsx

Output_Sheet1.xlsx

Output_Sheet2.xlsx

Output_Sheet3.xlsx

binu_acs · Answer

@Eswaran Since the data get overwritten in all sheets the formatting part will get ignored even though the preserve format is checked in the output tool. One option write your output with a specific range, in that case, the data overwrites only that range in that way you can preserve the formatting which is not part of the range. For example, suppose your header records are formatted in that case write your output in the range where the header is excluded.

Also, take a look at the below blog

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

Eswaran · Answer

@binu_acs Thanks for your solution. I am getting what i am expecting in terms of values. But I could not able to get coloring format. See in the image, In input file Coloring format(Like Yellow color, Green color in the cell) was there, But in the output file there is no coloring format. Thing is we need to maintain the same format too. Another one thing is Each Sheet having different color format randomly. Please let me know if there is any possibilities

Input.PNG

Output.PNG

binu_acs · Answer

@Eswaran One way of doing this with the batch macro

Excel_Sheets_280323.yxzp