LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Daniel Weston
 
Posts: n/a
Default How Can I Do This

At work I had a spreadhseet which was basically a list of reconciliations
from cash machines.

The layout consisted of a code followed by some amounts e.g

CH455454 10/5/05£1342 £1000 £2342

I get reports in everyday and used to add them to the spreadhseet one after
the other with gaps in between each code

eg CH12345 10/05/01 £1000 £1234 £2234
CH12345 17/05/01 £1000 £1234 £2234

CH98765 10/05/01 £2000 £2000 £4000


When a new report comes in I now copy and paste the new insformation at the
bottom of the spreadhsheet and use date sort to put the entry in the correct
place.

When doing this manually it was easy to insert a blank line after the entry,
but how would do I add a blank line automatically after the last entry, just
to divide up the list of very similar looking figures,

Any help appreciated,

Daniel


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"