Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
tab delimited file n sorting by columns
i have a prob with some tab delimited files and excel... is there a way i can import them into the excel then sort them to different sheets base on the name column? the tab delimited files do not have a header. for ex in the tab delimited files.. 01/01/01 01:01:01 Name1 IN 01/01/01 01:01:05 Name2 IN 01/01/01 01:01:10 Name2 OUT 01/01/01 01:01:15 Name1 OUT -- TimezZ ------------------------------------------------------------------------ TimezZ's Profile: http://www.excelforum.com/member.php...o&userid=31081 View this thread: http://www.excelforum.com/showthread...hreadid=507567 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
tab delimited file n sorting by columns
Try this
Go to DATA Select TEXT TO COLUMNS Select DELIMITED option check the TAB,SPACE box Click finish your data would be prased |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
tab delimited file n sorting by columns
oops my bad i forget to mention the tab delimited files are in txt.(notepad type of file) is there a coding or something in which it will take then out n put those in different name into different sheets? (in the same work book) sorry abt this but i m not gd in programming :( -- TimezZ ------------------------------------------------------------------------ TimezZ's Profile: http://www.excelforum.com/member.php...o&userid=31081 View this thread: http://www.excelforum.com/showthread...hreadid=507567 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
tab delimited file n sorting by columns
Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
may be sufficient right out of the box. Debra's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm TimezZ wrote: i have a prob with some tab delimited files and excel... is there a way i can import them into the excel then sort them to different sheets base on the name column? the tab delimited files do not have a header. for ex in the tab delimited files.. 01/01/01 01:01:01 Name1 IN 01/01/01 01:01:05 Name2 IN 01/01/01 01:01:10 Name2 OUT 01/01/01 01:01:15 Name1 OUT -- TimezZ ------------------------------------------------------------------------ TimezZ's Profile: http://www.excelforum.com/member.php...o&userid=31081 View this thread: http://www.excelforum.com/showthread...hreadid=507567 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
tab delimited file n sorting by columns
Thx a lot for the samples... they r indeed very helpful... :) -- TimezZ ------------------------------------------------------------------------ TimezZ's Profile: http://www.excelforum.com/member.php...o&userid=31081 View this thread: http://www.excelforum.com/showthread...hreadid=507567 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tab delimited file convert to columns | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
Open delimited text file to excel without changing data in that file | Excel Programming |