Fairly simple one hopefully but only new to excel. Do not have any knowledge of defining variables and the like but have taken a stab.
Data in multiple rows is generated in the (3)Accounts spreadsheet according to data in row 2 of (1)National Spreadsheet. As such all values in accounts are from formulas and will change upon the changing of corresponding values in (1)National. The idea is to copy the entire row for the specific member in the accounts sheet and paste only the values in its exact place. The row that is specific to that member is identified by a matching invoice number in the sheet (1)National in cell T2.
Obviously the code below isn't right otherwise it would work but you can hopefully see what kind of logic I'm trying to step through to achieve this, any help would be greatly appreciated.
Sub Accounts_Button3_Click()
Dim MemberRow As Long
Dim Inv As Long
Inv = Sheets("(1)National").Range("T2")
MemberRow = Sheets(“(3)Accounts”).Cells.Find(What:=Inv, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).EntireRow
Sheets("(3)Accounts").Range(MemberRow).Copy
Sheets("(3)Accounts").Range(MemberRow).PasteSpecial xlPasteValues
End Sub
Display More