| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheet to sheet based on examples from ron
Hi!!
I use this based from examples from ron. GetData "c:\city breaks\priser\usa\fil.xls", "Fil", "A1:A2", Sheets("Fil").Range("A1"), True its works allright but now i would like to make it so i can use a value from a sheet to change the map name Like this GetData "c:\city breaks\priser\usa\"& priskalk!$A$1&"\fil.xls", "Fil", "A1:A2", Sheets("Fil").Range("A1"), True But it dosn't work with "& priskalk!$A$1&" i get an error here. CAn someone help me please. Best Regards Alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet to sheet based on examples from ron
Hi!!
i have found out how Alvin "Alvin Hansen" skrev: Hi!! I use this based from examples from ron. GetData "c:\city breaks\priser\usa\fil.xls", "Fil", "A1:A2", Sheets("Fil").Range("A1"), True its works allright but now i would like to make it so i can use a value from a sheet to change the map name Like this GetData "c:\city breaks\priser\usa\"& priskalk!$A$1&"\fil.xls", "Fil", "A1:A2", Sheets("Fil").Range("A1"), True But it dosn't work with "& priskalk!$A$1&" i get an error here. CAn someone help me please. Best Regards Alvin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| Copy certain cells in a row to another sheet, based on certain val | Excel Worksheet Functions | |||
| Copy an additional row based on another sheet | Excel Discussion (Misc queries) | |||
![Alvin Hansen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
