Working with Data Transfers

[Michele]

Hello and Thanx for any Help,

I have several drop-down boxes on a spreadsheet and I would like info chosen from each of these cells transfered to another page in my workbook called "DATA"

You could just give me an example for cell A,1

Just to make it clear, I would like to move the contents of cell A,1 to another page in the workbook called "DATA".

I know this sounds simple for most of you all but I am GREEN....

Thanx in advance

 

[Michele]

Part 2

In addition....I would like to create a macro that will send the data of said cells to a page named like 1 of my many choices in a certain drop-down.....clear ?

Lets say I choose ANNE from Cell B,2's drop-down box.....I want the rest of my data to go to a sheet in the workbook named "ANNE" and so on....


I want all the data in certain cells to go to that persons page as I select it from the drop-downs...one more example

If ANNE is chosen from cell B,2
and cell C,3 has her info then I would like for that info to go to a specific cell on a page named "ANNE"....

Thanx again WIZ KIDS !!!!!

 

[Andrew Poulsom]

Assuming your drop-down is from Data Validation applied to cell B2:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> "$B$2" Then Exit Sub
    Worksheets(Target.Value).Range("A1").Value = Target.Parent.Range("C3").Value
End Sub

 

[Michele]

Hey...Great Job....

Thanx sooooo much....works perfectly

I love this site and you all

My favorite part of this code is that if I forget to choose a new name from my drop down box , it will not change the data for someone else's name....

Thanx again