Hi there
I am using the following macro which one of the board member helped me with to copy and paste certain info from one sheet to another. The macro I am using is
Is it possible to copy the value of B2 in the sheet (Invoice) as well and paste it for as many entries there are in the rows 4:17 in the sheet "Transactions". For example say i have items in row 4:10 when it copies the info to the sheet Transactions then it must copy the entry that is in B2 on sheet Invoice also in column a 4:10. Hope i make sense.
I am using the following macro which one of the board member helped me with to copy and paste certain info from one sheet to another. The macro I am using is
Code:
Sub test()
With Sheets("Invoice")
.Range("A4:C17").Copy
Sheets("Transactions").Range("b" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues
End With
End Sub
Is it possible to copy the value of B2 in the sheet (Invoice) as well and paste it for as many entries there are in the rows 4:17 in the sheet "Transactions". For example say i have items in row 4:10 when it copies the info to the sheet Transactions then it must copy the entry that is in B2 on sheet Invoice also in column a 4:10. Hope i make sense.