• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

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
0
W.E.B
Asked:
W.E.B
  • 4
  • 2
1 Solution
 
gowflowCommented:
Is this what you want ?
Make sure macroes are activated and run the Macro called SubCategorySplit

Let me know
gowflow
Sample-Account.xlsm
0
 
W.E.BAuthor Commented:
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
0
 
gowflowCommented:
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
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
gowflowCommented:
I refined the code and added 20000 lines with lots of sheets and made it in a way to show you progress each time it creates a sheet. By the way it was not freezing your system but processing without showing anything !!!

Try this version and let me know.
gowflow
Sample-Account.xlsm
0
 
W.E.BAuthor Commented:
Awesome,
Thank you very much.
0
 
gowflowCommented:
Your welcome anytime.
gowflow
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now