I need help with excel............

[chili]

Hi, i am not new to excel can get by with very basic stuff but i am now trying to do something which is way out of knowledge of excel.

i have 2 sheets, sheet 1 consist's of work rota and paid time it is made up of 4 column's and looks like this below column1 is 701 col2 is sign on plus time col3 is sign off plus time col4 is paid time

701 Sign On : 0350 Sign Off : 1110 Meal Break : 0714 - 0810 Paid Time : 06.24

sheet 2 is where i want to track my week i would like to just input in column 1 the duty number ie 701 and when this is entered for each day of the week the relevant info is dragged from sheet into sheet 2 where a few basic calculations are done that adds the paid time for the week.
my week consists of 7 days monday to sunday

hope this makes sense and someone can assist me

thanks

 

[chili]

Hi and thanks for the reply, it was difficult to put into words so i understand where your coming from.

ok on sheet 1 i have 16 rows and 4 columns of work data/rota's and paid hours etc. now on sheet 2 i want to input a rota number ie 701 in column lets say A1 and i want all the relevant info pulled from sheet 1 ROW A1 that is input for 701 pulled into sheet2

 

[chili]

all sorted thanks for the replies, vlookup was what i was after