| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy Ranges to other workbook.
hi, i need to take an area from one excel and to copy it to another workbook.
i want that the ranges that appear in that area will be included also. i selected the area, and tried to do copy and insert copied cells, but only part of the ranges were copied... thanks. -- Miri Tz. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy Ranges to other workbook.
Any chance you had hidden rows or hidden columns that got filled in with the
paste? Miri wrote: hi, i need to take an area from one excel and to copy it to another workbook. i want that the ranges that appear in that area will be included also. i selected the area, and tried to do copy and insert copied cells, but only part of the ranges were copied... thanks. -- Miri Tz. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy Ranges to other workbook.
no.
i mean, i need to copy cells. (includes the data, formating and also the range names.) maybe i can do it by macro. but how should i get the range names that included in my selection to copy...? -- Miri Tz. "Dave Peterson" wrote: Any chance you had hidden rows or hidden columns that got filled in with the paste? Miri wrote: hi, i need to take an area from one excel and to copy it to another workbook. i want that the ranges that appear in that area will be included also. i selected the area, and tried to do copy and insert copied cells, but only part of the ranges were copied... thanks. -- Miri Tz. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy Ranges to other workbook.
Maybe you can loop through all the range names on that worksheet and see if any
are completely included in the range to be copied. Then apply those range names to the pasted area on the other sheet???? Miri wrote: no. i mean, i need to copy cells. (includes the data, formating and also the range names.) maybe i can do it by macro. but how should i get the range names that included in my selection to copy...? -- Miri Tz. "Dave Peterson" wrote: Any chance you had hidden rows or hidden columns that got filled in with the paste? Miri wrote: hi, i need to take an area from one excel and to copy it to another workbook. i want that the ranges that appear in that area will be included also. i selected the area, and tried to do copy and insert copied cells, but only part of the ranges were copied... thanks. -- Miri Tz. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy Ranges to other workbook.
And maybe you'll get a better response at your other post.
Dave Peterson wrote: Maybe you can loop through all the range names on that worksheet and see if any are completely included in the range to be copied. Then apply those range names to the pasted area on the other sheet???? Miri wrote: no. i mean, i need to copy cells. (includes the data, formating and also the range names.) maybe i can do it by macro. but how should i get the range names that included in my selection to copy...? -- Miri Tz. "Dave Peterson" wrote: Any chance you had hidden rows or hidden columns that got filled in with the paste? Miri wrote: hi, i need to take an area from one excel and to copy it to another workbook. i want that the ranges that appear in that area will be included also. i selected the area, and tried to do copy and insert copied cells, but only part of the ranges were copied... thanks. -- Miri Tz. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy formula but only increment certain ranges? | Excel Discussion (Misc queries) | |||
| Copy and SUM functions with different ranges | Excel Worksheet Functions | |||
| Copy worksheet ranges from One Workbook to another from | Excel Worksheet Functions | |||
| Copy entire ranges | Excel Worksheet Functions | |||
| copy ranges from multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
