Excel 2010 - copy filled in cells
Closed
Chris
-
May 10, 2012 at 09:36 AM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Excel 2010 - copy filled in cells
- Grey out an entire row in Excel 2010 depending on a cell's value ✓ - Forum - Excel
- How to Lock or password protected specific cell in excel 2010 ✓ - Forum - Excel
- Excel, filling in cell values automatically ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Spellnumber in rupees in excel 2010 - Forum - Office Software
1 reply
TrowaD
May 10, 2012 at 10:10 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
May 10, 2012 at 10:10 AM
Hi Chris,
So you would like to check a specific range for data. When data is found copy each cell to a single column on another sheet. If this is true then the following should work for you:
Best regards,
Trowa
So you would like to check a specific range for data. When data is found copy each cell to a single column on another sheet. If this is true then the following should work for you:
Sub MoveData() For Each cell In Sheets("Sheet1").Range("A2:C10") If cell.Value <> vbNullString Then cell.Copy _ Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0) Next cell End Sub
Best regards,
Trowa