Hello
I have a large database of traffic signs which have different sheeting type, background colors and other attributes. I want to filter this database by type and produce new worksheets for each type. With in the work I want different ranges depending on the background color of the sign. I have attach a sample worksheet.
Any help you gave provide is welcomed!HELP Signs.xlsm
I am returning the file wesbb help.xlsm
the sheets other than "data" are AFTER RUNNING THE MACRO TEST
for retesting again run "test"
the macros and one function are parked in the module
if the data is large you may not know how many sheets to open and it will be difficult to add sheet names Even if NO extra sheets
were opened the macro will automatically insert necessary worksheets, give then names of the type and fill them up with data.
save this as another file (including macros) and delete the files other than "data" and test the macro "test"
the macros are given here for those who do not want to open the file
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
I am not an expert. better solutions may be available
[email protected]
Hi Wes88,
I'd leave all your data on a single sheet and learn about filtering or auto filters.
http://www.contextures.com/xlautofilter01.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks