View Single Post
  #1   Report Post  
tame06 tame06 is offline
Junior Member
 
Posts: 5
Default Trying to do a refresh type function

Hi,

I am trying to sort a timesheet spreadsheet for my work.
What I am after is simple in itself but with the guys I work with I need to make it simpler.
What I want to do is 'cut' the table (weekly timesheet) from sheet 1 and 'paste' it to the top of sheet 2. Meanwhile in sheet 1 the table below the now 'cut' table moves up to the top of the page. While the tables in sheet 2 move down for the new 'pasted' table.
The catch is, I would like there to be a 'refresh' button to do this. That way the boss can click refresh once he has reviewed the tables. So each week, he goes in, ckecks it out, hits refresh and the cut and paste happen. Then repeat the following week.
Is this at all posible?

Thanks in advance for any help given.