Storing and Organizing Data

[zachfry]

I'm setting up a type of form in excel where I have some validated drop down lists and I'm trying to use a macro that will, upon a button click, take the data from the drop down lists that are entered into the boxes, and organize them into a chart on a different sheet of the document. This would be the form with some drop down lists.

Juice Type	Apple
Juice Size	8 oz.
Juice Buyer	Ronald

<tbody>
</tbody>

I want to add it in to a table with every button click filling in a new row in a table like this,

Juice Type	Juice Size	Juice Buyer
Apple	8 oz.	Ronald

<tbody>
</tbody>

Thanks so much for any help in advance.

 

[oldbrewer]

you need 3 clicks to get your raw data say it is in A1 B1 C1

the macro needs to copy this and paste to say P1 Q1 R1
the macro needs to add 1 to a counter that was initially set to zero

now 3 more clicks
the macro now copies and pastes to P2 Q2 R2
P2 = cells(16,2)
and sets the counter to 3 ready for the next time

can you manage that ?

 

[zachfry]

Thanks for the feedback first off.
But I'm not sure how to create and add to that counter.

 

[oldbrewer]

in the macro put a line counter = counter +1
or

cells(1,26)=cells(1,26)+1
this means Z1 is increased by 1 so you use cells(1,26) as the counter