I can't attach a file in this forum so I'm gonna have to try to explain my database setup for you. The first 15 rows has my company's information along with customer information (Basically my ship ticket heading). Then on row 16 I have the row headings for the material being shipped (A-order Number, B-date, C-Qty, D-item, E-asset #, F-description, G-cost each, H-cost total, I-customer name, J-customer street, K-customer city, L-customer state). Below this, I have my database for shipped items. Then at the bottom of my database I have a small footer. I have a filter for the database range and I select the order number in the filter to show the items that are leaving for that specific order. I have my print range to only show columns c through h (Qty, item, asset #, description, cost each, cost total). I need something in my header section to reference a changing row specific column. I was thinking of using A15 (not in database and not in print field) to type in the specific row information I want. Then in the header section I tried typing in cell D2 "=I(a15)" for customer name. D3 "=J(a15)" for customer street. This way I would only have to change the row number in cell a15 to the row information I wanted. I hope I didn't confuse you too much.
