Create Macro to create worksheets based summary sheet [Closed]

Report
-
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
-
Hello,

I have an extremely long list of inventory items by department number. What I want to do is create a individual worksheet for each departments inventory items.

The summary data is from A1:V3865. The department numbers start on A2. So for example for department 100, there are 112 records i'd like to be automatically moved to a department 100 tab so that it show the department number for the tab name, then all of the data from column A:V show up in the worksheet for tab 100......for department 101, there are 76 records i'd like to move to a department 101 tab and so on...

Any one had any experience with this?

Thanks

2 replies


I encourage you to move to a DATABASE, and not a spreadsheet. A spreadsheet is for mathematical calculations, not keep inventories (not when they are of the size you have described!)

If you must stay on the spreadsheet, start the manual migration now!
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
229
Greetings Gentlemen,

I hope that you don't mind me putting in my two cents worth but Russell may be interested in having a look at the sample file at the following link:-

https://www.dropbox.com/s/ppe9ukewz9po3e1/Teke%20%283%29.xlsm?dl=0

The code is one that I wrote for another Poster a few months ago and I believe it is a similar scenario to Russell's. Click on the button to see it work.

Russell, see if you can adapt it to suit your needs. Let us know if it works for you and post back should you require any further help.

Cheerio Gentlemen,
vcoolio.
Blocked Profile
Thank you vcoolio!
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
229 > Blocked Profile
You're welcome ac3mark. I should get back to work now!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!