I am a newbie in excel and would like some help to automatically share the data (in cells A1:A100 - Z1:Z100) entered/saved in the main file to populate multiple files such as File1, File2, etc. The data in columns A and Y of the main file need to be "joined" to form the required data in column K in File4.
I know most people are looking for the reverse where they want to consolidate data from multiple files into one big file, but I need the opposite.
Thanks for your help.
Bookmarks