Sub Bookshelf()
'
' Bookshelf Macro
' Move Data To Total Sheets
'
'
ActiveWindow.SmallScroll Down:=27
Range("A229:J233").Select
Selection.Copy
Sheets("Hardware Total").Select
ActiveWindow.SmallScroll Down:=-15
Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(4, 10).Range("A1").Select
Sheets("Data Entry").Select
ActiveWindow.SmallScroll Down:=-9
Range("A207:J215").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Plam Total").Select
ActiveWindow.SmallScroll Down:=-12
Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(2, 10).Range("A1").Select
Sheets("Data Entry").Select
ActiveWindow.SmallScroll Down:=-6
Range("A195:J204").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Wood Total").Select
ActiveWindow.SmallScroll Down:=-12
Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(5, 10).Range("A1").Select
Sheets("Data Entry").Select
ActiveWindow.SmallScroll Down:=-12
Range("B180").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
Range("B182").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("B1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
Range("F183").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("C1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
Range("B183").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("D1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
Range("B184").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("E1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
Range("B185").Select
Application.CutCopyMode = False
Selection.Copy
ActiveWindow.SmallScroll Down:=0
Sheets("Cabinet Total").Select
Range("F1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
ActiveWindow.SmallScroll Down:=6
Range("C185").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("G1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
Range("E198").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("H1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
Range("F198").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("I1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Data Entry").Select
ActiveWindow.SmallScroll Down:=-6
Range("B179").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Cabinet Total").Select
Range("J1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("A1").Select
Sheets("Data Entry").Select
Range("C179").Select
Application.CutCopyMode = False
Union(Sheets("Data Entry").Range("B180"), Sheets("Data Entry").Range("B182")).Value = "0"
End Sub
Bookmarks