|
|
TextToColumn when destination to other sheet
God day Group,
Is it at all possible to destinate the the split columns to another
worksheet when using the TextToColumn wizard? Can it be made
by code? When trying in the wizard I get the error message about
wrong destination reference.
Brgds
CG Rosen
|
|
0
|
|
|
|
Reply
|
 CG
|
11/17/2009 8:48:28 PM |
|
Only the current sheet is possible
--
Gary''s Student - gsnu200908
"CG Rosen" wrote:
> God day Group,
>
> Is it at all possible to destinate the the split columns to another
> worksheet when using the TextToColumn wizard? Can it be made
> by code? When trying in the wizard I get the error message about
> wrong destination reference.
>
> Brgds
>
> CG Rosen
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
11/17/2009 8:57:01 PM
|
|
I don't think so.
But you could copy the column range to a (separate, new, temporary) worksheet,
do the text to columns and put the parsed data where you want.
CG Rosen wrote:
>
> God day Group,
>
> Is it at all possible to destinate the the split columns to another
> worksheet when using the TextToColumn wizard? Can it be made
> by code? When trying in the wizard I get the error message about
> wrong destination reference.
>
> Brgds
>
> CG Rosen
--
Dave Peterson
|
|
|
0
|
|
|
|
Reply
|
Dave
|
11/17/2009 8:57:54 PM
|
|
Thanks / cgr
"Gary''s Student" <GarysStudent@discussions.microsoft.com> skrev i
meddelandet news:1ADEBD72-C993-49FB-BCBF-BC5089C38C45@microsoft.com...
> Only the current sheet is possible
> --
> Gary''s Student - gsnu200908
>
>
> "CG Rosen" wrote:
>
>> God day Group,
>>
>> Is it at all possible to destinate the the split columns to another
>> worksheet when using the TextToColumn wizard? Can it be made
>> by code? When trying in the wizard I get the error message about
>> wrong destination reference.
>>
>> Brgds
>>
>> CG Rosen
>>
>
|
|
|
0
|
|
|
|
Reply
|
CG
|
11/17/2009 9:09:36 PM
|
|
Thanks for info / cgr
"Dave Peterson" <petersod@verizonXSPAM.net> skrev i meddelandet
news:4B030E52.8EF21F21@verizonXSPAM.net...
>I don't think so.
>
> But you could copy the column range to a (separate, new, temporary)
> worksheet,
> do the text to columns and put the parsed data where you want.
>
>
>
> CG Rosen wrote:
>>
>> God day Group,
>>
>> Is it at all possible to destinate the the split columns to another
>> worksheet when using the TextToColumn wizard? Can it be made
>> by code? When trying in the wizard I get the error message about
>> wrong destination reference.
>>
>> Brgds
>>
>> CG Rosen
>
> --
>
> Dave Peterson
>
|
|
|
0
|
|
|
|
Reply
|
CG
|
11/17/2009 9:10:08 PM
|
|
|
4 Replies
482 Views
(page loaded in 0.132 seconds)
Similiar Articles: TextToColumn when destination to other sheet - microsoft.public ...transposing across different worksheets - microsoft.public.excel ... How to sort data from one worksheet into other worksheets ... TextToColumn when destination to ... Adv. Filter - Want to copy to inactive sheet - microsoft.public ...TextToColumn when destination to other sheet - microsoft.public ... Adv. Filter - Want to copy to inactive sheet - microsoft.public ... You must start the operation from ... W2003, batch converter wizard: call from cmd (batch) - microsoft ...TextToColumn when destination to other sheet - microsoft.public ... NFile ' Call AutoFit on the ... using the Text To Columns command in Excel This site in other countries ... Copy sheet to different workbook sizing error message - microsoft ...TextToColumn when destination to other sheet - microsoft.public ... Copy sheet to different workbook sizing error message - microsoft ... Goes on to tell me > to C&P into ... Merging all the sheets in the folder - microsoft.public.excel ...Export multiple Excel sheets to a single text file - microsoft ... the other ... from all files in a specified folder. ... NFile ' Call AutoFit on the destination sheet so ... How to lock scrolling? - microsoft.public.excel.miscHow to do this? -- Life isa journey not a destination ... scrolling, the report created should be viewed as one A4 > sheet, users must not see an other ... Copying Date and pasting special - DATE CHANGES?!? - microsoft ...Hi In the destination sheet you are using 1904 date system, but not in source sheet. ... previous post: One workbook was using a base year of 1900 and the other was ... autofilter master copy data to worksheet - microsoft.public.excel ...The summary sheet should be > created > in the ... Rng = ActiveSheet.AutoFilter.Range Rng.Copy Destination ... Excel :: Autofilter Copy Data To Other Sheet Autofilter ... copy multiple rows - microsoft.public.excel.programming ...--If you mean to copy subsequent rows to the other sheet; then you havent ... Sheet1") 'source sheet > > > > > > > Set ws2 = Sheets("Sheet2") 'destination sheet ... Calculating(Processor(2)): % - microsoft.public.excel.programming ...I have other macros running in this same workbook and they run fine. My ... Range("A" & StartRow & ":F" & EndRow).Copy _ Destination:=Sheets("Tally ... TextToColumn when destination to other sheet - microsoft.public ...transposing across different worksheets - microsoft.public.excel ... How to sort data from one worksheet into other worksheets ... TextToColumn when destination to ... How to parse data using the Text To Columns command in ExcelThis site in other countries/regions: ... In Step 3 of the Convert Text To Columns Wizard, type B1 in the Destination box, and ... VBA code for Text to Column | Excel & VBA – da Tab Is OnHere is a basic VBA code for converting Text to Column that ... Destination:=Cells(1, col.Column), _ DataType ... Ted: Renaming the sheets was helpful. Thank you... Move or copy a worksheet - Excel - Office.comThen hold down CTRL while you click the tabs of the other sheets ... fonts, colors, and effects that are applied to the destination workbook. To change the color of the sheet ... Excel Destination - Microsoft Corporation: Software, Smartphones ...The Excel destination loads data into worksheets or ranges in Microsoft Excel workbooks. ... numeric columns are interpreted as doubles (DT_R8), and all string columns (other ... 7/22/2012 2:18:29 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
68 followers. 