I have a sheet named Entry and a sheet named Wood Total. When i click on a button with macro on the Entry Sheet it will send all data to the Wood Total sheet. I only want to copy rows with a value greater than 0 in column C. Can this code be modified to do this?
Data.pdf
ActiveCell.Offset(4, 10).Range("A1").Select
Sheets("Entry").Select
ActiveWindow.SmallScroll Down:=-9
Range("A1:J24").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Wood Total").Select
ActiveWindow.SmallScroll Down:=-9
Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Bookmarks