JCKTDS123456
New Member
- Joined
- Mar 14, 2016
- Messages
- 4
Sir right now i got vba code.....but can we set two macro in a single excel sheet...
The following code solved my Single problem.
Sub Copy_Paste_Data()
Sheets("Sheet1").Range("A3:<wbr>N1000").Copy Destination:=Sheets("Sheet2").<wbr>Range("A" & Rows.Count).End(xlUp).Offset(<wbr>1, 0)
End Sub
I shall use the above code when I have to export all all kind of data from A3 to N1000. But If I don't want to export the data having no value in column I. If Column I has no value so that row will not be exported to Sheet2...
What I mean to say that if I need all data to export then I shall use the above code and When I need to export data having value in column I then I shall use that code for i am requesting you to make.
So this way my grave problem will be solved..........
The following code solved my Single problem.
Sub Copy_Paste_Data()
Sheets("Sheet1").Range("A3:<wbr>N1000").Copy Destination:=Sheets("Sheet2").<wbr>Range("A" & Rows.Count).End(xlUp).Offset(<wbr>1, 0)
End Sub
I shall use the above code when I have to export all all kind of data from A3 to N1000. But If I don't want to export the data having no value in column I. If Column I has no value so that row will not be exported to Sheet2...
What I mean to say that if I need all data to export then I shall use the above code and When I need to export data having value in column I then I shall use that code for i am requesting you to make.
So this way my grave problem will be solved..........