Need help importing data to multple worksheets.

[jgonzo]

Hello All!

I just joined the Forum and I need some help. Can anyone show me how to import data from either a .txt or .csv file to multiple worksheets within the same workbook.

I am trying to avoid scrolling thru a ton of info in one worksheet.

Thank you all in advance for your help.

jgonzo

[David McRitchie]

No need to join a forum you are simply adding HTML overhead & banner
ads for yourself and messing up Google web searches for everyone by
using such sites that pass questions on to newsgroups and then save them
on websites to be indexed by search engines over and over again, when the
newsgroups themselves are already indexed by Google Groups. There are
many better solutions depending on whether you can use Outlook Express to
access newsgroups or not.

You can obtain code to basically do something very similar at
Importing text files larger than 65536 rows
http://support.microsoft.com/default...b;en-us;120596

after adding a new sheet you can rename that sheet
'Rename current Sheet
ActiveSheet.Name = "Renamed14a"
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jgonzo" <[email protected]> wrote in message
news:[email protected]...
>
> Hello All!
>
> I just joined the Forum and I need some help. Can anyone show me how to
> import data from either a .txt or .csv file to multiple worksheets
> within the same workbook.
>
> I am trying to avoid scrolling thru a ton of info in one worksheet.
>
> Thank you all in advance for your help.
>
> jgonzo
>
>
> --
> jgonzo
> ------------------------------------------------------------------------
> jgonzo's Profile: http://www.excelforum.com/member.php...o&userid=30530
> View this thread: http://www.excelforum.com/showthread...hreadid=501843
>