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

chili

chili

chili

Associate
Joined
19 Mar 2011
Posts
822
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
 
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
 
Is 701 a person, a work day, a date?

If I understand you correctly:

You'd be better off having 5 columns on sheet 1:

Rota Number || Sign On || Sign Off || Meal Break || Paid Time

Then just add a filter to the sheet and you can simply select the rota number/s required and it'll only display that/those

If that's not what you want I'd look a letting us know what the point of the second sheet is? Such as, is it used to track just your rota or a team? What are you wanting to use it for? are you wanting it for reports? Does it hold just a single week or all weeks?
You can also share the spreadsheet with us via Dropbox/Google sheets and it'll help us understand it all, just make sure there's not personal data on it.
 
You must log in or register to reply here.
Back
Top Bottom