• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying Cells from one sheet to a new sheet automatically

N

NimP

New Member
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 what is selceted from the dropdown list on master sheet to the respective sheets.


Master sheet will act as the register which will be used to update information etc?


Thanks in advance for your help and support
 
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, NimP!

I see that columns D:H have data validation lists for Target Group 1 to 5 but I don't understand which are the criteria to copy rows of data depending as there's no data available and where it should be copied to. Please elaborate.

Regards!
 
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 enters Lone Parent in cell D2, this row of data will automatically copy across to sheet 'Lone Parent'.


Thanks for taking the time to have alook for me, much appreciated
 
Sorry,


Have updated the file and its sharing permissions.


Thanks again to everyone for their help
 
Hi, Nimp!


Got the file and I see that you have created all the related worksheets. Just check with me these points:

a) Input data is yet done at worksheet MASTER, or user can add, modify or delete cells there? Specifically those of columns D:H (target groups).

b) Information in child worksheets is cleared each time a user selects an option in columns D:H or selected rows should be added to the end of existent data?

c) You have placed data validation against lists for columns D:H, but if worksheet MASTER is just for selecting data shouldn't you have used filters at row 1 instead of data validation lists?

d) And if the input occurs in worksheet MASTER, when, at what moment it should be copied (either replaced or added) to child worksheets?

Regards!

c) What happens if a user selects alternatively in the
 
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 is required (columns K, N, Q).


I would prefer to not include filters as not all users will be Excel smart. The Tabs for each 'client group will be protected an only act as references so users can easily see the number of each client group they have and what requires updating.


I would like the child worksheets to be upddated as and when the mastersheet is updated and also act as a running list of similar to the amster sheet where further data is saved/updated but not deleted.


I hoep this clears up any confusion
 
Hi, NimP!


Let me go thru my check list:

a) User adds rows, delete rows and change cell existing cell values.

b) Information in child worksheets is updated as changes in master worksheet happen, if add in master add in childs, if delete in master delete in childs, if change in master change in childs.

c) Corresponds data validations as there'll be input and no filters'll be used.

d) Included in b).


Is that right? If not, please clarify.


Regards!
 
Hi, Nimp!


Everything posted upwards is achievable a priori but depending on the usage and the input procedures there might be different approaches. If things are like as I described in my last post the last question maybe who, when and how is going to use the child worksheets and what will be done with the information there? Just to decide the better way and opportunity to fill them up.


Regards!
 
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 time goes on, eventually leading to a master sheet with 500+ entries, and the additional sheets will contain the master sheet data but only for the relevant users who have been assigned the specific target group from the master sheet.
 
@confusedcelt

Hi!

I checked it and it's available. If couldn't yet try this:

https://dl.dropboxusercontent.com/u/60558749/OUTCOMES%20FRAMEWORK%20V4%2097%2003.xlsx

Regards!

PS: BTW, nice nick :)
 
You must log in or register to reply here.
Back
Top