Transferring data upon user input

    I have a workbook which is used company wide. Some worksheets are only created with VBA code when needed and are not permanent workbook sheets. One of these sheets includes user selected items from a list. Those selections are made after the worksheet has been created. At the time the user makes a selection, I need to have that data transferred to another worksheet to be used later in yet another user creaated worksheet. The data will be stored within Excel for later retrieval. How do I activate this behind the scenes? I don't want the user to have to run a macro at this point.


    If this is just as clear as mud, I will be happy to try to illuminate the problem further.


    Thanks for all the help!

    Thanks,


    Blue

    Re: Transferring data upon user input


    Blue,


    You will probably need to use the Workbook event for sheet change or maybe calculate.


    In it you will need to test the name of the target sheet, and if the target sheet matches then have it place that value on the other sheet.


    Or it maybe possible to use formulas if that first value is placed into the same spot on the second sheet. However, you said that sheet is a "on the fly" created sheet as well ( so a macro would be the best )


    A solution really wouldn't be difficult. You just need to specify the following information:


    1. What is the name of the sheet on which the user enters his/her selection.
    2. What cell is the selection entered into.
    2. What is the name of the sheet and cell that the selection needs to be sent to.

    Re: Transferring data upon user input


    Thanks a million for your help, now all i need to figure out is how to activate the macro. Can't do it with a workbook activation because the workbook isn't always there. I want the info immediately transferred upon users input and it is a data validaton field. I'll just keep working at it.

    Thanks,


    Blue

    Re: Transferring data upon user input


    Blue,


    Datavalidation, entered selections, may pose some issues as I don't believe the change event is triggered.


    I know that the calculation event is triggered but it doesn't have a method to say which cell was changed.


    Hmmm? Could be a tricky issue.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login