Public Sub Copy_Values_Formats_and_Column_Widths()
Dim destCell As Range
Set destCell = Worksheets("Sheet2").Cells(Rows.Count, "A").End(xlUp)
If destCell.Row > 1 Then Set destCell = destCell.Offset(1)
Worksheets("Bagwan Compu Data Entry").Range("A29:E29").Copy...
There are two sheets in the excel file named "Initialization" & "Inventory Management".
A shopkeeper enter date, product . quantity sold & purchased quantity with "-" minus sign. Now I have to enter a formulae in "remaining quantity" header column to get the balance quantity of item.
I have two sheets in attached sample file.
"today" & "summary"
I have to send data from "today" worksheet to "summary" worksheet on clicking add button. For example in attached sheet, data from "today" sheet to be entered on clicking add button.
how to send data from one sheet to empty row of...