bebongtheshark
New Member
- Joined
- Jul 4, 2013
- Messages
- 1
Hi everyone
I'd like to ask if it is possible to mimic actions similar to a database but only within the same workbook. If it is possible, I'd like to get a structure code for macros so that I can follow and imitate =) Here's my specs:
Here is Sheet 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]Name[/TD]
[TD]Arthur McArthur Bennington (merged to Columns C and D)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]Age[/TD]
[TD]25 (not merged[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]Ques 1[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 5[/TD]
[TD]Ques 2[/TD]
[TD]333.667[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 6[/TD]
[TD]Ques 3[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 7[/TD]
[TD]Ques 4[/TD]
[TD](^*^&$^##^#%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]THERE IS SOME FORM OF SUBMIT BUTTON HERE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here is Sheet 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column G[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]No.
[/TD]
[TD]Name
[/TD]
[TD]Age
[/TD]
[TD]Q1
[/TD]
[TD]Q2
[/TD]
[TD]Q3
[/TD]
[TD]Q4
[/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]1[/TD]
[TD]Arthur McArthur Bennington[/TD]
[TD]25[/TD]
[TD]Y[/TD]
[TD]333.667[/TD]
[TD]N[/TD]
[TD](^*^&$^##^#%[/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD]2[/TD]
[TD]Kurt Cobain[/TD]
[TD]22[/TD]
[TD]N[/TD]
[TD]15.67[/TD]
[TD]N[/TD]
[TD]*&^()^(%$([/TD]
[/TR]
</tbody>[/TABLE]
The idea is that someone enters raw data or accomplishes Sheet 1 and presses submit button. That triggers copying of data to Sheet 2. Submit button also clears the data fields answered in Sheet 1 to enable next user to submit another set of data.
I think this is quite complex but I'm hoping someone can help me design or create an idea how to make this macro work =)
Best regards everyone! Thank you in advance for your help =D
I'd like to ask if it is possible to mimic actions similar to a database but only within the same workbook. If it is possible, I'd like to get a structure code for macros so that I can follow and imitate =) Here's my specs:
Here is Sheet 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]Name[/TD]
[TD]Arthur McArthur Bennington (merged to Columns C and D)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]Age[/TD]
[TD]25 (not merged[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]Ques 1[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 5[/TD]
[TD]Ques 2[/TD]
[TD]333.667[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 6[/TD]
[TD]Ques 3[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 7[/TD]
[TD]Ques 4[/TD]
[TD](^*^&$^##^#%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]THERE IS SOME FORM OF SUBMIT BUTTON HERE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here is Sheet 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column G[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]No.
[/TD]
[TD]Name
[/TD]
[TD]Age
[/TD]
[TD]Q1
[/TD]
[TD]Q2
[/TD]
[TD]Q3
[/TD]
[TD]Q4
[/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]1[/TD]
[TD]Arthur McArthur Bennington[/TD]
[TD]25[/TD]
[TD]Y[/TD]
[TD]333.667[/TD]
[TD]N[/TD]
[TD](^*^&$^##^#%[/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD]2[/TD]
[TD]Kurt Cobain[/TD]
[TD]22[/TD]
[TD]N[/TD]
[TD]15.67[/TD]
[TD]N[/TD]
[TD]*&^()^(%$([/TD]
[/TR]
</tbody>[/TABLE]
The idea is that someone enters raw data or accomplishes Sheet 1 and presses submit button. That triggers copying of data to Sheet 2. Submit button also clears the data fields answered in Sheet 1 to enable next user to submit another set of data.
I think this is quite complex but I'm hoping someone can help me design or create an idea how to make this macro work =)
Best regards everyone! Thank you in advance for your help =D