Create Macro to create worksheets based summary sheet Closed

Question

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

ac3mark · Answer

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!

vcoolio · Answer

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.

Create Macro to create worksheets based summary sheet

2 responses

Similar discussions

Subscribe To Our Newsletter!