logo.jpg
Hi everyone, I have been following this website for a while and it solved many of my excel issues. Right now, I started to got involved with Excel Macro. I am just a beginner for excel macro and most of the stuff is pretty complicated at the moment. I started to create some surveys on excel. However, I want to store the entities in another worksheet. Is there anyway to assign specific rows and columns to another worksheet? (Even though they are merged!!!!) When the participant enters data, it will store it in another worksheet. It will simply transfer the data another worksheet. The complicated part is that most of the columns and rows are merged.
Similar Code I was trying to use
Sub move_worksheet()
RowCount=Sheet1.UsedRange.Rows.Count
Range("a1:" & "a2" & RowCount).Select
Range("a1:" & "a2" & RowCount).Select
RowCount=Sheet2.UsedRange.Rows.Count
Range("a1:" & "a2" & RowCount).Select
Range("a1:" & "a2" & RowCount).Select
With Selection
.Copy
Ebd With
Sheets("Sheet3").Select
Range("a2").Select
ActiveCell.PasteSpecial (xlPasteAll)
End Sub
However, it does not work
I just wonder if this process is possible because the data comes from merged rows and columns. However, I plan to use this code for 19 worksheet and cobine all the data in one worksheet.
If it is possible and someone can provide a sample, I can finish the rest.
Thanks a lot
Bookmarks