Solved

Copy paste Excel

Posted on 2013-01-15
6
189 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

830 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