B”H
In Excel 2000 I use many sheets in the same file.
I need to insert many data (name, address, postal code, etc) that are on a (B) sheet in another (A) sheet.
To obtain this, when I am in the (A) sheet I put a ” = ” in the cell (1) and after I click on a cell(2) in sheet (B) that contains the name. So I get inserted the content of the cell (2) of the (B) sheet in the (A) sheet.
Question: since the data (name, address, postal code, etc) in the (B)sheet are all on the same row and I have to insert all of them in the (A) sheet in different cells, can I build a relation so to get all the data inserted with 1 or 2 clicks?
I hope the question is enough clear,
thank for the attention,
best regards,
Moise Levy, Milano, Italy