Macro to transfer data from one sheet to another

Closed
bebongtheshark Posts 1 Registration date Thursday July 4, 2013 Status Member Last seen July 4, 2013 - Jul 4, 2013 at 10:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 4, 2013 at 11:38 AM
Hello,


I would like to know whether this is possible using macros in excel

Sheet 1

Column A Column B Column C Column D Column E Column F
Row 1 Name Bebongtheshark <---merged
Row 2 Age 25
Row 3
Row 4 Q1 Yes
Row 5 Q2 The circumference of a circle is computed using...
Row 6 Q3 95
Row 7 Q4 @^(#^@

SUBMIT BUTTON (this button forwards the data to Sheet 2 and clears the fields populated earlier.

Sheet 2

Column A Column B Column C Column D Column E Column F Column G
Name Age Q1 Q2 Q3 Q4
Name 1 Age 1 Q1-1 Q2-1 Q3-1 Q4-1
Name 2 Age 2 Q1-2 Q2-2 Q3-2 Q4-2


=) I know I'm just new here but I hope some feedback on this as I need to automate some work I do :D

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jul 4, 2013 at 11:38 AM
Hi Bebongtheshark,

You showed some confusing looking data, but no question (or did I miss it).

Try using a filesharing site like www.speedyshare.com or ge.tt to upload your file (don't forget to post back the download link).

Clearly show or explain what you are trying to achieve.

Best regards,
Trowa
0