Does anyone know how I can use a master order sheet to create individual location order sheets? I've created a rough example without any code. In the example, the user would put X's in master tab columns j, k and l to indicate which locations carry certain items. I'd like the program to use the master information to create individual tabs by location, adding the location name to the tab name and order sheet if possible. Any ideas or suggestions would be greatly appreciated. I've needed som3ething like this for some time, have never made the effort to learn how. I can create simple macro's and copy others code, mMy thanks for any and all help.
Bookmarks