Excel Form Deleting Entries
 

I have an Excel form where data is listed for each individual client
horizontally.... Date Name Phone ect... I have the form all formatted
with borders, bold text in certain cells, etc. Adding entries is no problem,
but once the client has been contacted and their needs taken care of I want
to be able to delete them and have everyone else move up to fill in the
gap(s). That way if I need to print the sheet off, it doesn't have gaps in
it. I will only keep 25 entries on the sheet at a time. I can highlight and
delete an entire row, but then I don't have the cell borders and formatting
for the cells below to keep 25 formatted slots on the page. Is there a way
to set up this electronic sheet so the sheet format stays intact but you can
delete an entry and everyone else schooches up to fill in the blank row and
leave the empty formatted form rows below the filled in data rows?

Thanks for your help!

Kass

Excel Form Deleting Entries
 

Here are a couple of 'thoughts':

Set this up as a database and retrieve the records into a 'formatted space'
Use the data form to make the entries and deletions

Or,

Use a mail-merge in MS-Word (with your formatted appearance)

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"Kass" wrote:

I have an Excel form where data is listed for each individual client
horizontally.... Date Name Phone ect... I have the form all formatted
with borders, bold text in certain cells, etc. Adding entries is no problem,
but once the client has been contacted and their needs taken care of I want
to be able to delete them and have everyone else move up to fill in the
gap(s). That way if I need to print the sheet off, it doesn't have gaps in
it. I will only keep 25 entries on the sheet at a time. I can highlight and
delete an entire row, but then I don't have the cell borders and formatting
for the cells below to keep 25 formatted slots on the page. Is there a way
to set up this electronic sheet so the sheet format stays intact but you can
delete an entry and everyone else schooches up to fill in the blank row and
leave the empty formatted form rows below the filled in data rows?

Thanks for your help!

Kass