• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Loop through files _ Rename and Update the data from Master Data

uday

Member
Hi all,

Happy new year!!!!!

I have a master data file where data is changing under three categories for every financial period. Now, for each category, I have separate files (Apple, Mango, Lichi) to update them for the current period. As of now, data is updated till period 11, however, I have the latest data for period 12. I want the category table should be updated as per the data mentioned in the Master data file. Like if the Master data file has 5 rows for the Apple category the data should go to the Apple file by inserting 5 rows in the table ( TABLE format should be unchanged) and also file should be renamed as per year and period like mentioned naming convention. Like, for period 11 it is mentioned as Apple_202011 and for 12 it will be Apple_202012.

Files are attached for your ready reference.

Regards,
Uday
 

Attachments

  • Apple_202011.xlsx
    8.6 KB · Views: 8
  • Lichi_202011.xlsx
    8.6 KB · Views: 3
  • Mango_202011.xlsx
    9.2 KB · Views: 3
  • Master Data.xlsx
    9.5 KB · Views: 7
Back
Top