LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Can you move the row information by just using one numbered cell?

What I was wondering is if it was possible to tranfer all the row data on to
a printable sheet with boxes using just the I.D. number from the orignal
database. ie. taking the information from the database below and by typing
"213" (the ID number) into a new printable sheet (basic example below) it
will take all the row information with it, so that i can take any shipment
number type it in and print off a delivery note, but only have one
interchangable printable sheet?

DATABASE

A B C D
E
1 213 23 24.02.05 DAVE 13.50
2 214 15 16.04.07 BILL
12.99

PRINTABLE SHEET

Shipment No. 213
Number of boxes 23
Date of order 24.02.05
Customer DAVE
Price 13.50


Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Move exact information in a row as you sort a column Michaela Excel Worksheet Functions 2 November 20th 06 07:09 AM
create numbered sortable numbered list in excel coloradio Excel Discussion (Misc queries) 2 November 15th 06 06:50 PM
Have VBA delete a group of cells, move information over, then add Tina Bradshaw Excel Discussion (Misc queries) 0 February 22nd 06 04:07 PM
How do I move information between worksheets? Nocomputergeek Excel Worksheet Functions 2 October 10th 05 03:02 PM
I want to move my excel information from vertical to horizonta hagen Excel Discussion (Misc queries) 0 April 7th 05 06:39 AM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"