Solved

Copy paste Excel

Posted on 2013-01-15
6
186 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:Wass_QA
  • 4
  • 2
6 Comments
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
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:Wass_QA
Comment Utility
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
Comment Utility
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 29

Accepted Solution

by:
gowflow earned 400 total points
Comment Utility
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:Wass_QA
Comment Utility
Awesome,
Thank you very much.
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
Your welcome anytime.
gowflow
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now