I had posted this question in the General Excel Help forum but did not quite get the answer I was looking for, so hoping to get some help here....Thanks in advance!
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