Hello all,
In a previous thread (http://www.excelforum.com/excel-form...ml#post3645634) I needed the data I put in one sheet to be distributed in the rest of the (similar) sheets based on the name in column A (the name in column A is the name of the destination sheet) and an expert here solved it with macro code (see the attached xlsm).
Now I need the other way around. Agents will put the data in the sheets (in the attached workbook: agent1, agent2 etc) and their input to be summarized in master file sheet. In the attached file the macro code works for columns A-K. In the new one I need the range to be A-W. I tried to replace the K with W in the code but it didn t work...
Can anyone tranform the code in the file so as to work as I explained above?
If you need more clarifications please tell me.
Any help will be highly appreciated!
Bookmarks