View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mintz87 Mintz87 is offline
external usenet poster
 
Posts: 5
Default How-Import 41 CSV files into 41 sheets?

i currently have a macro that will take 41 tabs of data and convert them into
41 "|" delimited csv files using each sheets tab name as the filename. Now I
have to reverse this process. This excel file will not be new, the data will
be importing into the 41 existing tabs that may or may not have data all
ready in them. Each tab has a header and some of the columns has to be in
text format due to having '0000' or '0123' as values (range of ph #'s).

Thanks in advance
Mintz