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...
HI Kanti,
It is not just consolidation of hte data from different workbooks but it also needs processing it like filtering, separating data in different columns based on tabs and spaces, calculation etc...
So, I wanted to know whether there is a way to read the files without the need to...
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...
Thanks Luke. I have written a similar code for this but my concern is that:
"Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum))" ... this call, physically opens the excel file. For me it takes a lot of time as there is huge amount of data in the file to be read. I was wondering if I could...
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...