Hi i have a spreadsheet for booking in trailers for tipping


I have a screen which displays the details of what is left to tip and what door it is on

I have managed to get a macro the filter copy and paste the detail on to the sheet that is displayed on the screen
but once i shared the workbook ( as other away from the screen want to see what is waiting to be tipped) the marco fails

If anyone could help me i am after a marco that will copy the fillter data and column heading from a sheet called Schedule to a sheet call Display screen all within the as Shared work book


i can attach the workbook if needed

Thanks for your help in Adavance

Mike