Copy a sheet with values increased by 2%

Copper Contributor

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

1 Reply

@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)