Transfering data Closed

Question

I have a charts with 2000 lines a colums of first names, a colums of last names, 3 address colums. 

I have a similar chart on a second sheet. Which has more colums on it such as email and telephone. This second list has selected names form the first list and added new ones.

Now I made a mistake and added many birthdates on sheet number one instead if sheet number 2. 

Is there anyway I can transfer birtdates to the right individuals automatically or do I have to find each person and type in his birthdate?

ac3mark · Answer

Ok, what a great question.

What else can we qualify the data with, to make the change?  If the answer is:

If (None) Then answer=Nope();

Let us know how else to qualify the changes, again?

Katzman · Answer

Thanks for that quick reply. However I do not understand how to apply it to my chart. Is there a spercial formula or equation that i have to put into sheet number 2 to retreive the information from sheet 1?

ac3mark · Answer

Yes, Something like :=Sheet2!B2

Should work!

Transfering data

3 responses

Similar discussions

Subscribe To Our Newsletter!