same script different years

[Anonymous]

Hi!

I have a script based on a lot of excel fiels due to goals a company has set.

They have goals for 2 years (different files but similar data) and in the script they've duplicated the script to another sheet. Hence, one sheet for one year.

I'm thinking there must be an easier way to do this but i can't figure it out. Any suggestions?

//A.

[kaushiknsolanki]

Hi,

   Can you please explain, why do you require the different files when the data is same.

   Its not recommended to have two scipts for same data with different table names.

   The reason is it will overload the application.

    If you can explain in more detail, that will help us to figure out the problem and find the solution.

Regards,

Kaushik Solanki