Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here in this code i am copy data from 1 sheet to other sheet, but there is no
data in Finish per day sheet than also it's copy into Consumption sheet. how do i copy only data which is available. Sub Register_Finish_Per_Day() Dim lrow As Long lrow = Sheets("Finish Per Day").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row Worksheets("Finish Per Day").Range("A" & lrow).Value = _ Worksheets("Consumption Per Day").Range("A2").Value Worksheets("Finish Per Day").Range("B" & lrow).Value = _ Worksheets("Consumption Per Day").Range("A4").Value Worksheets("Finish Per Day").Range("C" & lrow).Value = _ Worksheets("Consumption Per Day").Range("B4").Value lrow = Sheets("Finish Per Day").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row Worksheets("Finish Per Day").Range("A" & lrow).Value = _ Worksheets("Consumption Per Day").Range("A2").Value Worksheets("Finish Per Day").Range("B" & lrow).Value = _ Worksheets("Consumption Per Day").Range("A5").Value Worksheets("Finish Per Day").Range("C" & lrow).Value = _ Worksheets("Consumption Per Day").Range("B5").Value lrow = Sheets("Finish Per Day").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row Worksheets("Finish Per Day").Range("A" & lrow).Value = _ Worksheets("Consumption Per Day").Range("A2").Value Worksheets("Finish Per Day").Range("B" & lrow).Value = _ Worksheets("Consumption Per Day").Range("A6").Value Worksheets("Finish Per Day").Range("C" & lrow).Value = _ Worksheets("Consumption Per Day").Range("B6").Value end sub Thanks Tiya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
Copy data into cells until changes trigger new copy | Excel Programming |