Create Macro to create worksheets based summary sheet

Closed
Russell - May 25, 2016 at 11:07 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - May 25, 2016 at 07:35 PM
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

Blocked Profile
May 25, 2016 at 04:43 PM
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!
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
May 25, 2016 at 07:29 PM
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.
0
Blocked Profile
May 25, 2016 at 07:30 PM
Thank you vcoolio!
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252 > Blocked Profile
May 25, 2016 at 07:35 PM
You're welcome ac3mark. I should get back to work now!
0