Thread: new worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ram Ram is offline
external usenet poster
 
Posts: 138
Default new worksheet

I have a excel worksheet with bunch of columns.
Now I want to create a new excel sheet with only selected columns.
And user will be prompted to input the columns may be with a inputbox only
for onetime.
Example:
Let us say abc.xls has A to H columns.
User will input A C E
New excel sheet will have A, C and E columns only from abc.xls.