This one is simple, just need help with it.
I have 2 worksheets created in the same file. One labeled Work Order and one labeled Invoice.
They are exactly alike accept for the headings on each worksheet and a few slight differences.
I simply want whats typed on the some of the fields on the work order to be copied to the invoice to avoid typing the info twice.
Yes, I did go to the invoice field and type = then to the work order same field and press enter, that works fine, however on the invoice it leaves a 0 until something is entered on the work order.
The problem with that is some of the fields may not need info typed in on the work order thus leaving all of these 0's on the invoice.
I need the formula without it showing the 0's.
Please help.
I have 2 worksheets created in the same file. One labeled Work Order and one labeled Invoice.
They are exactly alike accept for the headings on each worksheet and a few slight differences.
I simply want whats typed on the some of the fields on the work order to be copied to the invoice to avoid typing the info twice.
Yes, I did go to the invoice field and type = then to the work order same field and press enter, that works fine, however on the invoice it leaves a 0 until something is entered on the work order.
The problem with that is some of the fields may not need info typed in on the work order thus leaving all of these 0's on the invoice.
I need the formula without it showing the 0's.
Please help.