ifeelalone
New Member
- Joined
- Mar 6, 2017
- Messages
- 31
Hey everyone,
Need help in moving rows from "Sheet1" to data table of "Sheet2"
Contents of Sheet 1
if I hit a button, or run a vba, contents from row 2 will be transferred to Sheet 2. Like this:
for multiple rows of Sheet 1, like this
they will be transferred to Sheet 2. Like this:
Need help in moving rows from "Sheet1" to data table of "Sheet2"
Contents of Sheet 1
![611463d1550233878-move-row-values-then-paste-to-data-table-1-row.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fattachments%2Fexcel-programming-vba-macros%2F611463d1550233878-move-row-values-then-paste-to-data-table-1-row.jpg&hash=a933b3e2e4fd715e1683bece4ec447a5)
if I hit a button, or run a vba, contents from row 2 will be transferred to Sheet 2. Like this:
![611464d1550233898-move-row-values-then-paste-to-data-table-1-transform.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fattachments%2Fexcel-programming-vba-macros%2F611464d1550233898-move-row-values-then-paste-to-data-table-1-transform.jpg&hash=7bf830035e959393dade76914861de50)
for multiple rows of Sheet 1, like this
![611465d1550233952-move-row-values-then-paste-to-data-table-2-rows.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fattachments%2Fexcel-programming-vba-macros%2F611465d1550233952-move-row-values-then-paste-to-data-table-2-rows.jpg&hash=ee2e6b5e28d70f54f6dec9eeea3ad76a)
they will be transferred to Sheet 2. Like this:
![611466d1550233988-move-row-values-then-paste-to-data-table-2-transform.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fattachments%2Fexcel-programming-vba-macros%2F611466d1550233988-move-row-values-then-paste-to-data-table-2-transform.jpg&hash=acbfd04700de9727e4203725aa368f33)