W.E.B
asked on
Copy paste Excel
Hello,
Sheet one contains all information.
I'm trying to find the Accounts under Column B, create a new sheet with same name, copy the header, and rows into new sheet,
Attached Sample.
Can someone help with a vb code that can accomplish this.
Any help is appreciated.
Thank you.
Sample.xlsx
Sheet one contains all information.
I'm trying to find the Accounts under Column B, create a new sheet with same name, copy the header, and rows into new sheet,
Attached Sample.
Can someone help with a vb code that can accomplish this.
Any help is appreciated.
Thank you.
Sample.xlsx
ASKER
Hello gowflow,
I appreciate your help,
the code you sent me only works on small files.
if I put 50 or 100 raws, works great.
If I put about 1000 or above , it freezes and not responding.
I will have almost 10000 / more/less Raws. (about 25 Sheets to be created).
Thanks
I appreciate your help,
the code you sent me only works on small files.
if I put 50 or 100 raws, works great.
If I put about 1000 or above , it freezes and not responding.
I will have almost 10000 / more/less Raws. (about 25 Sheets to be created).
Thanks
ok fine let me review. One question is the formating important in your sheets ? Is the sheet1 you posted the same format as your original ? like does columns hv special number format etc ... can oyu post the main sheet that hv some data (change sensitive data) so I can fine tune it ?
gowflow
gowflow
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome,
Thank you very much.
Thank you very much.
Your welcome anytime.
gowflow
gowflow
Make sure macroes are activated and run the Macro called SubCategorySplit
Let me know
gowflow
Sample-Account.xlsm