Blue_Bunny
02-26-2008, 10:04 AM
Hello All -
I am creating a workbook that will serve as a front end to build a SQL database.
I envision a solution that will permit the user to highlight a series of columns from a raw data workbook that will ultimately define a table. That is, my objective is to lock down a list of columns from worksheet(1) that will define the columns in a second worksheet or worksheet(2) in the same file. Then, after the user reviews the column list from step 1 they will be able to drag and drop the columns in a particular order and further define the columns. I will end up creating an area within worksheet(2) where these columns can be further defined and manipulated, but I wanted to start with the column definition and drop and drop behavior.
I was thinking of a solution that would not necessarily use the entire column from sheet1, but just the column headings. That made me think of the Pivot Table interface where the user can simply drag different columns into the Row, Column and Data areas of the Pivot Table.
I have spent some time searching the net, but not much luck. Any ideas?
I am creating a workbook that will serve as a front end to build a SQL database.
I envision a solution that will permit the user to highlight a series of columns from a raw data workbook that will ultimately define a table. That is, my objective is to lock down a list of columns from worksheet(1) that will define the columns in a second worksheet or worksheet(2) in the same file. Then, after the user reviews the column list from step 1 they will be able to drag and drop the columns in a particular order and further define the columns. I will end up creating an area within worksheet(2) where these columns can be further defined and manipulated, but I wanted to start with the column definition and drop and drop behavior.
I was thinking of a solution that would not necessarily use the entire column from sheet1, but just the column headings. That made me think of the Pivot Table interface where the user can simply drag different columns into the Row, Column and Data areas of the Pivot Table.
I have spent some time searching the net, but not much luck. Any ideas?