Search results

Hi, The Master sheet will be the only sheet used for inputting. I would like the additional sheets to act as a 'Log Only' so managers can eaisly identify the users within a particular group, eg. Lone Parents. Master sheet will only have rows added and should never have any rows deleted as...

Hi SirJB7, thats spot on, is it achievable in your opinion?? Thanks for your help with this

Hi SirJB7, The master sheet will be used as a log for Users where they can keep a record of all service users. Users will enter data everytime a new service user registers and this will act as master register. I have set the validations on the master sheet so they are reminded when a update...

Sorry, Have updated the file and its sharing permissions. Thanks again to everyone for their help

Hi SirJB7, I have ammended the spreadsheet agin and hope it is clearer now. https://docs.google.com/file/d/0B4AdUEYBpN4dSm5TLVY0NWtmXzA/edit?usp=sharing Once an option has been selcted in cell D2, i would like the row of data to be copied in to she relevent sheet. For example if a user...

https://docs.google.com/file/d/0B4AdUEYBpN4da1p0RUZRekF5TjA/edit?usp=sharing Hi above is the link so you an view the workbook if needed to help with this. Thanks

Hi, I have created a sheet named master sheet where users can select options from a dropdown list such as Lone Parents or Disabled. I have created new sheets named after the selctions form the dropdown list on the master sheet. Is it possible to automatically copy rows of data depending on...

Hi All, Than you for your posts, I have managed to get it working now & am stuck on the last part. Below is an example of the 3 months data; User enters Date in C2, this automatically updates Cells I2 (3 months) Cell J2 shows if cell I2 is overdue by displaying "UPDATE" Cell K2 requires...

Hi, I am attempting to create a spreadsheet which allow susers to input a registration data and this will automatically update a 3 month, 6 month and 12 month date where users know they should update the clients records. Once a 3 Month, 6 month, and 12 month date is due the cell will...