Excel dropdown box help

[Davy Newbold]

Hello,

I have 3 individual worksheets and 3 main worksheets,
I am looking to create a dropdown box for the 3 individual worksheets, the dropdown box should contain the names of the 3 main worksheets,
when a main worksheet is selected I want the data on the column to be extracted and go on the next available line on the main worksheet selected,
the column from which the data is extracted should then be deleted as if the column has been selected as hidden,

can anyone help me!!!

[Richard Buttrey]

Hi, and welcome to the forum.

Before creating something which may just complicate matters down the line, do you really need 6 worksheets?

This sounds like you have some sort of process for capturing data and then copying that data to another worksheet. Can I suggest that you create a single database sheet in a normalised 2 dimensional table format. If the current three main worksheets have different meanings or represent different records, then build an additional column into your database so that each row identifies the meaning in the dedicated column.

Once you have a proper database you can then easily extract information from it in whatever format you want.

[Davy Newbold]

Hello,

I have created a quotes spread sheet for hire of equipment,
I have 3 individual worksheets for 3 separate peoples quotes, which include date, time, customer, description, and booked date,
the 3 main worksheets, are 'currently on hire, off-hired, and sales, I need the dropdown box to remove the data from the individual worksheets and move it to the main worksheets chosen in the dropdown box.

[Richard Buttrey]

I see nothing in your description which changes my view.

Capture your quotes details on a single dedicated worksheet. As well as the quote details, have a column to record the people's names and of course a column to record the status of the quote when it is accepted (presumably defaulting to 'On Hire')

As each new quote is added have a macro update a single sheet database with the details then clear the quote values ready for the next quote.

As the status of the quote changes to say 'off hired' change the database record,
Since you will then have all the information you need in a single database table, analysing it is simplified. You could if you wanted extract specific records to another sheet but personally I'd just use functionality like Autofiltering or Pivot Tables

[Davy Newbold]

So do you know how to do it? I know it would make sense to do it that way but, im trying to keep it as simple as possible by us each having separate sheets

[Davy Newbold]

So Can This Not Be Done?????????

[Richard Buttrey]

So Can This Not Be Done?????????

Yes, most things can. You'll need a macro though.

Can I suggest you use the macro recorder to capture the code as you manually perform the task. Then when you have that it will need editing / modifying to take account of the sheets in question.
Or perhaps just copy the macro a couple of times so that you have three macros, the only difference being the sheet names that are used and use the appropriate macro.

[Richard Buttrey]

So you thought I deserved a negative rep for suggesting one way forward, as well as offering advice about what would be a more elegant way.

Well thanks. You really won't get very far in this forum if you continue in this way. Have you wondered why no one else has stepped in with any suggestion?

[Richard Buttrey]

...more

For the record on the negative rep you said

"Didnt tell me what i was asking for, wanted me to change what i have in place"

Let me tell you how this forum works. We all give of our time freely, sometimes a great deal, and we genuinely want people to understand Excel and all that it can do.

We know that those new to Excel often don't do things in the most efficient and elegant way and for that reason we offer advice and suggest improved ways of doing things. You don't have to accept the advice but neither do we appreciate being given negative reps for offering it, that's why we're here and just about everyone but you seemingly understands that and generally welcomes such advice.

Your first statement is in any case simply not true, in post #7 I suggested a way forward using your existing layouts, which we have to guess at since you didn't bother to upload any example workbooks. So I take exception to that comment.

I did indeed suggest you change what you have in place. Do you have a problem with that? One of the benefits of obtaining advice here is to learn. Shut yourself off from this advice and your Excel skills will not develop. That's up to you of course.

Now it would be appreciated if you would acknowledge on reflection that the negative rep was not warranted here.

[Davy Newbold]

Hello,

I have created a quotes spread sheet for hire of equipment,
I have 3 individual worksheets for 3 separate peoples quotes, which include date, time, customer, description, and booked date,
the 3 main worksheets, are 'currently on hire, off-hired, and sales, i want to create a drop down box at the end of each row of information, I need the dropdown box to remove the data from the individual worksheets and move it to the main worksheets chosen in the dropdown box.

[Davy Newbold]

[FDibbins]

Unless you have already done so, and I missed it, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Also, please check your inbox for a PM from me.