Shailender
Member
Vletm, thank for your help and sorry for the delay in responding.
Here the biggest challenge is we are not using the XLSB version of excel.So how can i do it in XlSX verison?
Sub column for each category
- Thread starter Shailender
- Start date
Here the biggest challenge is we are not using the XLSB version of excel.So how can i do it in XlSX verison?
Shailender
You have asked that already ...
and
I have answered too, reread #19 reply!
If NO MACROS then
... hmm ...
You would do it
... 'manually'
or
... at place, where is possible to use Macros!
You have asked that already ...
and
I have answered too, reread #19 reply!
If NO MACROS then
... hmm ...
You would do it
... 'manually'
or
... at place, where is possible to use Macros!
Shailender
Member
ok, Vletm. I have the option to use macros. what would be the code if i want to write in XLSX...? Could you please suggest..?
Shailender
Member
Yes,
Shailender
Member
Vletm, it is working well. Thank you for it. Could you please let me know how did you do this? Did you do formatting cells or some other thing like this..?
Shailender
Member
I reread it, still confusing how it can happen automatically? Sorry for bothering you please bear me.
hmm ...
Nothing happens automatically ...
There is code which will make it.
With macros can make ex loops ...
in which it can check cell-by-cell from 2nd row as many times as there will be values and
inspect the way how You have written those texts.
You used one option and
depends that option it will copy value correct column right.
... for some good reason,
You will have some cell values two times in sheet.
>> and >>
If You follow that step-by-step instruction
then above acts will do same acts.
Nothing happens automatically ...
There is code which will make it.
With macros can make ex loops ...
in which it can check cell-by-cell from 2nd row as many times as there will be values and
inspect the way how You have written those texts.
You used one option and
depends that option it will copy value correct column right.
... for some good reason,
You will have some cell values two times in sheet.
>> and >>
If You follow that step-by-step instruction
then above acts will do same acts.
Shailender
Member
Ok, thank you for your patience and insights. I will try writing the macro code for this.
Shailender
Member
Could i know were is the macro code for this..?
Sorry ... but do I repeat myself?
Have You skipped all my replies?
As written in #25 Reply almost clear HINT!
Below is a snapshot of that Macro
which You should use
while You will run this to those other files!
... and follow those step-by-step instruction! (and follow really means follow!)
Have You skipped all my replies?
As written in #25 Reply almost clear HINT!
Below is a snapshot of that Macro
which You should use
while You will run this to those other files!
... and follow those step-by-step instruction! (and follow really means follow!)
Shailender
Member
I didn't missed any reply from you, Apologies i could not see any macro code in that post #25 sheet. Could you please send me that sheet again so that i can use that macro,
The newest file has same code as .xlsb-file!
Did You try to follow that step-by-step ...
step 4) there should be also button [Edit] ... press it!
YOU CAN USE THAT MACRO ONLY AS WRITTEN IN THAT INSTRUCTION!
If You do something different .. or change it ...
yes - have backups!
... or do You have any idea,
why did I wrote those instructions?
Did You try to follow that step-by-step ...
step 4) there should be also button [Edit] ... press it!
YOU CAN USE THAT MACRO ONLY AS WRITTEN IN THAT INSTRUCTION!
If You do something different .. or change it ...
yes - have backups!
... or do You have any idea,
why did I wrote those instructions?
Shailender
Member
Vletm, I am really sorry to trouble you, I can able to see the code now. Once again thank you for your patience and time. I really appreciate it. Thank you. Cheers.
Shailender
Member
When i am trying to run the code which is there in sheet1 as you suggested it is working well for me. thank you.