Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 18 January 2018
  0 Replies
  3.3K Visits
1) I have a workbook with multiple sheets in it.
2) Those multiple sheets are having multiple columns.
3) I have one column in each sheet which is concatenation of all the other columns.
4) Now, I want to extract that concatenated column to a text file with the same name as sheet name.
5) The way I want is I just press one button and it should look for all the tabs, extract that column (say concatenated column is AA) from each sheet, put that into a text file, name the text file same as sheet name and store in some directory on my desktop say H drive.
There are no replies made for this post yet.