Solved

Copy paste Excel

Posted on 2013-01-15
6
188 Views
Last Modified: 2013-01-16
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
Comment
Question by:W.E.B
  • 4
  • 2
6 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 38780839
Is this what you want ?
Make sure macroes are activated and run the Macro called SubCategorySplit

Let me know
gowflow
Sample-Account.xlsm
0
 

Author Comment

by:W.E.B
ID: 38781009
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
 
LVL 29

Expert Comment

by:gowflow
ID: 38781475
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 29

Accepted Solution

by:
gowflow earned 400 total points
ID: 38781730
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
 

Author Closing Comment

by:W.E.B
ID: 38782205
Awesome,
Thank you very much.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 38782505
Your welcome anytime.
gowflow
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question