Forum Discussion

llchappell2's avatar
llchappell2
Copper Contributor
May 18, 2022

Copy a sheet with values increased by 2%

How can you copy a spreadsheet and increase the valued cells by 2%?  Is there a formula for this specific action?

excel
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    May 19, 2022

    llchappell2 

    Maybe with VBA?

    Worksbooks.Open Filename:=PathAndNameOverview.xls
With Sheets("YourSheet").Cells(Cells(Rows.Count, 2).End(xlUp).Row, 2)
   .Value = .Value + 0.02
   Workbooks("Acquisition").ActiveSheet.Range("A1:B5").Value = .Value
End With
ActiveWorkbook.Close SaveChanges:=True

    untested

     

    If I may recommend, always include information about your Excel version, operating system and storage medium in your message.
    It would be an advantage if you insert a file (without sensitive data) or a photo and use this to explain your project step by step. This way you could get a suggested solution much faster and more accurately and the helper doesn't need to waste his time guessing.

     

    Thank you for your patience and understanding

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Resources