Hi,
I had a situation;
I have one main csv file namely - "Downloaded_Data" which basically the master or the primary source file.
Then there are multiple csv files that file name begins with s - on this sample I given one file only namely - "S12345.csv" (but it might come in multiple files...
Hello,
Thank You so much,
Your second macro is working but it's only in active cell.. is it possible that when i select the entire column the macro will run instead of one by one cell?
It's perfect...
Hi,
Wow Thank You
Almost done but if data is like this
80 ABCDEFG 15 HIJKL 5 MNOP LININ: 100 WXYZ
RESULT IS
80% ABCDEFG 15% HIJKL 5 MNOP LININ: 100 WXYZ%
notice that the % is not coming in middle and in last number also, no % symbol, instead it went on the last portion....
Hi,
I have a cell with alphanumeric character the problem is, i want to put percentage symbol in any number on that cell..
Here is a sample data in cell..
ABC 95 CDF 100 KLM 9
CD 124 AGH 29 QLK 12
That sample above is a two rows in one column on that column I want to put a % symbol in the...
I tried to run in 300K lines and still showing overflow when tried to debug it goes on this line j = j + 1
output came but some lines did not total it repeating as other line not total..
I tried to reduce the nos of rows from 1M into just 1K but the macro just keep on running for long time..
Can someone help me with this, badly needed...
Hi Belleke,
Sorry to bother you again,
Actually today I run your Macro but the things is I run it in a data with 1048574 number of rows hence i received a run time error '6' overflow
and when i click debug button it goes here
count = Application.WorksheetFunction.CountIf(Sheets("STORE COUNT...
Basically, there should be a breakdown of how many are equal and less than 0
in each and everything in column P, as that is the most important, then finally in the button the total of it..
Note: That its should show the pivoted total of each category, as I tried to add another line, it;s...
HI,
That is what exactly what im looking for, but it should give the breakdown also of each, not only total.. In user Form it should be,
Category 16 SH That is less than or Equal to 0
ANDROMEDA 1
ASTEROID 1
MARS 1
OMEGA 1
OMNICRON 1
RIEGEL 1
Grand Total 6
Hi,
I need a macro that when button press will create either a Pop UP (Msg Box) or a New Excel Sheet base on a given condition of a certain column like counting the number of SH with less than or equal to Zero then it will pop up (msg box) or create a new excel that will give those categories...
Yes I do have.
Its very fine now, but again need help, I sent a msg to your mail privately.
Thank You so much for your macro, such a big help. But one more help, I need a Macro based on your output macro that when a macro button click, it will pop up a msg box and will show the total of all S...
HI p45cal,
It's more than enough, thank you so much for your great help, I done this in Power Query of excel but there is a limitation also while doing tranSpose as it is a huge data, but no problem, i will just limit some columns in the back end query to reduce data number rows and your macro...
Hi All,
I have an excel sheet in sheet 1 is my source file, I want a macro that will create 2 sheet base on the given condition as per sheet 1 as source:
Condition 1 ): It will create a sheet 2 and do the sum and pivot for Total Zero sold, destination wise.
Condition 2: It will create a sheet...