Inputting CHQs to spreadsheet

  • Thread starter Thread starter Sketcher
  • Start date Start date
S

Sketcher

I am inputting data into an excel spreadsheet.

It is quite a laborious task - need help with speeding things up.

I am entering cheque details onto worksheet.

Headings used:

Date - chq no. - Details - Total - Relevant sub-heading for total
(electrical, sundries etc.) Invoice Paid (Yes/No)

When entering the total for a chq I wonder could I get that figure to also
be entered under the relevant subheading also without having to enter it
twice. i.e Excel would recognise the relevant cell & enter the info. It
seems to be the slowest part at the moment.

I have done all the usual stuff of autofilling where possible, freeze panes
etc. just this one thing seems to slow the process somewhat.

Also a lot of the chq would be repetitive just the amounts & dates would
vary - any ideas at all greatly appreciated.

Regards & Thanks,

Sketcher.
 
Sketcher,

Do you enter the amount into column Total, then again into one of several
columns, such as electrical? It's better design for most purposes to have
the amount only once, then another column to indicate the type of
transaction for this check (electrical, etc). You could use Data -
Validation in that column to help enter the type values. When (not if) you
want to add a type, you just add to the validation list. If you've set up
validation for a dropdown, ALt-DownArrow opens it. Autocomplete will fill
in repeat values as soon as enough stuff has been typed to narrow it down to
one. Pivot tables, sorting, database functions, subtotals, etc., will allow
all kinds of things with such a table.
 
Back
Top