Hi, I have a column with data as
0-30
31-60
61-90
91-180
>180.
I am able to filter out all values using VBA but when it comes to ">180", I am not able to select that value as criteria in autofilter.
Can somebody please help me in this !!!!
Thank you.
Hi All,
I want to separate out data tht was entered using Alt+enter. I have used TTC but the problem is that it does not give the desired output. With TTC, the data gets separated into different columns. I do not want that. I want to separate the data into single column but in different rows...
I have a zipped folder of excel files (around 16). I want to process these files using a macro one by one. I used the following code:
Set folderPicker = Application.FileDialog(msoFileDialogFolderPicker)
With folderPicker
.AllowMultiSelect = False
.ButtonName = "Pick Folder"
.Show
End With...
Hi, i have huge data in the excels which i need to process. All the processing is done with the help of Macro,which is working fine. But it takes a lot of time for the macro to open the excel file (list of files) as the data is huge. Is there a way by which i can read the data in the workbook...