I need someone to show me how to do certain functions in Google Docs.
I have a spreadsheet which i load to google docs (masterlist). This master lists has 5000 rows. I want to break it up in to 100 row sheets, without having to copy and paste them, I also want my master sheet protected. I want a secondary sheet which gives me all the output of those 50 sheets containing 100 rows on one new sheet/spreadsheet with the 5000 with color coding and notes which our reps make on those individual sheets of 100.
If you know what I am trying to do, please message me.
I want to be taught how to do this. If there is a macro you can make, even better.
ALL TEMPLATE APPLICATIONS/REQUESTS WILL BE IGNORED. If you know what I am trying to do, tell me you do and lets get started.
I Need this ASAP.