Auto populate using data from another worksheet

[itsblackseph]

Hi there guys

I'm creating a membership database, and as part of it want to be able to quickly fill out an attendee's list for different events complete with certain sets of information. To do this I have a complete set of member details, with a member number at the start of the row (e.g. A1 = Member number, B1 = Member Name, C1 = member address etc.). I am looking for a way to use the member number to take certain parts of this info and create an attendees sheet without me having to fill out every cell myself (So i put MN001 into A1 and cells B1, C1, D1 and E1 all take preset data from the overall members sheet that link to member MN001)

Is this an IF command or is there another way to do this?

Ta!

[rcm]

This is an example doing what you want...

With this method one has to "code" the attendees..

If I may, what if you type the attendees last name and have the procedure filter all those attendees with similar last names so you can choose from it and automatically fill the info and code.

[FDibbins]

Hi and welcome to the forum

Take a look at using the vlookup() function. Something like....

=vlookup(A2,sheet1!$A%1:$E$500,2,0)
where....
A2 is the member number you enter
sheet1!$A%1:$E$500 is the range of data on sheet1 (adjust as needed)
,2, is the column to return the data from - change this to 3, 4 etc for each succeeding column
,0 is for an exact match

If the headings on each sheet are identical, instead of ,2, you could use this instead...
,match(B$!,sheet1!$A$1:$E$1,1),
so the formula would then be...
=vlookup(A2,sheet1!$A%1:$E$500,match(B$!,sheet1!$A$1:$E$1,1),0)

Yopu can then just copy that across and down with no need to change the column number