J
Jeff
I am creating a spreadsheet for an expenses form. I have created a drop down
list that the user can select payment type eg visa, amex, cash etc. What I
want to do is when the payment type is selected then all the data from that
line is then copied into a separate table itemising those payment types only.
The problem I am having is to ascertain a command that would enable the data
to be copied to the next available line in range of values. The auto copy is
being done with an "If" query, however I do not know how to ensure that the
target of this "if" command is the next available line in a range.
Many thanks
list that the user can select payment type eg visa, amex, cash etc. What I
want to do is when the payment type is selected then all the data from that
line is then copied into a separate table itemising those payment types only.
The problem I am having is to ascertain a command that would enable the data
to be copied to the next available line in range of values. The auto copy is
being done with an "If" query, however I do not know how to ensure that the
target of this "if" command is the next available line in a range.
Many thanks