J
jive
I work for a small distribution company and I need help in addin
formulas to a worksheet that I use as a template to create Bills o
Lading. For those that do not know what a bill of lading is it is
shipping document that usually consists of four identical pages excep
that each page is numbered 1, 2, 3, or 4. It contains shippin
information such as the Ship To address, material description, freigh
billing info, purchase order numbers, and contract info between th
freight carrier and the shipper. For the past several years a hav
been using Excel worksheets as templates to create the b.o.l.s I
works great because I can save them individually by customer and th
next time I have a shipment for that customer I simply open the correc
worksheet and make the desired changes such as P.O. number and date.
The worksheet is set up to print as four pages. I have entere
formulas on pages 2, 3, and 4 so that when I make changes on page 1 th
changes automatically take effect throughout the rest of the document.
Keep in mind that all of this so far is done on one worksheet. Here i
my problem. I have a large job coming up that will require me to shi
material to 1600 different addresses. All of the order details such a
addresses, store numbers, and material descriptions have been importe
to an Excel file. I want to copy and paste all that info to
worksheet and on another worksheet within the same workbook have m
bill of lading template. All the info for one shipment is located o
one row. I would like to set up my bill of lading template to pull th
required info from the worksheet that contains the orders. In othe
words I want to kind of automate the process of entering th
information for the bill of ladings. I thought if I made a formul
such as =sheet1!A1 I would get the desired result and I did but I als
thought that if when the first bill of lading was printed I could jus
go back to the sheet containing the order info and delete the first ro
and the info on row 2 would move up and take its place then the secon
bill of lading would be made for me. But of course I was dead wrong.
When i deleted the row 1 on the order sheet I got ref. errors on th
bill of lading sheet. I really want to be able to make this work. An
and all help would greatly be appreciated. If you would like to se
the workbook its self I can email it to you. My email address i
(e-mail address removed)
formulas to a worksheet that I use as a template to create Bills o
Lading. For those that do not know what a bill of lading is it is
shipping document that usually consists of four identical pages excep
that each page is numbered 1, 2, 3, or 4. It contains shippin
information such as the Ship To address, material description, freigh
billing info, purchase order numbers, and contract info between th
freight carrier and the shipper. For the past several years a hav
been using Excel worksheets as templates to create the b.o.l.s I
works great because I can save them individually by customer and th
next time I have a shipment for that customer I simply open the correc
worksheet and make the desired changes such as P.O. number and date.
The worksheet is set up to print as four pages. I have entere
formulas on pages 2, 3, and 4 so that when I make changes on page 1 th
changes automatically take effect throughout the rest of the document.
Keep in mind that all of this so far is done on one worksheet. Here i
my problem. I have a large job coming up that will require me to shi
material to 1600 different addresses. All of the order details such a
addresses, store numbers, and material descriptions have been importe
to an Excel file. I want to copy and paste all that info to
worksheet and on another worksheet within the same workbook have m
bill of lading template. All the info for one shipment is located o
one row. I would like to set up my bill of lading template to pull th
required info from the worksheet that contains the orders. In othe
words I want to kind of automate the process of entering th
information for the bill of ladings. I thought if I made a formul
such as =sheet1!A1 I would get the desired result and I did but I als
thought that if when the first bill of lading was printed I could jus
go back to the sheet containing the order info and delete the first ro
and the info on row 2 would move up and take its place then the secon
bill of lading would be made for me. But of course I was dead wrong.
When i deleted the row 1 on the order sheet I got ref. errors on th
bill of lading sheet. I really want to be able to make this work. An
and all help would greatly be appreciated. If you would like to se
the workbook its self I can email it to you. My email address i
(e-mail address removed)