May 18 2022 03:18 PM
How can you copy a spreadsheet and increase the valued cells by 2%? Is there a formula for this specific action?
May 19 2022 12:09 AM
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
I know I don't know anything (Socrates)