Picking up values from other tables

D

Doria/Warris

Hi,

I have one excel sheet with10columns and in every of them I need to enter
values that are contained in another table (different format, but columns
have same header name).
Since I have to do this job for more tables, instead of picking up the
values manually and paste them in the sheet, I'd like to automate the
process.

Can anybody help?

Thank you
Alex
 
F

Frank Kabel

Hi alex
could you explain a little bit more how your data is structured and how
you want to transfer the data automatically (maybe give an example)
 
N

Nigel

A very simple method if you want to copy just the values from a range on one
sheet1 to other sheets (in the example sheet2 and sheet3) follows.....

Sub CopyMultiple()

Sheets("Sheet1").Range("A2:H15").Copy

Sheets("Sheet2").Range("A2").PasteSpecial Paste:=xlPasteValues

Sheets("Sheet3").Range("A2").PasteSpecial Paste:=xlPasteValues

Application.CutCopyMode = False

End Sub

Cheers
Nigel
 
F

Frank Kabel

Hi
first: please don't attach files to this NG. alsways post in plain
text!

For your question: Insert the following formula in B14:
=IF(ISNA(INDEX($A$1:$G$9,MATCH($A14,$A$1:$A$9,0),MATCH(B$13,$A$1:$G$1,0
))),"",INDEX($A$1:$G$9,MATCH($A14,$A$1:$A$9,0),MATCH(B$13,$A$1:$G$1,0))
)
and copy this formula down/to the right
 
Top