S
SACWB
We have a tracking spreadsheet that we use to manage
architectural process of producting blueprints for our
customer. There are three rows for each
site.
Sometimes we need to rearrange the sites by site
numbers or site name or some other function like
filter so we can see how many and which sites are
needing something.
OF course as we try to manipulate the sites we loose
the formatting for each site through a sort or filter
command.
I am seeking a method or command to lock those three
rows for each site together so we do not loose the
formatting for each site.
Any help with this is greatly appreciated. I am sure
that someone in the past has encountered this issue
before. But is appears to be a guarded secrete or it
just cannot be done. If it cannot be accomplished we
will have to reformat the entire spread sheet. So, in
the interest of time, I am trying to see if there is a
command or add-in that will work.
Thank you very much for your time and
interest in this.
Warren Bloss
KDC Architects
architectural process of producting blueprints for our
customer. There are three rows for each
site.
Sometimes we need to rearrange the sites by site
numbers or site name or some other function like
filter so we can see how many and which sites are
needing something.
OF course as we try to manipulate the sites we loose
the formatting for each site through a sort or filter
command.
I am seeking a method or command to lock those three
rows for each site together so we do not loose the
formatting for each site.
Any help with this is greatly appreciated. I am sure
that someone in the past has encountered this issue
before. But is appears to be a guarded secrete or it
just cannot be done. If it cannot be accomplished we
will have to reformat the entire spread sheet. So, in
the interest of time, I am trying to see if there is a
command or add-in that will work.
Thank you very much for your time and
interest in this.
Warren Bloss
KDC Architects