Taking info from 1 spread sheet to another

[redhand]

I have a problem and hope someone on this site will be able to help?

On 1 spread sheet I have a list of Advisors and an errors they have made

Ie

USER Date Reason

RM 04/08/08 not input name
RM 05/08/08 incorrect address
ST 01/08/08 wrong DOB
EL 05/08/08 criminal act
RM 06/08/08 wrong DOB


Is the any formula that I use to look up the user and then copy all of the other info across to a 2nd spreadsheet?

I hope this is clear if not I will try and explain further.

Many thanks in advance

[davesexcel]

Hi,
This can be done with a filter,
Check out this thread
http://www.excelforum.com/showthread.php?t=631657

It has a sample workbook
http://www.excelforum.com/attachment...8&d=1201836478

Maybe check out this example for other ideas
http://www.excelforum.com/attachment...4&d=1202071513

[redhand]

Hi thank you for the reply. I am aware of filters but I would like this do be done automatically and from another workbook not in the same workbook. Something like a lookup but I am totally lost. I will make up a couple of workbooks later to show what I mean.

Sorry if I am not descibing this very well.

[davesexcel]

Hi thank you for the reply. I am aware of filters but I would like this do be done automatically and from another workbook not in the same workbook. Something like a lookup but I am totally lost. I will make up a couple of workbooks later to show what I mean.

Sorry if I am not descibing this very well.

Okay, will wait for them.....

[SnowCom]

What about using chains?

You can tell your document to get the value imported from another location on the computer, and pinpoint exactly what page, row and coloumn you want imported. It works with text too.

[bobhope24]

in terms of linking spreadsheets, you can check this youtube vid out and that will show you how to link more than one spreadsheet and it will auto update and everything.

If you already know the formulas you need simply put them into excel and use the tutorial on youtube to link the info.

youtube tutorial

[redhand]

Ok,

I have attached 2 spreed sheet, Test 1 and test 2

What I am wanting to do is to get the info from test 1 to test 2. As you can see the tabs on Test 2 have the names of the advisors on each tab.

Is there any way to search test 1 and then bring the info over automatically?

[davesexcel]

Try this code

Please Login or Register  to view this content.

Attached is an example of test2, open the attachment and open test1 in test2 cell A2 use the drop down list to select a name, the info should follow once a selection is made.
Enable Macros

[davesexcel]

What about using chains?

You can tell your document to get the value imported from another location on the computer, and pinpoint exactly what page, row and coloumn you want imported. It works with text too.

Hi SnowCom,
Could you provide an example??