Macro to transfer data from one sheet to another

Closed
Posts
1
Registration date
Thursday July 4, 2013
Status
Member
Last seen
July 4, 2013
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
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 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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