Inserting the Worksheet to Another File

Question

Hi,

I have multiple excel files and I wanted to insert the sheets into one excel file. The sheets varies since some are templated. Below sample file, can I ask your help on how I can insert the sheets coming from Control.xlsx to Financial sample.xlsx. The output (Financial sample) should now be consisting for 3 worksheets namely, Finance, Employee and Controller SbL.

Looking forward for your ideas on this.

Kamen

Control.xlsx

Financial Sample.xlsx

KamenRider · Answer

Hi @binu_acs  @nagakavyasri

Is it possible vice versa? Instead of Financial sample is the input file, let it be the Control file? I have multiple worksheets where some of it are formatted in table form. I noticed that the formatted style disappear aside from I have to select each sheets to combine by tabs to form into one file.

Please advise and let me know if you have any questions.

Kamen

binu_acs · Answer

@KamenRider you can add the Financial sample file and select the employee tab, which is similar to the workflow I provided, you can put all in one workflow

nagakavyasri · Answer

@KamenRider  if you have few sheets to be moved, you can repeat the above process for Employee sheet as well.

Since the Control file has formatted data we are following this approach, else we would copy the Control file to Financial Sample by taking Control file as input & Financial Sample as output.

Control.yxzp