VBA Copy Rows From One Workbook To text csv File Based On Count In Different Workbook. Cross Posted Chaos

[fixer]

No Doubt Bro Obviously i am waiting for Alan Sir Only
But i dont want to irritate Alan bcoz he has helped me alot
So meanwhile i am thinking about the different ways to solve the same bcoz if Alan was unable to do the same then i will require a
a different strategy to solve the same

[sandy666]

different way? post#33 - Power Query

[fixer]

No we will solve the Problem with 2 macros
Bcoz we will break the process into 2 pieces one macro to count total no. of rows
& second macro for copy paste to csv
It will be easier to understand & easy to solve

[DocAElstein]

... i am waiting for Alan Sir Only
But i dont want to irritate Alan bcoz he has helped me alot
So meanwhile i am thinking about the different ways to solve the same bcoz if Alan was unable to do the same then i will require a
a different strategy to solve the same

I cannot solve a problem if I do not know what the problem is.
I cannot answer a question if I do not know what the question is.
The problem in helping you is always the same. It is not VBA Excel problem. Problem is you are not English. You do not understand English language. Problem is always you and English language.

You ask Question A - We give Answer A
You ask Question B - We give Answer B
Usually, those are not the answers that you want...
You want Answer F - But you cannot speak English. You cannot understand English. You cannot write English. You do not understand English language.
You try to ask question F. But you fail. You ask any question. You ask always wrong question. You write mostly rubbish.

We must keep trying to guess what you want

---

If you want more help from me – Do all this:
_1) Read this : https://excelfox.com/forum/showthrea...ll=1#post13222
_2) Read this : https://excelfox.com/forum/showthrea...ll=1#post13208
_3) Run macro Sub Step14_DogShit() https://excelfox.com/forum/showthrea...ll=1#post13217

_4) Now tell me what that macro does for you? - What results do you get ?

_.____

You have the whole day , Today , to do this all. Take your time. Do it all. Read it all. Do it slowly. I will not answer any more here today. This is my last post here today.
I will look again tomorrow.

---

If you cannot understand what we write, and if you do not do what we ask, then only God can help you. God can see inside your head. God knows what is your question. We are not God. We cannot see inside your head.

[fixer]

U haven't understood the problem
but u have mentioned something plz see the sample pic of the same Doc Sir
U can run the macro and u can see the output is this the same out put which u get after runing the macro which u mentioned in the pic
No Probelm Doc Sir
i am breaking the process in two parts
1)first macro for counting the rows
2)second macro for copy paste

[sandy666]

the problem is because you trying open csv (result) by double click which is not a proper action
you should import csv with defined delimiter (tab)
with double click, Excel ignore tab as delimiter and you've all data in single column

as i said this is a comma separated values type of file and if you define delimiter in your vba comma instead of tab it will work with dbl click or just import

Alan did his job great with your requirement and you got csv with copied data, but what will you do with this csv (and problems with that) is on your side

regards

[fixer]

sandy sir plz share the complete working code if u know
Bro i am not that much smart in vba
U r giving me the hint
But i dont know much about vba
I am not a Vba coder
My dream is to become a Speculator
& without u I can't create a system & if i am unable to create a system then i cant achieve my dream

[sandy666]

I think you got a vba code in the first few posts from Alan
the code generate result with tab as delimiter but you trying to open this csv in Excel by double click not import with defined delimiter (tab)
you got what you want but you didn't say what you want to do after vba generate csv file

you should use this option if you want "open" csv with tab delimiter in Excel
frmt.png

[fixer]

No i want to make it automatic, vba code should do all the work
I will not do any manual work

[sandy666]

so you don't need step(s) with csv
just create vba to generate result directly in excel