Automatic collection process Free Excel Macros (VBA) | Excel Programs

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
Sub Autosum()

Dim A As Double
Dim B As Double
Dim C As Double
Dim D As Double

A = WorksheetFunction.Sum(Range("C2").Value, Range("J2").Value)
B = WorksheetFunction.Sum(Range("C3").Value, Range("J3").Value)
C = WorksheetFunction.Sum(Range("C4").Value, Range("J4").Value)
D = WorksheetFunction.Sum(Range("C5").Value, Range("J5").Value)

Range("C2").Value = A
Range("C3").Value = B
Range("C4").Value = C
Range("C5").Value = D

Range("D2").Value = WorksheetFunction.Product(Range("C2").Value, Range("B2").Value)
Range("D3").Value = WorksheetFunction.Product(Range("C3").Value, Range("B3").Value)
Range("D4").Value = WorksheetFunction.Product(Range("C2").Value, Range("B4").Value)
Range("D5").Value = WorksheetFunction.Product(Range("C2").Value, Range("B5").Value)

Range("J2").Value = Range("C2").Value
Range("J3").Value = Range("C3").Value
Range("J4").Value = Range("C4").Value
Range("J5").Value = Range("C5").Value

End Sub

No	Macro Name
1	Automatic collection process
2	excel operators hk
3	class module retrieval
4	Opening internet explorer in Excel
5	macros automatic opening work closure
6	automatic opening and operation of the macro
7	prints all sheet / pages with data or scans but does not print
8	a macro that automatically deletes the following month-old sheet / pages before moving to the new month when the specified month is over
9	Let calculations from column a to column g (except g) calculate other open columns by pressing the button
10	hide and show half of a picture
11	sheet / page address and set column width
12	Remove Text Wrap: This code will help you remove text wrap across the entire worksheet with a single click. first selects all columns and then removes the text wrap and automatically fits all rows and columns.
13	Automatically resize row width when cells are merged
14	button protection
15	Highlight the Top 10 Values: Select a range and run this macro and highlight the top 10 values with green.
16	Numbers and codes from a1 to b1
17	cell-related codes
18	copies active sheet / page email
19	border in macro?
20	excellent menu insert file menu print print preview sheet / page structure remains

Excel Free Macros (VBA)

Automatic Collection Process

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords