I'd like to build two macros that are slightly different but are both along
the same lines.. The first one will take only certain columns of information
from the "Master" sheet and dump them into the "Public" sheet. (I want only
certain information to be seen by others). I.E. say I only want columns A, H,
K, L from the master sheet to go in A, B, C, D in the Public sheet. I hope
thats enough detail... The other macro I want to build will take the A, B, C,
D information from the Public worksheet and dump it all into another workbook
called "Client Lists". The link to these two documents would be over a
network so there shouldn't be any issue there... This way, all the people I
work with can have this document and have up-to-date information on clients
etc... Thanks for reading this far, any help is appretiated!