We help IT Professionals succeed at work.
Get Started

XL Userform to Create Sheets & Populate with Defined Data

361 Views
Last Modified: 2014-03-11
Hi All,

Given time I think I could figure this out with VBA but if someone can provide concept code that would be great.

I have attached a spreadsheet - it has a "Main" page with 3 columns of data (Category, Attribute & Property).   The idea is to use the main sheet to specify data to other sheets (new or existing).  

Each sheet represents a category (in other words each category gets its own sheet).  The data in the sheet is UNIQUE combinations of Attribute and Property.

Listbox 1 is used to select or create a new sheet (Category)
Listbox 2 & 3 are used as data on the new sheet (concatenate Attribute & Property)

In my demo file I have manually generated a sheet called Category1.  I hope to have a userform that is able to manually add to the category if the unique combination does not exist for that category.

I envisage single selection on Category, single selection on Attribute, and multiple selection on Property (combinations that already exist in the category would be indented and not selectable).
Pressing OK would:
 Create / Access a sheet with the name of the selected category
 Add the unique combinations of concatenate(Attribute & ":" & Property) to the category.

Confused? Pls let me know if you have questions.

Cheers,
Demo.xlsx
Comment
Watch Question
Partner
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE