I am importing tabular information direct into Excel. However, I want to get the spreadsheet to ignore certain column's automatically without manual intervention. How do I do it?
Anyone know how?
Thanks
I am importing tabular information direct into Excel. However, I want to get the spreadsheet to ignore certain column's automatically without manual intervention. How do I do it?
Anyone know how?
Thanks
Hi,Originally Posted by Boro
If you're referring to .csv or .prn files, then the import wizard allows you to select columns that you don't want to import. If you don't want to do this manually you could have a macro perform the same steps.
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks