Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picking up values from other tables
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picking up values from other tables
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) -- Regards Frank Kabel Frankfurt, Germany Doria/Warris wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picking up values from other tables
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 "Doria/Warris" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picking up values from other tables
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),M ATCH(B$13,$A$1:$G$1,0 ))),"",INDEX($A$1:$G$9,MATCH($A14,$A$1:$A$9,0),MAT CH(B$13,$A$1:$G$1,0)) ) and copy this formula down/to the right -- Regards Frank Kabel Frankfurt, Germany Doria/Warris wrote: Frank, The source data is a plain excel table with 10 columns and 10 rows. The Y column in the destination file is a column including a formula to calculate certain parameters from the A,B,C, Rows. This makes the copy/paste process a bit longer because I have to do it line by line and splitted, the part before the Y first and then the part after the Y. The excel enclosed shows a sample. Hope this clarifies a bit more. Thank you Alex ... "Frank Kabel" wrote in message ... 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) -- Regards Frank Kabel Frankfurt, Germany Doria/Warris wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XY Scatter graph: x-axis picking up row numbers instead of values | Charts and Charting in Excel | |||
Picking values out | Excel Worksheet Functions | |||
Looping between sheets picking up values on the way | Excel Worksheet Functions | |||
Picking Values from a list | Excel Worksheet Functions | |||
picking out certain values | Excel Worksheet Functions |