Michaelstef
New Member
- Joined
- Jun 5, 2018
- Messages
- 5
Dear Sir or Madam,
I am looking for a VBA Excel Makro with the following action:
I have an excel workbook with many sheets. They are all set-up the same way.
I need to copy&Past always the last row within a sheet with the formula and copy&Past thereafter the row above with Value within the same sheet.
Example:
C7:D7 pull formula to C8:D8
O7
7 pull formula to o8
8
r7:r7 pull formula to r8:r8
thereafter:
C7:D7 copy&past as values
O7
7 copy&paste as values
r7:r7 copy&paste as values
It should always automaically go to the last row and has many sheets, alls set up the same way, besides the first sheet.
Thanks in advance for your support.
Best regards
I am looking for a VBA Excel Makro with the following action:
I have an excel workbook with many sheets. They are all set-up the same way.
I need to copy&Past always the last row within a sheet with the formula and copy&Past thereafter the row above with Value within the same sheet.
Example:
C7:D7 pull formula to C8:D8
O7


r7:r7 pull formula to r8:r8
thereafter:
C7:D7 copy&past as values
O7

r7:r7 copy&paste as values
It should always automaically go to the last row and has many sheets, alls set up the same way, besides the first sheet.
Thanks in advance for your support.
Best regards