A
`AMD tower
Thanks to a suggestion here, I was able to graph out the spaces on
the invoices properly, but I ran into another snag, here's the situation:
I am tryinhg to figure out a way to print invoices from an excell
spreadsheet.
The invoices are pre-formated with fields and logos and are on continuous
paper
that is fed into a dot matrix impact printer. It's NCR paper, an original
and
two copies.
The rows of the spread sheet contain the data that needs to be in the
invoice.
Each row has customer information, ie, name, address, item bought, price
per unit, number of units, sales tax, and total due.
The spreadsheet contains about a thousand customers.
On any given day, up to 40 or so, are invoiced.
I made a "print" spreadsheet in the same workbook
and linked the cells to the "data" worksheet. I made
a place in the "data" worksheet to put the data I want
to print..
The "print data" area on the data worksheet is just a
row into which I put the data for the first invoice to
print. On the linked worksheet that data then
appears in the linked cells and the first invoice prints.
This is what I did: in the print from sheet, in the space where the
customer name
goes, i used the equel sign, and then went into the data
sheet, and clicked on the cell with the cumstomer name on
it, and then that customer name appears in the print sheet, but, and here's
the problem,
When i go to do the second one, and copy the data into
the "print area" on the data sheet, on the print sheet
I get an ref error. If I enter the data in manually
i don't get the error.
What I want to do is copy the data from the rows in the data
worksheet into the "print area" in that worksheet, and
then print from the linked worksheet. This way, all I would
have to do is copy each row I need an invoice for, into
the "print row", go to the print sheet and print it, etc.
Is there a way to reference a cell in a second
worksheet, in the same workbook, into which you
can copy data without getting the ref error in the
first sheet?
Sorry this is so long!
any ideas much appreciated.
Mike.
the invoices properly, but I ran into another snag, here's the situation:
I am tryinhg to figure out a way to print invoices from an excell
spreadsheet.
The invoices are pre-formated with fields and logos and are on continuous
paper
that is fed into a dot matrix impact printer. It's NCR paper, an original
and
two copies.
The rows of the spread sheet contain the data that needs to be in the
invoice.
Each row has customer information, ie, name, address, item bought, price
per unit, number of units, sales tax, and total due.
The spreadsheet contains about a thousand customers.
On any given day, up to 40 or so, are invoiced.
I made a "print" spreadsheet in the same workbook
and linked the cells to the "data" worksheet. I made
a place in the "data" worksheet to put the data I want
to print..
The "print data" area on the data worksheet is just a
row into which I put the data for the first invoice to
print. On the linked worksheet that data then
appears in the linked cells and the first invoice prints.
This is what I did: in the print from sheet, in the space where the
customer name
goes, i used the equel sign, and then went into the data
sheet, and clicked on the cell with the cumstomer name on
it, and then that customer name appears in the print sheet, but, and here's
the problem,
When i go to do the second one, and copy the data into
the "print area" on the data sheet, on the print sheet
I get an ref error. If I enter the data in manually
i don't get the error.
What I want to do is copy the data from the rows in the data
worksheet into the "print area" in that worksheet, and
then print from the linked worksheet. This way, all I would
have to do is copy each row I need an invoice for, into
the "print row", go to the print sheet and print it, etc.
Is there a way to reference a cell in a second
worksheet, in the same workbook, into which you
can copy data without getting the ref error in the
first sheet?
Sorry this is so long!
any ideas much appreciated.
Mike.